| 15892 | | private global::System.Data.DataColumn columnidKlienta; |
| 15893 | | |
| 15894 | | private global::System.Data.DataColumn columnwartoscNettoPoRabacie; |
| 15895 | | |
| 15896 | | private global::System.Data.DataColumn columnDoZafakturowania; |
| 15897 | | |
| 15898 | | private global::System.Data.DataColumn columnkodKlienta; |
| 15899 | | |
| 15900 | | private global::System.Data.DataColumn columnnr; |
| 15901 | | |
| 15902 | | private global::System.Data.DataColumn columnkodAgenta; |
| 15903 | | |
| 15904 | | private global::System.Data.DataColumn columnrokZamowienia; |
| 15905 | | |
| 15906 | | private global::System.Data.DataColumn columnwartoscNetto; |
| 15907 | | |
| 15908 | | private global::System.Data.DataColumn columnAgent; |
| 15909 | | |
| 15910 | | private global::System.Data.DataColumn columnAgencja; |
| | 15900 | private global::System.Data.DataColumn columnnrZamowieniaExt; |
| | 15901 | |
| | 15902 | private global::System.Data.DataColumn columniloscReklam; |
| | 15903 | |
| | 15904 | private global::System.Data.DataColumn columnkwotaWalutaBrutto; |
| | 15905 | |
| | 15906 | private global::System.Data.DataColumn columndata_od; |
| | 15907 | |
| | 15908 | private global::System.Data.DataColumn columndata_od_bez_FK; |
| | 15909 | |
| | 15910 | private global::System.Data.DataColumn columnnettoZafakturowane; |
| 15950 | | public global::System.Data.DataColumn iloscColumn { |
| 15951 | | get { |
| 15952 | | return this.columnilosc; |
| 15953 | | } |
| 15954 | | } |
| 15955 | | |
| 15956 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 15957 | | public global::System.Data.DataColumn wartoscNettoZafakturowanaColumn { |
| 15958 | | get { |
| 15959 | | return this.columnwartoscNettoZafakturowana; |
| 15960 | | } |
| 15961 | | } |
| 15962 | | |
| 15963 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 15964 | | public global::System.Data.DataColumn UserNameColumn { |
| 15965 | | get { |
| 15966 | | return this.columnUserName; |
| | 15950 | public global::System.Data.DataColumn idKlientaColumn { |
| | 15951 | get { |
| | 15952 | return this.columnidKlienta; |
| | 15953 | } |
| | 15954 | } |
| | 15955 | |
| | 15956 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 15957 | public global::System.Data.DataColumn DoZafakturowaniaColumn { |
| | 15958 | get { |
| | 15959 | return this.columnDoZafakturowania; |
| | 15960 | } |
| | 15961 | } |
| | 15962 | |
| | 15963 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 15964 | public global::System.Data.DataColumn kodAgentaColumn { |
| | 15965 | get { |
| | 15966 | return this.columnkodAgenta; |
| | 15967 | } |
| | 15968 | } |
| | 15969 | |
| | 15970 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 15971 | public global::System.Data.DataColumn rokZamowieniaColumn { |
| | 15972 | get { |
| | 15973 | return this.columnrokZamowienia; |
| | 15974 | } |
| | 15975 | } |
| | 15976 | |
| | 15977 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 15978 | public global::System.Data.DataColumn wartoscNettoColumn { |
| | 15979 | get { |
| | 15980 | return this.columnwartoscNetto; |
| | 15981 | } |
| | 15982 | } |
| | 15983 | |
| | 15984 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 15985 | public global::System.Data.DataColumn agencjaColumn { |
| | 15986 | get { |
| | 15987 | return this.columnagencja; |
| | 15988 | } |
| | 15989 | } |
| | 15990 | |
| | 15991 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 15992 | public global::System.Data.DataColumn agentColumn { |
| | 15993 | get { |
| | 15994 | return this.columnagent; |
| 15978 | | public global::System.Data.DataColumn idKlientaColumn { |
| 15979 | | get { |
| 15980 | | return this.columnidKlienta; |
| 15981 | | } |
| 15982 | | } |
| 15983 | | |
| 15984 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 15985 | | public global::System.Data.DataColumn wartoscNettoPoRabacieColumn { |
| 15986 | | get { |
| 15987 | | return this.columnwartoscNettoPoRabacie; |
| 15988 | | } |
| 15989 | | } |
| 15990 | | |
| 15991 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 15992 | | public global::System.Data.DataColumn DoZafakturowaniaColumn { |
| 15993 | | get { |
| 15994 | | return this.columnDoZafakturowania; |
| 15995 | | } |
| 15996 | | } |
| 15997 | | |
| 15998 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 15999 | | public global::System.Data.DataColumn kodKlientaColumn { |
| 16000 | | get { |
| 16001 | | return this.columnkodKlienta; |
| 16002 | | } |
| 16003 | | } |
| 16004 | | |
| 16005 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 16006 | | public global::System.Data.DataColumn nrColumn { |
| 16007 | | get { |
| 16008 | | return this.columnnr; |
| 16009 | | } |
| 16010 | | } |
| 16011 | | |
| 16012 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 16013 | | public global::System.Data.DataColumn kodAgentaColumn { |
| 16014 | | get { |
| 16015 | | return this.columnkodAgenta; |
| 16016 | | } |
| 16017 | | } |
| 16018 | | |
| 16019 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 16020 | | public global::System.Data.DataColumn rokZamowieniaColumn { |
| 16021 | | get { |
| 16022 | | return this.columnrokZamowienia; |
| 16023 | | } |
| 16024 | | } |
| 16025 | | |
| 16026 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 16027 | | public global::System.Data.DataColumn wartoscNettoColumn { |
| 16028 | | get { |
| 16029 | | return this.columnwartoscNetto; |
| 16030 | | } |
| 16031 | | } |
| 16032 | | |
| 16033 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 16034 | | public global::System.Data.DataColumn AgentColumn { |
| 16035 | | get { |
| 16036 | | return this.columnAgent; |
| 16037 | | } |
| 16038 | | } |
| 16039 | | |
| 16040 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 16041 | | public global::System.Data.DataColumn AgencjaColumn { |
| 16042 | | get { |
| 16043 | | return this.columnAgencja; |
| | 16006 | public global::System.Data.DataColumn nrZamowieniaExtColumn { |
| | 16007 | get { |
| | 16008 | return this.columnnrZamowieniaExt; |
| | 16009 | } |
| | 16010 | } |
| | 16011 | |
| | 16012 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 16013 | public global::System.Data.DataColumn iloscReklamColumn { |
| | 16014 | get { |
| | 16015 | return this.columniloscReklam; |
| | 16016 | } |
| | 16017 | } |
| | 16018 | |
| | 16019 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 16020 | public global::System.Data.DataColumn kwotaWalutaBruttoColumn { |
| | 16021 | get { |
| | 16022 | return this.columnkwotaWalutaBrutto; |
| | 16023 | } |
| | 16024 | } |
| | 16025 | |
| | 16026 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 16027 | public global::System.Data.DataColumn data_odColumn { |
| | 16028 | get { |
| | 16029 | return this.columndata_od; |
| | 16030 | } |
| | 16031 | } |
| | 16032 | |
| | 16033 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 16034 | public global::System.Data.DataColumn data_od_bez_FKColumn { |
| | 16035 | get { |
| | 16036 | return this.columndata_od_bez_FK; |
| | 16037 | } |
| | 16038 | } |
| | 16039 | |
| | 16040 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 16041 | public global::System.Data.DataColumn nettoZafakturowaneColumn { |
| | 16042 | get { |
| | 16043 | return this.columnnettoZafakturowane; |
| 16076 | | public VIEW_ZESTAWIENIE_ZAMOWIEN_NOWERow AddVIEW_ZESTAWIENIE_ZAMOWIEN_NOWERow(int idZamowienia, int ilosc, double wartoscNettoZafakturowana, string UserName, string nrZamowienia, int idKlienta, double wartoscNettoPoRabacie, double DoZafakturowania, string kodKlienta, int nr, string kodAgenta, int rokZamowienia, double wartoscNetto, string Agent, string Agencja) { |
| | 16076 | public VIEW_ZESTAWIENIE_ZAMOWIEN_NOWERow AddVIEW_ZESTAWIENIE_ZAMOWIEN_NOWERow(int idZamowienia, int idKlienta, double DoZafakturowania, string kodAgenta, int rokZamowienia, double wartoscNetto, string agencja, string agent, int nrZamowienia, string nrZamowieniaExt, int iloscReklam, double kwotaWalutaBrutto, System.DateTime data_od, System.DateTime data_od_bez_FK, double nettoZafakturowane) { |
| 16139 | | this.columnilosc = new global::System.Data.DataColumn("ilosc", typeof(int), null, global::System.Data.MappingType.Element); |
| 16140 | | base.Columns.Add(this.columnilosc); |
| 16141 | | this.columnwartoscNettoZafakturowana = new global::System.Data.DataColumn("wartoscNettoZafakturowana", typeof(double), null, global::System.Data.MappingType.Element); |
| 16142 | | base.Columns.Add(this.columnwartoscNettoZafakturowana); |
| 16143 | | this.columnUserName = new global::System.Data.DataColumn("UserName", typeof(string), null, global::System.Data.MappingType.Element); |
| 16144 | | base.Columns.Add(this.columnUserName); |
| 16145 | | this.columnnrZamowienia = new global::System.Data.DataColumn("nrZamowienia", typeof(string), null, global::System.Data.MappingType.Element); |
| 16146 | | base.Columns.Add(this.columnnrZamowienia); |
| 16163 | | this.columnAgent = new global::System.Data.DataColumn("Agent", typeof(string), null, global::System.Data.MappingType.Element); |
| 16164 | | base.Columns.Add(this.columnAgent); |
| 16165 | | this.columnAgencja = new global::System.Data.DataColumn("Agencja", typeof(string), null, global::System.Data.MappingType.Element); |
| 16166 | | base.Columns.Add(this.columnAgencja); |
| | 16155 | this.columnagencja = new global::System.Data.DataColumn("agencja", typeof(string), null, global::System.Data.MappingType.Element); |
| | 16156 | base.Columns.Add(this.columnagencja); |
| | 16157 | this.columnagent = new global::System.Data.DataColumn("agent", typeof(string), null, global::System.Data.MappingType.Element); |
| | 16158 | base.Columns.Add(this.columnagent); |
| | 16159 | this.columnnrZamowienia = new global::System.Data.DataColumn("nrZamowienia", typeof(int), null, global::System.Data.MappingType.Element); |
| | 16160 | base.Columns.Add(this.columnnrZamowienia); |
| | 16161 | this.columnnrZamowieniaExt = new global::System.Data.DataColumn("nrZamowieniaExt", typeof(string), null, global::System.Data.MappingType.Element); |
| | 16162 | base.Columns.Add(this.columnnrZamowieniaExt); |
| | 16163 | this.columniloscReklam = new global::System.Data.DataColumn("iloscReklam", typeof(int), null, global::System.Data.MappingType.Element); |
| | 16164 | base.Columns.Add(this.columniloscReklam); |
| | 16165 | this.columnkwotaWalutaBrutto = new global::System.Data.DataColumn("kwotaWalutaBrutto", typeof(double), null, global::System.Data.MappingType.Element); |
| | 16166 | base.Columns.Add(this.columnkwotaWalutaBrutto); |
| | 16167 | this.columndata_od = new global::System.Data.DataColumn("data_od", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element); |
| | 16168 | base.Columns.Add(this.columndata_od); |
| | 16169 | this.columndata_od_bez_FK = new global::System.Data.DataColumn("data_od_bez_FK", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element); |
| | 16170 | base.Columns.Add(this.columndata_od_bez_FK); |
| | 16171 | this.columnnettoZafakturowane = new global::System.Data.DataColumn("nettoZafakturowane", typeof(double), null, global::System.Data.MappingType.Element); |
| | 16172 | base.Columns.Add(this.columnnettoZafakturowane); |
| | 16173 | this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] { |
| | 16174 | this.columnidZamowienia}, true)); |
| 29670 | | public int ilosc { |
| 29671 | | get { |
| 29672 | | try { |
| 29673 | | return ((int)(this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.iloscColumn])); |
| 29674 | | } |
| 29675 | | catch (global::System.InvalidCastException e) { |
| 29676 | | throw new global::System.Data.StrongTypingException("The value for column \'ilosc\' in table \'VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE\' is DBNull." + |
| 29677 | | "", e); |
| 29678 | | } |
| 29679 | | } |
| 29680 | | set { |
| 29681 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.iloscColumn] = value; |
| 29682 | | } |
| 29683 | | } |
| 29684 | | |
| 29685 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29686 | | public double wartoscNettoZafakturowana { |
| 29687 | | get { |
| 29688 | | try { |
| 29689 | | return ((double)(this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.wartoscNettoZafakturowanaColumn])); |
| 29690 | | } |
| 29691 | | catch (global::System.InvalidCastException e) { |
| 29692 | | throw new global::System.Data.StrongTypingException("The value for column \'wartoscNettoZafakturowana\' in table \'VIEW_ZESTAWIENIE_ZAMOW" + |
| 29693 | | "IEN_NOWE\' is DBNull.", e); |
| 29694 | | } |
| 29695 | | } |
| 29696 | | set { |
| 29697 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.wartoscNettoZafakturowanaColumn] = value; |
| 29698 | | } |
| 29699 | | } |
| 29700 | | |
| 29701 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29702 | | public string UserName { |
| 29703 | | get { |
| 29704 | | try { |
| 29705 | | return ((string)(this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.UserNameColumn])); |
| 29706 | | } |
| 29707 | | catch (global::System.InvalidCastException e) { |
| 29708 | | throw new global::System.Data.StrongTypingException("The value for column \'UserName\' in table \'VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE\' is DBNu" + |
| 29709 | | "ll.", e); |
| 29710 | | } |
| 29711 | | } |
| 29712 | | set { |
| 29713 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.UserNameColumn] = value; |
| 29714 | | } |
| 29715 | | } |
| 29716 | | |
| 29717 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29718 | | public string nrZamowienia { |
| 29719 | | get { |
| 29720 | | try { |
| 29721 | | return ((string)(this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.nrZamowieniaColumn])); |
| 29722 | | } |
| 29723 | | catch (global::System.InvalidCastException e) { |
| 29724 | | throw new global::System.Data.StrongTypingException("The value for column \'nrZamowienia\' in table \'VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE\' is " + |
| 29725 | | "DBNull.", e); |
| 29726 | | } |
| 29727 | | } |
| 29728 | | set { |
| 29729 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.nrZamowieniaColumn] = value; |
| 29730 | | } |
| 29731 | | } |
| 29732 | | |
| 29733 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29866 | | throw new global::System.Data.StrongTypingException("The value for column \'Agencja\' in table \'VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE\' is DBNul" + |
| | 29789 | throw new global::System.Data.StrongTypingException("The value for column \'nrZamowieniaExt\' in table \'VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE\' " + |
| | 29790 | "is DBNull.", e); |
| | 29791 | } |
| | 29792 | } |
| | 29793 | set { |
| | 29794 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.nrZamowieniaExtColumn] = value; |
| | 29795 | } |
| | 29796 | } |
| | 29797 | |
| | 29798 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29799 | public int iloscReklam { |
| | 29800 | get { |
| | 29801 | try { |
| | 29802 | return ((int)(this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.iloscReklamColumn])); |
| | 29803 | } |
| | 29804 | catch (global::System.InvalidCastException e) { |
| | 29805 | throw new global::System.Data.StrongTypingException("The value for column \'iloscReklam\' in table \'VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE\' is D" + |
| | 29806 | "BNull.", e); |
| | 29807 | } |
| | 29808 | } |
| | 29809 | set { |
| | 29810 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.iloscReklamColumn] = value; |
| | 29811 | } |
| | 29812 | } |
| | 29813 | |
| | 29814 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29815 | public double kwotaWalutaBrutto { |
| | 29816 | get { |
| | 29817 | try { |
| | 29818 | return ((double)(this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.kwotaWalutaBruttoColumn])); |
| | 29819 | } |
| | 29820 | catch (global::System.InvalidCastException e) { |
| | 29821 | throw new global::System.Data.StrongTypingException("The value for column \'kwotaWalutaBrutto\' in table \'VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE" + |
| | 29822 | "\' is DBNull.", e); |
| | 29823 | } |
| | 29824 | } |
| | 29825 | set { |
| | 29826 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.kwotaWalutaBruttoColumn] = value; |
| | 29827 | } |
| | 29828 | } |
| | 29829 | |
| | 29830 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29831 | public System.DateTime data_od { |
| | 29832 | get { |
| | 29833 | try { |
| | 29834 | return ((global::System.DateTime)(this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.data_odColumn])); |
| | 29835 | } |
| | 29836 | catch (global::System.InvalidCastException e) { |
| | 29837 | throw new global::System.Data.StrongTypingException("The value for column \'data_od\' in table \'VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE\' is DBNul" + |
| 29871 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.AgencjaColumn] = value; |
| 29872 | | } |
| 29873 | | } |
| 29874 | | |
| 29875 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29876 | | public bool IsiloscNull() { |
| 29877 | | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.iloscColumn); |
| 29878 | | } |
| 29879 | | |
| 29880 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29881 | | public void SetiloscNull() { |
| 29882 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.iloscColumn] = global::System.Convert.DBNull; |
| 29883 | | } |
| 29884 | | |
| 29885 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29886 | | public bool IswartoscNettoZafakturowanaNull() { |
| 29887 | | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.wartoscNettoZafakturowanaColumn); |
| 29888 | | } |
| 29889 | | |
| 29890 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29891 | | public void SetwartoscNettoZafakturowanaNull() { |
| 29892 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.wartoscNettoZafakturowanaColumn] = global::System.Convert.DBNull; |
| 29893 | | } |
| 29894 | | |
| 29895 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29896 | | public bool IsUserNameNull() { |
| 29897 | | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.UserNameColumn); |
| 29898 | | } |
| 29899 | | |
| 29900 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29901 | | public void SetUserNameNull() { |
| 29902 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.UserNameColumn] = global::System.Convert.DBNull; |
| 29903 | | } |
| 29904 | | |
| 29905 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29906 | | public bool IsnrZamowieniaNull() { |
| 29907 | | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.nrZamowieniaColumn); |
| 29908 | | } |
| 29909 | | |
| 29910 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29911 | | public void SetnrZamowieniaNull() { |
| 29912 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.nrZamowieniaColumn] = global::System.Convert.DBNull; |
| 29913 | | } |
| 29914 | | |
| 29915 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29916 | | public bool IswartoscNettoPoRabacieNull() { |
| 29917 | | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.wartoscNettoPoRabacieColumn); |
| 29918 | | } |
| 29919 | | |
| 29920 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29921 | | public void SetwartoscNettoPoRabacieNull() { |
| 29922 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.wartoscNettoPoRabacieColumn] = global::System.Convert.DBNull; |
| | 29842 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.data_odColumn] = value; |
| | 29843 | } |
| | 29844 | } |
| | 29845 | |
| | 29846 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29847 | public System.DateTime data_od_bez_FK { |
| | 29848 | get { |
| | 29849 | try { |
| | 29850 | return ((global::System.DateTime)(this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.data_od_bez_FKColumn])); |
| | 29851 | } |
| | 29852 | catch (global::System.InvalidCastException e) { |
| | 29853 | throw new global::System.Data.StrongTypingException("The value for column \'data_od_bez_FK\' in table \'VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE\' i" + |
| | 29854 | "s DBNull.", e); |
| | 29855 | } |
| | 29856 | } |
| | 29857 | set { |
| | 29858 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.data_od_bez_FKColumn] = value; |
| | 29859 | } |
| | 29860 | } |
| | 29861 | |
| | 29862 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29863 | public double nettoZafakturowane { |
| | 29864 | get { |
| | 29865 | try { |
| | 29866 | return ((double)(this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.nettoZafakturowaneColumn])); |
| | 29867 | } |
| | 29868 | catch (global::System.InvalidCastException e) { |
| | 29869 | throw new global::System.Data.StrongTypingException("The value for column \'nettoZafakturowane\' in table \'VIEW_ZESTAWIENIE_ZAMOWIEN_NOW" + |
| | 29870 | "E\' is DBNull.", e); |
| | 29871 | } |
| | 29872 | } |
| | 29873 | set { |
| | 29874 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.nettoZafakturowaneColumn] = value; |
| | 29875 | } |
| 29966 | | public bool IsAgentNull() { |
| 29967 | | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.AgentColumn); |
| 29968 | | } |
| 29969 | | |
| 29970 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29971 | | public void SetAgentNull() { |
| 29972 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.AgentColumn] = global::System.Convert.DBNull; |
| 29973 | | } |
| 29974 | | |
| 29975 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29976 | | public bool IsAgencjaNull() { |
| 29977 | | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.AgencjaColumn); |
| 29978 | | } |
| 29979 | | |
| 29980 | | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| 29981 | | public void SetAgencjaNull() { |
| 29982 | | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.AgencjaColumn] = global::System.Convert.DBNull; |
| | 29909 | public bool IsagencjaNull() { |
| | 29910 | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.agencjaColumn); |
| | 29911 | } |
| | 29912 | |
| | 29913 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29914 | public void SetagencjaNull() { |
| | 29915 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.agencjaColumn] = global::System.Convert.DBNull; |
| | 29916 | } |
| | 29917 | |
| | 29918 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29919 | public bool IsagentNull() { |
| | 29920 | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.agentColumn); |
| | 29921 | } |
| | 29922 | |
| | 29923 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29924 | public void SetagentNull() { |
| | 29925 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.agentColumn] = global::System.Convert.DBNull; |
| | 29926 | } |
| | 29927 | |
| | 29928 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29929 | public bool IsnrZamowieniaExtNull() { |
| | 29930 | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.nrZamowieniaExtColumn); |
| | 29931 | } |
| | 29932 | |
| | 29933 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29934 | public void SetnrZamowieniaExtNull() { |
| | 29935 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.nrZamowieniaExtColumn] = global::System.Convert.DBNull; |
| | 29936 | } |
| | 29937 | |
| | 29938 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29939 | public bool IsiloscReklamNull() { |
| | 29940 | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.iloscReklamColumn); |
| | 29941 | } |
| | 29942 | |
| | 29943 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29944 | public void SetiloscReklamNull() { |
| | 29945 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.iloscReklamColumn] = global::System.Convert.DBNull; |
| | 29946 | } |
| | 29947 | |
| | 29948 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29949 | public bool IskwotaWalutaBruttoNull() { |
| | 29950 | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.kwotaWalutaBruttoColumn); |
| | 29951 | } |
| | 29952 | |
| | 29953 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29954 | public void SetkwotaWalutaBruttoNull() { |
| | 29955 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.kwotaWalutaBruttoColumn] = global::System.Convert.DBNull; |
| | 29956 | } |
| | 29957 | |
| | 29958 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29959 | public bool Isdata_odNull() { |
| | 29960 | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.data_odColumn); |
| | 29961 | } |
| | 29962 | |
| | 29963 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29964 | public void Setdata_odNull() { |
| | 29965 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.data_odColumn] = global::System.Convert.DBNull; |
| | 29966 | } |
| | 29967 | |
| | 29968 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29969 | public bool Isdata_od_bez_FKNull() { |
| | 29970 | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.data_od_bez_FKColumn); |
| | 29971 | } |
| | 29972 | |
| | 29973 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29974 | public void Setdata_od_bez_FKNull() { |
| | 29975 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.data_od_bez_FKColumn] = global::System.Convert.DBNull; |
| | 29976 | } |
| | 29977 | |
| | 29978 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29979 | public bool IsnettoZafakturowaneNull() { |
| | 29980 | return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.nettoZafakturowaneColumn); |
| | 29981 | } |
| | 29982 | |
| | 29983 | [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] |
| | 29984 | public void SetnettoZafakturowaneNull() { |
| | 29985 | this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.nettoZafakturowaneColumn] = global::System.Convert.DBNull; |
| 45188 | | tableMapping.ColumnMappings.Add("Agent", "Agent"); |
| 45189 | | tableMapping.ColumnMappings.Add("Agencja", "Agencja"); |
| | 45184 | tableMapping.ColumnMappings.Add("agencja", "agencja"); |
| | 45185 | tableMapping.ColumnMappings.Add("agent", "agent"); |
| | 45186 | tableMapping.ColumnMappings.Add("nrZamowienia", "nrZamowienia"); |
| | 45187 | tableMapping.ColumnMappings.Add("nrZamowieniaExt", "nrZamowieniaExt"); |
| | 45188 | tableMapping.ColumnMappings.Add("iloscReklam", "iloscReklam"); |
| | 45189 | tableMapping.ColumnMappings.Add("kwotaWalutaBrutto", "kwotaWalutaBrutto"); |
| | 45190 | tableMapping.ColumnMappings.Add("data_od", "data_od"); |
| | 45191 | tableMapping.ColumnMappings.Add("data_od_bez_FK", "data_od_bez_FK"); |
| | 45192 | tableMapping.ColumnMappings.Add("nettoZafakturowane", "nettoZafakturowane"); |
| 45204 | | this._commandCollection[0].CommandText = @"SELECT idZamowienia, UserName, nrZamowienia, kodKlienta, nr, kodAgenta, rokZamowienia, ilosc, wartoscNetto, wartoscNettoPoRabacie, |
| 45205 | | wartoscNettoZafakturowana, idKlienta, DoZafakturowania, Agent, Agencja |
| | 45207 | this._commandCollection[0].CommandText = @"SELECT agencja, agent, idZamowienia, idKlienta, nrZamowienia, rokZamowienia, kodAgenta, nrZamowieniaExt, iloscReklam, wartoscNetto, kwotaWalutaBrutto, |
| | 45208 | data_od, data_od_bez_FK, nettoZafakturowane, DoZafakturowania |