Changeset 680 for branches – BazaReklam – Trac

branches/ReklamaReorganizacja/BazaReklam/AddZamowienieForm.cs

r613	r680
55	55	numerZamowieniaLabel1.Text = k.kodKlienta + "/" + row.rokZamowienia + "/" + row.kodAgenta + "/" + row.nrZamowienia;
56	56
57		kierownikGroupBox.Enabled = User.Instance().~~St_k~~ierownik;
	57	kierownikGroupBox.Enabled = User.Instance().IsKierownik;
58	58
59	59	czasPlatnosciListBox.DisplayMember = "DisplayValue";
…	…
96	96	private void SetCzasPlatnosci(int czasPlatnosci)
97	97	{
98		txtCzasPlatnosci.Visible = User.Instance().~~St_k~~ierownik;
	98	txtCzasPlatnosci.Visible = User.Instance().IsKierownik;
99	99	lblCzasPlatnosci.Visible = txtCzasPlatnosci.Visible;
100	100

branches/ReklamaReorganizacja/BazaReklam/AdminForm.Designer.cs

r65	r680
101	101	//
102	102	lOGINLabel.AutoSize = true;
103		lOGINLabel.Location = new System.Drawing.Point(~~46, 25~~);
	103	lOGINLabel.Location = new System.Drawing.Point(56, 26);
104	104	lOGINLabel.Name = "lOGINLabel";
105	105	lOGINLabel.Size = new System.Drawing.Size(36, 13);
…	…
110	110	//
111	111	imieLabel.AutoSize = true;
112		imieLabel.Location = new System.Drawing.Point(~~56, 82~~);
	112	imieLabel.Location = new System.Drawing.Point(63, 79);
113	113	imieLabel.Name = "imieLabel";
114	114	imieLabel.Size = new System.Drawing.Size(29, 13);
…	…
119	119	//
120	120	nazwiskoLabel.AutoSize = true;
121		nazwiskoLabel.Location = new System.Drawing.Point(3~~4, 108~~);
	121	nazwiskoLabel.Location = new System.Drawing.Point(36, 109);
122	122	nazwiskoLabel.Name = "nazwiskoLabel";
123	123	nazwiskoLabel.Size = new System.Drawing.Size(56, 13);
…	…
128	128	//
129	129	pASSWORDLabel.AutoSize = true;
130		pASSWORDLabel.Location = new System.Drawing.Point(~~46, 52~~);
	130	pASSWORDLabel.Location = new System.Drawing.Point(53, 53);
131	131	pASSWORDLabel.Name = "pASSWORDLabel";
132	132	pASSWORDLabel.Size = new System.Drawing.Size(39, 13);
…	…
137	137	//
138	138	st_sekretarkaLabel.AutoSize = true;
139		st_sekretarkaLabel.Location = new System.Drawing.Point(30, 33);
	139	st_sekretarkaLabel.Location = new System.Drawing.Point(30, 34);
140	140	st_sekretarkaLabel.Name = "st_sekretarkaLabel";
141		st_sekretarkaLabel.Size = new System.Drawing.Size(60, 13);
	141	st_sekretarkaLabel.Size = new System.Drawing.Size(62, 13);
142	142	st_sekretarkaLabel.TabIndex = 9;
143		st_sekretarkaLabel.Text = "sekretarka:";
	143	st_sekretarkaLabel.Text = "Sekretarka:";
144	144	//
145	145	// st_handlowiecLabel
…	…
148	148	st_handlowiecLabel.Location = new System.Drawing.Point(26, 63);
149	149	st_handlowiecLabel.Name = "st_handlowiecLabel";
150		st_handlowiecLabel.Size = new System.Drawing.Size(64, 13);
	150	st_handlowiecLabel.Size = new System.Drawing.Size(66, 13);
151	151	st_handlowiecLabel.TabIndex = 11;
152		st_handlowiecLabel.Text = "handlowiec:";
	152	st_handlowiecLabel.Text = "Handlowiec:";
153	153	//
154	154	// st_sub_handlowiecLabel
155	155	//
156	156	st_sub_handlowiecLabel.AutoSize = true;
157		st_sub_handlowiecLabel.Location = new System.Drawing.Point(~~9, 91~~);
	157	st_sub_handlowiecLabel.Location = new System.Drawing.Point(25, 92);
158	158	st_sub_handlowiecLabel.Name = "st_sub_handlowiecLabel";
159		st_sub_handlowiecLabel.Size = new System.Drawing.Size(81, 13);
	159	st_sub_handlowiecLabel.Size = new System.Drawing.Size(67, 13);
160	160	st_sub_handlowiecLabel.TabIndex = 13;
161		st_sub_handlowiecLabel.Text = "~~subhandlowiec~~:";
	161	st_sub_handlowiecLabel.Text = "Ksiêgowoæ:";
162	162	//
163	163	// st_kierownikLabel
164	164	//
165	165	st_kierownikLabel.AutoSize = true;
166		st_kierownikLabel.Location = new System.Drawing.Point(30, 121);
	166	st_kierownikLabel.Location = new System.Drawing.Point(36, 121);
167	167	st_kierownikLabel.Name = "st_kierownikLabel";
168		st_kierownikLabel.Size = new System.Drawing.Size(55, 13);
	168	st_kierownikLabel.Size = new System.Drawing.Size(56, 13);
169	169	st_kierownikLabel.TabIndex = 15;
170		st_kierownikLabel.Text = "kierownik:";
	170	st_kierownikLabel.Text = "Kierownik:";
171	171	//
172	172	// st_dtpLabel
173	173	//
174	174	st_dtpLabel.AutoSize = true;
175		st_dtpLabel.Location = new System.Drawing.Point(181, 33);
	175	st_dtpLabel.Location = new System.Drawing.Point(181, 34);
176	176	st_dtpLabel.Name = "st_dtpLabel";
177		st_dtpLabel.Size = new System.Drawing.Size(28, 13);
	177	st_dtpLabel.Size = new System.Drawing.Size(30, 13);
178	178	st_dtpLabel.TabIndex = 17;
179		st_dtpLabel.Text = " dtp:";
	179	st_dtpLabel.Text = " Dtp:";
180	180	//
181	181	// st_korektaLabel
182	182	//
183	183	st_korektaLabel.AutoSize = true;
184		st_korektaLabel.Location = new System.Drawing.Point(16~~3, 58~~);
	184	st_korektaLabel.Location = new System.Drawing.Point(164, 63);
185	185	st_korektaLabel.Name = "st_korektaLabel";
186		st_korektaLabel.Size = new System.Drawing.Size(46, 13);
	186	st_korektaLabel.Size = new System.Drawing.Size(47, 13);
187	187	st_korektaLabel.TabIndex = 19;
188		st_korektaLabel.Text = "korekta:";
	188	st_korektaLabel.Text = "Korekta:";
189	189	//
190	190	// st_produkcjaLabel
191	191	//
192	192	st_produkcjaLabel.AutoSize = true;
193		st_produkcjaLabel.Location = new System.Drawing.Point(153, 91);
	193	st_produkcjaLabel.Location = new System.Drawing.Point(153, 92);
194	194	st_produkcjaLabel.Name = "st_produkcjaLabel";
195		st_produkcjaLabel.Size = new System.Drawing.Size(57, 13);
	195	st_produkcjaLabel.Size = new System.Drawing.Size(58, 13);
196	196	st_produkcjaLabel.TabIndex = 21;
197		st_produkcjaLabel.Text = "produkcja:";
	197	st_produkcjaLabel.Text = "Produkcja:";
198	198	//
199	199	// st_adminLabel
200	200	//
201	201	st_adminLabel.AutoSize = true;
202		st_adminLabel.Location = new System.Drawing.Point(171, 121);
	202	st_adminLabel.Location = new System.Drawing.Point(172, 121);
203	203	st_adminLabel.Name = "st_adminLabel";
204		st_adminLabel.Size = new System.Drawing.Size(38, 13);
	204	st_adminLabel.Size = new System.Drawing.Size(39, 13);
205	205	st_adminLabel.TabIndex = 23;
206		st_adminLabel.Text = "admin:";
	206	st_adminLabel.Text = "Admin:";
207	207	//
208	208	// tabControl1
…	…
285	285	//
286	286	this.bindingNavigatorCountItem.Name = "bindingNavigatorCountItem";
287		this.bindingNavigatorCountItem.Size = new System.Drawing.Size(35, 22);
	287	this.bindingNavigatorCountItem.Size = new System.Drawing.Size(36, 22);
288	288	this.bindingNavigatorCountItem.Text = "of {0}";
289	289	this.bindingNavigatorCountItem.ToolTipText = "Total number of items";
…	…
404	404	//
405	405	this.st_adminCheckBox.DataBindings.Add(new System.Windows.Forms.Binding("CheckState", this.uZYTKOWNICYBindingSource, "st_admin", true));
406		this.st_adminCheckBox.Location = new System.Drawing.Point(215, 116);
	406	this.st_adminCheckBox.Location = new System.Drawing.Point(215, 115);
407	407	this.st_adminCheckBox.Name = "st_adminCheckBox";
408	408	this.st_adminCheckBox.Size = new System.Drawing.Size(21, 24);
…	…
412	412	//
413	413	this.st_handlowiecCheckBox.DataBindings.Add(new System.Windows.Forms.Binding("CheckState", this.uZYTKOWNICYBindingSource, "st_handlowiec", true));
414		this.st_handlowiecCheckBox.Location = new System.Drawing.Point(96, 58);
	414	this.st_handlowiecCheckBox.Location = new System.Drawing.Point(96, 57);
415	415	this.st_handlowiecCheckBox.Name = "st_handlowiecCheckBox";
416	416	this.st_handlowiecCheckBox.Size = new System.Drawing.Size(20, 24);
…	…
436	436	//
437	437	this.st_kierownikCheckBox.DataBindings.Add(new System.Windows.Forms.Binding("CheckState", this.uZYTKOWNICYBindingSource, "st_kierownik", true));
438		this.st_kierownikCheckBox.Location = new System.Drawing.Point(96, 116);
	438	this.st_kierownikCheckBox.Location = new System.Drawing.Point(96, 115);
439	439	this.st_kierownikCheckBox.Name = "st_kierownikCheckBox";
440	440	this.st_kierownikCheckBox.Size = new System.Drawing.Size(20, 24);
…	…
444	444	//
445	445	this.st_korektaCheckBox.DataBindings.Add(new System.Windows.Forms.Binding("CheckState", this.uZYTKOWNICYBindingSource, "st_korekta", true));
446		this.st_korektaCheckBox.Location = new System.Drawing.Point(215, 58);
	446	this.st_korektaCheckBox.Location = new System.Drawing.Point(215, 57);
447	447	this.st_korektaCheckBox.Name = "st_korektaCheckBox";
448	448	this.st_korektaCheckBox.Size = new System.Drawing.Size(21, 24);
…	…
477	477	//
478	478	this.lOGINTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.uZYTKOWNICYBindingSource, "LOGIN", true));
479		this.lOGINTextBox.Location = new System.Drawing.Point(~~124~~, 22);
	479	this.lOGINTextBox.Location = new System.Drawing.Point(96, 22);
480	480	this.lOGINTextBox.Name = "lOGINTextBox";
481		this.lOGINTextBox.Size = new System.Drawing.Size(100, 20);
	481	this.lOGINTextBox.Size = new System.Drawing.Size(144, 20);
482	482	this.lOGINTextBox.TabIndex = 2;
483	483	this.lOGINTextBox.Validating += new System.ComponentModel.CancelEventHandler(this.lOGINTextBox_Validating);
…	…
486	486	//
487	487	this.pASSWORDTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.uZYTKOWNICYBindingSource, "PASSWORD", true));
488		this.pASSWORDTextBox.Location = new System.Drawing.Point(~~124~~, 49);
	488	this.pASSWORDTextBox.Location = new System.Drawing.Point(96, 49);
489	489	this.pASSWORDTextBox.Name = "pASSWORDTextBox";
490		this.pASSWORDTextBox.Size = new System.Drawing.Size(100, 20);
	490	this.pASSWORDTextBox.Size = new System.Drawing.Size(144, 20);
491	491	this.pASSWORDTextBox.TabIndex = 8;
492	492	//
…	…
494	494	//
495	495	this.nazwiskoTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.uZYTKOWNICYBindingSource, "Nazwisko", true));
496		this.nazwiskoTextBox.Location = new System.Drawing.Point(~~124~~, 105);
	496	this.nazwiskoTextBox.Location = new System.Drawing.Point(96, 105);
497	497	this.nazwiskoTextBox.Name = "nazwiskoTextBox";
498		this.nazwiskoTextBox.Size = new System.Drawing.Size(100, 20);
	498	this.nazwiskoTextBox.Size = new System.Drawing.Size(144, 20);
499	499	this.nazwiskoTextBox.TabIndex = 6;
500	500	//
…	…
502	502	//
503	503	this.imieTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.uZYTKOWNICYBindingSource, "Imie", true));
504		this.imieTextBox.Location = new System.Drawing.Point(~~124~~, 75);
	504	this.imieTextBox.Location = new System.Drawing.Point(96, 75);
505	505	this.imieTextBox.Name = "imieTextBox";
506		this.imieTextBox.Size = new System.Drawing.Size(100, 20);
	506	this.imieTextBox.Size = new System.Drawing.Size(144, 20);
507	507	this.imieTextBox.TabIndex = 4;
508	508	//

branches/ReklamaReorganizacja/BazaReklam/AdminForm.resx

r65	r680
236	236	<value>
237	237	iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
238		YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAy5JREFUOE9VkmdM
239		k0EYx58ioKIixSraRA1VMYBRXFGs+4sjEDBqxBnUANEvGk1E9ANxIVjainHEFReW0sYyHImDDpClghDi
240		IA4EGbWlVkuwdvn3+raKXvLLXS7v87v/vc/x9jYuOv7G9j5zI2UFxgtWkDPAQQDI7XaTy+Ump8tBLoeT
241		eJ5B1Py1looCpO6frUMKmg915RLRN1qri3aSjCB5IGF1gP2HHY0vG9HU3ISGlw140fAc7Z/aYevtR0GZ
242		BKKjwYjMEzhZ8TqGgDbVxIHOEmR+gcfjgdVq5TCZTOjs7OSwGr/jtCYP8Y/4iMgOBSs+wRDR5tqZoIsE
243		6f1TXAKz2Qy9QY/KKgMMlQZu3draCku3FXJ1LhbXCDAyc5hXcJoxlbZ6E1xmVyjLAdxAX18fLBYLh9Fo
244		5E7vaO+AudMCmSoHS6sFCPcJCnwCloB3jZDrFdjBfVxR8QRanRY6vQ56vR6vX72GscMMaXEOlteOAd8n
245		OMMJttXNQkghQa5hP/EL8KPHAbvRyXDA9rkflrbv6H5rQk+LBWcU+VhRJ/yTwCdIZQnGFgVjiSoOCcUL
246		sap4PlYr45GgikeiagGSVWKsYaSol2LDXTGSn00B/+DwgQSpLIFIHYYoTSgmlgRBWEqYcI8w6UEAoh4G
247		IuZxEGZqQ7CkMgIrqyKx4Xn0/4Id9XMQc0eA2HI+9mvSUGUwoERzB/LzUuScPwb5dQkKNTcRd3QMxJeE
248		yGgRg39g6ECCnfWzMaMsAtPvhUFaegzb7+5AiJKwqzQFjbpmdLX1cO2dc2EUEmsikf8xHWGZgwcEW57G
249		Yd59IeY+FECmPIlUdQrGsWtkadPQ/c4El5P11gPMPsdHUrUI+W1pfwS+NiYpYgsXl4xn/RVCekWCXeXr
250		MU3LXmbLPu7kX55fMH/4hmU3xiL1VSyu9u7BiD1B9r8PiUJonGi34FbwXl6POGOBpei2wqYoV9i0+gpb
251		XXW9TalU9iuvqEEJ1BuYQcbQ9GFdFM0rYoIj3FNmI5gxmbGZkc3IY0gY+f8gY2u5f/8kmw8zEhnhXoF3
252		BDFGMyL9sils9hL1D1P9e97DJvqLA38DbV4TzM8UdXAAAAAASUVORK5CYII=
253		</value>
254		</data>
	238	YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAy1JREFUOE9VkmdM
	239	k0EYx58qRUVFqlW0iYOqoGIUVxTq/uIkjmjEGdQg0S8YTcTxwbgYlrZiHHHFhS20sQyVxEEHyFJBCXHg
	240	QpBRW2q1BJsu/17fFtFLfrnL5X1+97/3Od7e2nkn39o/pm6kQ0GxwiXk6uUkAOTxeMjt9pDL7SS300U8
	241	b2+q+15JSp7M43zfN7vucGsGEf2gtboJLpITpMVSVgc4fjlQ+7IWr+peoeZlDV7UPEfTlybYO7qQXSiF
	242	+HgwxmQIXax4HUNImypiQOcI8oDA6/XCZrNxmM1mtLS0cNhMP3FGm4nYRwKEHw0FKz7FENPmymmgSwTZ
	243	g9NcAovFAoPRgNIyI4ylRm7d0NAAa5sNCk0G5lcIMSi1v09whhFFW30JrrArFKYBHqCzsxNWq5XDZDJx
	244	pzc3NcPSYoVcnYaF5UIM9guy/QKWgHedkOETOMB9XFLyBDq9DnqDHgaDAW9ev4Gp2QJZXhoWVw6DwC84
	245	ywm2VU1HSA5BoWU/8Rvwq90Jh8nFcML+tQvWxp9oe2dGe70VZ5VZWFIl6k7gFySyBMNVwVigjsHKvLlY
	246	ljcHy3NjsVIdi3h1HFarJVjDSNAsxIZ7Eqx+Nh6CgwN6EiSyBGJNGCK1oRidz4eogDDqPmFscS9EPgzC
	247	pMd8TNOFYEFpOJaWRWDD84n/C3ZUz8Sku0JEFwmwX5uEMqMR+dq7UFyQIe3CCShuSJGjvYWY48MguSxC
	248	cr0EggP9ehLsrJ6BqYXhmHI/DLKCE9h+bwdCcgm7CxJQq69Da2M7196ZF4cgviICWZ93ISy1T49gy9MY
	249	zH4gwqyHQshz05GoScAIdo1DuiS0fTDD7WK99QIzzguwqlyMrMakboG/jauU0Tnz80ey/ooguyrF7qL1
	250	mKxjL7N+H3fyb+9vWD79wKKbw5H4OhrXOlIwMIXv+PuQKIRGiPcIb/NTeO2S5Dir8o7SrixS2kv0T+xV
	251	5dV2lUrVlXtVA1pBHUHJZArd1b+VJvJUTHCMe8psBDPGMTYzjjIyGVJG1j/I2VoR2E9n8xFGPGOwT+Ab
	252	fMZQRkRANp7NPiL/ISqw5ztsdKA46A9UIBO9LXcrTwAAAABJRU5ErkJggg==
	253	</value>
	254	</data>
	255	<metadata name="sLOWNIKDataSet.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
	256	<value>17, 17</value>
	257	</metadata>
255	258	<metadata name="uZYTKOWNICYTableAdapter.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
256	259	<value>376, 17</value>

branches/ReklamaReorganizacja/BazaReklam/Baza Reklam.csproj

r670	r680
33	33	<WebPage>index.htm</WebPage>
34	34	<OpenBrowserOnPublish>false</OpenBrowserOnPublish>
35		<ApplicationVersion>1.1.13.0</ApplicationVersion>
	35	<ApplicationVersion>1.1.14.0</ApplicationVersion>
36	36	<BootstrapperEnabled>false</BootstrapperEnabled>
37	37	</PropertyGroup>
…	…
126	126	<Compile Include="Classes\Helpers\ConfigurationHelper.cs" />
127	127	<Compile Include="Classes\Helpers\PdfHelper.cs" />
	128	<Compile Include="Classes\Helpers\ProvisionHelper.cs" />
128	129	<Compile Include="Classes\Helpers\StringHelper.cs" />
129	130	<Compile Include="Classes\Helpers\WebRequestHelper.cs" />
…	…
685	686	<Content Include="Docs\doc.txt" />
686	687	<None Include="Baza Reklam_TemporaryKey.pfx" />
687		~~<None Include="Docs\Zmiany.htm" />~~
688	688	<None Include="Properties\DataSources\InvoiceProvider.datasource" />
689	689	<EmbeddedResource Include="Raporty\ReportsTree.xml">

branches/ReklamaReorganizacja/BazaReklam/Classes/User.cs

r593	r680
28	28	private string skype;
29	29	private string smtpServer;
30		private bool ~~st_a~~dmin;
	30	private bool _isAdmin;
31	31	private bool st_dtp;
32	32	private bool st_handlowiec;
…	…
97	97	}
98	98
99		public bool ~~St_s~~ekretarka
	99	public bool IsSekretarka
100	100	{
101	101	get { return st_sekretarka; }
…	…
103	103	}
104	104
105		public bool ~~St_h~~andlowiec
	105	public bool IsHandlowiec
106	106	{
107	107	get { return st_handlowiec; }
…	…
109	109	}
110	110
111		public bool ~~St_subhandlowie~~c
	111	public bool IsKsiegowosc
112	112	{
113	113	get { return st_subhandlowiec; }
…	…
115	115	}
116	116
117		public bool ~~St_k~~ierownik
	117	public bool IsKierownik
118	118	{
119	119	get { return st_kierownik; }
…	…
121	121	}
122	122
123		public bool ~~St_d~~tp
	123	public bool IsDtp
124	124	{
125	125	get { return st_dtp; }
…	…
127	127	}
128	128
129		public bool ~~St_k~~orekta
	129	public bool IsKorekta
130	130	{
131	131	get { return st_korekta; }
…	…
133	133	}
134	134
135		public bool ~~St_p~~rodukcja
	135	public bool IsProdukcja
136	136	{
137	137	get { return st_produkcja; }
…	…
139	139	}
140	140
141		public bool ~~St_a~~dmin
142		{
143		get { return ~~st_a~~dmin; }
144		set { ~~st_a~~dmin = value; }
	141	public bool IsAdmin
	142	{
	143	get { return _isAdmin; }
	144	set { _isAdmin = value; }
145	145	}
146	146
…	…
149	149	get { return stanowisko; }
150	150	set { stanowisko = value; }
151		}
152
153		~~public string NrGG~~
154		{
155		~~get { return nrGG; }~~
156		~~set { nrGG = value; }~~
157	151	}
158	152

branches/ReklamaReorganizacja/BazaReklam/ClientsForm.cs

r671	r680
1685	1685	treeView1.Nodes.Add(node);
1686	1686
1687		if (User.Instance().~~St_h~~andlowiec)
	1687	if (User.Instance().IsHandlowiec)
1688	1688	{
1689	1689	node = new TreeNode("Moi klienci");
…	…
1736	1736	{
1737	1737	//usuwanie faktury
1738		usunFakture.Enabled = User.Instance().~~St_k~~ierownik;
	1738	usunFakture.Enabled = User.Instance().IsKierownik;
1739	1739	usunFakture.Visible = false;
1740	1740
1741	1741	//dodawanie klasyfikacji
1742		klTextBox.Visible = User.Instance().~~St_k~~ierownik;
1743		dodajKlButton.Visible = User.Instance().~~St_k~~ierownik;
1744		usunKlButton.Visible = User.Instance().~~St_k~~ierownik;
1745
1746		dodajLogoToolStripButton.Enabled = User.Instance().~~St_kierownik \| User.Instance().St_p~~rodukcja;
	1742	klTextBox.Visible = User.Instance().IsKierownik;
	1743	dodajKlButton.Visible = User.Instance().IsKierownik;
	1744	usunKlButton.Visible = User.Instance().IsKierownik;
	1745
	1746	dodajLogoToolStripButton.Enabled = User.Instance().IsKierownik \| User.Instance().IsProdukcja;
1747	1747	}
1748	1748

branches/ReklamaReorganizacja/BazaReklam/Docs/versioninfo.html

r665	r680
6	6	<body>
7	7	<h1>Baza reklam - Informacje o wersji</h1>
	8	<div>
	9	<a id="1.1.14" />
	10	<h2>Wersja 1.1.14 (2009-06-03)</h2>
	11	<p>Opis zmian wprowadzonych do wersji 1.1.14</p>
	12	<ul>
	13	<li>Zgłoszenie #176: Poprawiono błądy występujące przy wystawianiu faktury</li>
	14	<li>Zgłoszenie #177: Poprawiono błąd przy próbie wyświetlenia klientów, z ktorymi nie było kntaktu od 90 lub 300 dni</li>
	15	<li>Zgłoszenie #178: Dodano nową grupę użytkowników - księgowość oraz możliwość blokowania zmiany prowizji dla tej grupy</li>
	16	</ul>
	17	</div>
8	18	<div>
9	19	<a id="1.1.13" />

branches/ReklamaReorganizacja/BazaReklam/FactureViewer.cs

r650	r680
75	75	//Produkcja ma domylnie bez podpisu
76	76
77		if (User.Instance().~~St_p~~rodukcja)
	77	if (User.Instance().IsProdukcja)
78	78	{
79	79	podpisCheckBox.CheckState = CheckState.Unchecked;
…	…
171	171
172	172	//Produkcja ma domylnie bez podpisu
173		if (User.Instance().~~St_p~~rodukcja)
	173	if (User.Instance().IsProdukcja)
174	174	{
175	175	podpisCheckBox.CheckState = CheckState.Unchecked;
…	…
234	234
235	235	powodKorektyComboBox.Enabled = true;
236		opisTextBox.ReadOnly = !User.Instance().~~St_k~~ierownik;
237		opisTextBox.BackColor = User.Instance().~~St_k~~ierownik ? Color.White : Color.WhiteSmoke;
	236	opisTextBox.ReadOnly = !User.Instance().IsKierownik;
	237	opisTextBox.BackColor = User.Instance().IsKierownik ? Color.White : Color.WhiteSmoke;
238	238
239	239	reportViewer1.LocalReport.ReportEmbeddedResource = "Baza_Reklam.Raporty.fakturaKorekta.rdlc";
…	…
287	287	//Produkcja ma domylnie bez podpisu
288	288
289		if (User.Instance().~~St_p~~rodukcja)
	289	if (User.Instance().IsProdukcja)
290	290	{
291	291	podpisCheckBox.CheckState = CheckState.Unchecked;
…	…
303	303	reportViewer1.RefreshReport();
304	304
305		nUMERTextBox.Enabled = User.Instance().~~St_k~~ierownik;
	305	nUMERTextBox.Enabled = User.Instance().IsKierownik;
306	306	}
307	307

branches/ReklamaReorganizacja/BazaReklam/Facturer.cs

r622	r680
65	65	nUMERTextBox.Text = read[0];
66	66
67		groupBox2.Enabled = true & User.Instance().~~St_a~~dmin;
	67	groupBox2.Enabled = true & User.Instance().IsAdmin;
68	68
69	69	}
…	…
668	668	private void Facturer_Shown(object sender, EventArgs e)
669	669	{
670		if (!User.Instance().~~St_k~~ierownik)
	670	if (!User.Instance().IsKierownik)
671	671	{
672	672	foreach (Control c in Controls)

branches/ReklamaReorganizacja/BazaReklam/FacturesForm.cs

r645	r680
331	331	private void FacturesForm_Shown(object sender, EventArgs e)
332	332	{
333		if (User.Instance().~~St_k~~ierownik)
	333	if (User.Instance().IsKierownik)
334	334	{
335	335	agencjaToolStripComboBox.Text = User.Instance().SymbolAgencji;
336	336	}
337		else if (User.Instance().~~St_handlowiec \| User.Instance().St_subh~~andlowiec)
	337	else if (User.Instance().IsHandlowiec)
338	338	{
339	339	kodRozliczeniowyToolStripTextBox.Text = User.Instance().Kod_agenta;

branches/ReklamaReorganizacja/BazaReklam/FacturesFormNew.cs

r640	r680
57	57	((CheckBox)((ToolStripControlHost)wyszukajToolStrip.Items["zalegleCheckBox"]).Control).CheckState = CheckState.Indeterminate;
58	58
59		PoznanKatowicetoolStripButton.Enabled = User.Instance().~~St_produkcja && User.Instance().St_k~~ierownik;
	59	PoznanKatowicetoolStripButton.Enabled = User.Instance().IsProdukcja && User.Instance().IsKierownik;
60	60	}
61	61
…	…
269	269	private void FacturesForm_Shown(object sender, EventArgs e)
270	270	{
271		if (User.Instance().~~St_k~~ierownik)
	271	if (User.Instance().IsKierownik)
272	272	{
273	273	agencjaToolStripComboBox.Text = User.Instance().SymbolAgencji;
274	274	}
275		else if (User.Instance().~~St_handlowiec \| User.Instance().St_subh~~andlowiec)
	275	else if (User.Instance().IsHandlowiec)
276	276	{
277	277	kodRozliczeniowyToolStripTextBox.Text = User.Instance().Kod_agenta;

branches/ReklamaReorganizacja/BazaReklam/InfoForm.cs

r613	r680
479	479	{
480	480
481		if (!User.Instance().~~St_k~~ierownik)
	481	if (!User.Instance().IsKierownik)
482	482	{
483	483	infoTabControl.TabPages.Remove(grzbietyTabPage);
…	…
487	487	}
488	488
489		if (!(User.Instance().~~St_kierownik \| User.Instance().St_handlowiec \| User.Instance().St_subhandlowiec \| User.Instance().St_s~~ekretarka))
	489	if (!(User.Instance().IsKierownik \| User.Instance().IsHandlowiec \| User.Instance().IsSekretarka))
490	490	{
491	491	infoTabControl.TabPages.Remove(kursyWalutTabPage);
…	…
496	496
497	497
498		dodajAgencjeButton.Enabled = User.Instance().~~St_k~~ierownik;
499		edytujAgencjeButton.Enabled = User.Instance().~~St_k~~ierownik;
500		dodajAgentaButton.Enabled = User.Instance().~~St_k~~ierownik;
501		edytujAgentaButton.Enabled = User.Instance().~~St_k~~ierownik;
502		dodajKontoButton.Enabled = User.Instance().~~St_k~~ierownik;
503		edytujKontoButton.Enabled = User.Instance().~~St_k~~ierownik;
504
505		nrWydanDataGridView.AllowUserToAddRows = User.Instance().~~St_k~~ierownik;
506		modulyDataGridView.AllowUserToAddRows = User.Instance().~~St_k~~ierownik;
507
508		bindingNavigatorAddNewItem2.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
509		bindingNavigatorAddNewItem3.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
510		bindingNavigatorAddNewItem5.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
511		bindingNavigatorAddNewItem6.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
512		bindingNavigatorAddNewItem7.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
513		bindingNavigatorAddNewItem8.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
514		bindingNavigatorAddNewItem9.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
515		bindingNavigatorAddNewItem10.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
516
517		zapiszGrzbietyToolStripButton.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
518		zapiszNrWydToolStripButton.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
519		zapiszTytultoolStripButton.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
520		zapiszPromocjeToolStripButton.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
521		modulySaveToolStripButton.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
522		zapiszPlanProwToolStripButton.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
523		zapiszBudzetToolStripButton.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
524		zapiszKosztyBiuraToolStripButton.Visible = User.Instance().~~St_kierownik \| User.Instance().St_a~~dmin;
525
526		bindingNavigatorDeleteItem2.Visible = User.Instance().~~St_a~~dmin;
527		bindingNavigatorDeleteItem3.Visible = User.Instance().~~St_a~~dmin;
528		bindingNavigatorDeleteItem5.Visible = User.Instance().~~St_a~~dmin;
529		bindingNavigatorDeleteItem6.Visible = User.Instance().~~St_a~~dmin;
530		bindingNavigatorDeleteItem7.Visible = User.Instance().~~St_a~~dmin;
531		bindingNavigatorDeleteItem8.Visible = User.Instance().~~St_a~~dmin;
532		bindingNavigatorDeleteItem9.Visible = User.Instance().~~St_a~~dmin;
533		bindingNavigatorDeleteItem10.Visible = User.Instance().~~St_a~~dmin;
	498	dodajAgencjeButton.Enabled = User.Instance().IsKierownik;
	499	edytujAgencjeButton.Enabled = User.Instance().IsKierownik;
	500	dodajAgentaButton.Enabled = User.Instance().IsKierownik;
	501	edytujAgentaButton.Enabled = User.Instance().IsKierownik;
	502	dodajKontoButton.Enabled = User.Instance().IsKierownik;
	503	edytujKontoButton.Enabled = User.Instance().IsKierownik;
	504
	505	nrWydanDataGridView.AllowUserToAddRows = User.Instance().IsKierownik;
	506	modulyDataGridView.AllowUserToAddRows = User.Instance().IsKierownik;
	507
	508	bindingNavigatorAddNewItem2.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	509	bindingNavigatorAddNewItem3.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	510	bindingNavigatorAddNewItem5.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	511	bindingNavigatorAddNewItem6.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	512	bindingNavigatorAddNewItem7.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	513	bindingNavigatorAddNewItem8.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	514	bindingNavigatorAddNewItem9.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	515	bindingNavigatorAddNewItem10.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	516
	517	zapiszGrzbietyToolStripButton.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	518	zapiszNrWydToolStripButton.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	519	zapiszTytultoolStripButton.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	520	zapiszPromocjeToolStripButton.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	521	modulySaveToolStripButton.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	522	zapiszPlanProwToolStripButton.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	523	zapiszBudzetToolStripButton.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	524	zapiszKosztyBiuraToolStripButton.Visible = User.Instance().IsKierownik \| User.Instance().IsAdmin;
	525
	526	bindingNavigatorDeleteItem2.Visible = User.Instance().IsAdmin;
	527	bindingNavigatorDeleteItem3.Visible = User.Instance().IsAdmin;
	528	bindingNavigatorDeleteItem5.Visible = User.Instance().IsAdmin;
	529	bindingNavigatorDeleteItem6.Visible = User.Instance().IsAdmin;
	530	bindingNavigatorDeleteItem7.Visible = User.Instance().IsAdmin;
	531	bindingNavigatorDeleteItem8.Visible = User.Instance().IsAdmin;
	532	bindingNavigatorDeleteItem9.Visible = User.Instance().IsAdmin;
	533	bindingNavigatorDeleteItem10.Visible = User.Instance().IsAdmin;
534	534	}
535	535
…	…
629	629	staryAgentComboBox.DataSource = aGENCITableAdapter.GetDataByNieaktywniIDAgencji(idAgencji);
630	630
631		groupBox1.Enabled = User.Instance().~~St_k~~ierownik & (idAgencji == User.Instance().IdAgencji);
	631	groupBox1.Enabled = User.Instance().IsKierownik & (idAgencji == User.Instance().IdAgencji);
632	632	}
633	633	}

branches/ReklamaReorganizacja/BazaReklam/KorektyForm.cs

r636	r680
458	458	private void FacturesForm_Shown(object sender, EventArgs e)
459	459	{
460		if (User.Instance().~~St_k~~ierownik)
	460	if (User.Instance().IsKierownik)
461	461	{
462	462	agencjaToolStripComboBox.Text = User.Instance().SymbolAgencji;
463	463	}
464		else if (User.Instance().~~St_handlowiec \| User.Instance().St_subh~~andlowiec)
	464	else if (User.Instance().IsHandlowiec)
465	465	{
466	466	kodRozliczeniowyToolStripTextBox.Text = User.Instance().Kod_agenta;

branches/ReklamaReorganizacja/BazaReklam/Logowanie.cs

r628	r680
108	108	User.Instance().Imie = reader.GetValue(2).ToString();
109	109	User.Instance().Nazwisko = reader.GetValue(3).ToString();
110		User.Instance().~~St_s~~ekretarka = (bool) reader.GetValue(5);
111		User.Instance().~~St_h~~andlowiec = (bool) reader.GetValue(6);
112		User.Instance().~~St_subhandlowie~~c = (bool) reader.GetValue(7);
113		User.Instance().~~St_k~~ierownik = (bool) reader.GetValue(8);
114		User.Instance().~~St_d~~tp = (bool) reader.GetValue(9);
115		User.Instance().~~St_k~~orekta = (bool) reader.GetValue(10);
116		User.Instance().~~St_p~~rodukcja = (bool) reader.GetValue(11);
117		User.Instance().~~St_a~~dmin = (bool) reader.GetValue(12);
	110	User.Instance().IsSekretarka = (bool) reader.GetValue(5);
	111	User.Instance().IsHandlowiec = (bool) reader.GetValue(6);
	112	User.Instance().IsKsiegowosc = (bool) reader.GetValue(7);
	113	User.Instance().IsKierownik = (bool) reader.GetValue(8);
	114	User.Instance().IsDtp = (bool) reader.GetValue(9);
	115	User.Instance().IsKorekta = (bool) reader.GetValue(10);
	116	User.Instance().IsProdukcja = (bool) reader.GetValue(11);
	117	User.Instance().IsAdmin = (bool) reader.GetValue(12);
118	118	if (!reader.IsDBNull(13))
119	119	{
…	…
136	136
137	137	//jezeli handlowiec to sciaga dane agenta
138		if (User.Instance().St_handlowiec \| User.Instance().St_kierownik \| User.Instance().St_subhandlowiec \|
139		User.Instance().St_sekretarka)
	138	if (User.Instance().IsHandlowiec \| User.Instance().IsKierownik \| User.Instance().IsSekretarka)
140	139	{
141	140	reader.Close();

branches/ReklamaReorganizacja/BazaReklam/MDIBazaReklam.cs

r649	r680
39	39
40	40
41		if (User.Instance().~~St_handlowiec \|\| User.Instance().St_kierownik \|\| User.Instance().St_sekretarka \|\| User.Instance().St_subhandlowiec \|\| User.Instance().St_p~~rodukcja)
	41	if (User.Instance().IsHandlowiec \|\| User.Instance().IsKierownik \|\| User.Instance().IsSekretarka \|\| User.Instance().IsProdukcja)
42	42	{
43	43	zamowieniaToolStripButton.Enabled = true;
…	…
47	47	}
48	48
49		if (User.Instance().~~St_dtp \|\| User.Instance().St_handlowiec \|\| User.Instance().St_kierownik \|\| User.Instance().St_sekretarka \|\| User.Instance().St_subhandlowiec \|\| User.Instance().St_p~~rodukcja)
	49	if (User.Instance().IsDtp \|\| User.Instance().IsHandlowiec \|\| User.Instance().IsKierownik \|\| User.Instance().IsSekretarka \|\| User.Instance().IsProdukcja)
50	50	{
51	51	raportyToolStripButton.Enabled = true;
…	…
53	53	}
54	54
55		if (User.Instance().~~St_admin \|\| User.Instance().St_handlowiec \|\| User.Instance().St_kierownik \|\| User.Instance().St_sekretarka \|\| User.Instance().St_subhandlowiec~~)
	55	if (User.Instance().IsAdmin \|\| User.Instance().IsHandlowiec \|\| User.Instance().IsKierownik \|\| User.Instance().IsSekretarka)
56	56	{
57	57	prowizjeToolStripButton.Enabled = true;
58	58	}
59	59
60		if (User.Instance().~~St_a~~dmin)
	60	if (User.Instance().IsAdmin)
61	61	{
62	62	adminToolStripButton.Visible = true;
…	…
66	66
67	67
68		if (User.Instance().~~St_handlowiec \|\| User.Instance().St_kierownik \|\| User.Instance().St_sekretarka \|\| User.Instance().St_subhandlowiec \|\| User.Instance().St_p~~rodukcja)
	68	if (User.Instance().IsHandlowiec \|\| User.Instance().IsKierownik \|\| User.Instance().IsSekretarka \|\| User.Instance().IsProdukcja)
69	69	{
70	70	startToolStripButton.Enabled = true;
…	…
197	197
198	198	if (!_forms.ContainsKey("ProvisionForm"))
199		_forms.Add("ProvisionForm", ProvisionForm.getProvisionForm(this));
200
201		ProvisionForm.getProvisionForm(this).WindowState = FormWindowState.Maximized;
202		ProvisionForm.getProvisionForm(this).Show();
	199	_forms.Add("ProvisionForm", ProvisionForm.GetProvisionForm(this));
	200
	201	ProvisionForm.GetProvisionForm(this).WindowState = FormWindowState.Maximized;
	202	ProvisionForm.GetProvisionForm(this).Show();
203	203
204	204	Cursor = Cursors.Default;
…	…
353	353	private void BindUserAgency()
354	354	{
355		cbUserAgency.Visible = User.Instance().~~St_k~~ierownik && User.Instance().UserAgencyList.Count > 1;
	355	cbUserAgency.Visible = User.Instance().IsKierownik && User.Instance().UserAgencyList.Count > 1;
356	356
357	357	if (!cbUserAgency.Visible \|\| cbUserAgency.ComboBox == null) return;

branches/ReklamaReorganizacja/BazaReklam/OrderDetails.cs

r668	r680
166	166	pROMOCJETableAdapter.Fill(sLOWNIKDataSet.PROMOCJE);
167	167
168		if (User.Instance().~~St_kierownik \|\| User.Instance().St_p~~rodukcja)
	168	if (User.Instance().IsKierownik \|\| User.Instance().IsProdukcja)
169	169	lISTA_TYPOW_REKLAMYTableAdapter.Fill(sLOWNIKDataSet.LISTA_TYPOW_REKLAMY);
170	170	else
…	…
182	182	private void OrderDetails_Load(object sender, EventArgs e)
183	183	{
184		Debug.WriteLine(string.Format("Event: {0}", "Form_Load"));
185		wyroznienie_exportedCheckBox.Enabled = User.Instance().St_produkcja;
	184	wyroznienie_exportedCheckBox.Enabled = User.Instance().IsProdukcja;
186	185	}
187	186
…	…
412	411	SprawdzBledy();
413	412
414		if (!User.Instance().~~St_k~~ierownik && reklama.IsPROMOCJANull())
	413	if (!User.Instance().IsKierownik && reklama.IsPROMOCJANull())
415	414	{
416	415	if (Convert.ToDouble(reklama.RABAT) > SelectedTitle.MaxDiscount)
…	…
437	436
438	437	string typ = Convert.ToString(reklama.TYP);
439		if (((typ == "BEZP£ATNA") \|\| (typ == "BARTER") \|\| (typ == "REKLAMACJA")) &&
440		!User.Instance().St_produkcja)
	438	if (((typ == "BEZP£ATNA") \|\| (typ == "BARTER") \|\| (typ == "REKLAMACJA")) && !User.Instance().IsProdukcja)
441	439	{
442	440	MessageBox.Show("Zamówienie musi byæ zatwierdzone do druku przez kierownika");
…	…
559	557	ZablokujGroupBoxa(groupBox1);
560	558
561		if (!(User.Instance().~~St_produkcja \| User.Instance().St_k~~ierownik))
	559	if (!(User.Instance().IsProdukcja \| User.Instance().IsKierownik))
562	560	{
563	561	ZablokujGroupBoxa(groupBox2);
…	…
587	585	private string nrRek(string symAgenta, string tagAgenta)
588	586	{
589		if (~~!User.Instance().St_h~~andlowiec)
590		return "";
	587	if (User.Instance().IsHandlowiec)
	588	return "";
591	589
592	590	string nr = DbUtils.numerNowejReklamy(symAgenta, tagAgenta).ToString();
593		switch (nr.Length)
	591	switch (nr.Length)
594	592	{
595	593	case 1:
…	…
844	842	row["nick name"] = kodKlienta;
845	843
846		if (DbUtils.czyKlientMaNrVIES(customerId)) row["VAT"] = 0;
847
848		if (User.Instance().~~St_handlowiec \|\| User.Instance().St_subh~~andlowiec)
	844	if (DbUtils.czyKlientMaNrVIES(customerId)) row["VAT"] = 0;
	845
	846	if (User.Instance().IsHandlowiec)
849	847	{
850	848	row["symbol akwizytora"] = User.Instance().Symbol_agenta;
…	…
1089	1087
1090	1088	//Uprawnienia
1091		kier_notatkaTextBox.ReadOnly = !User.Instance().~~St_k~~ierownik;
1092		kier_zatwierdzilCheckBox.Enabled = User.Instance().~~St_k~~ierownik;
1093		zablokuj_prowizjeCheckBox.Enabled = User.Instance().~~St_k~~ierownik;
1094
1095		if (!User.Instance().~~St_k~~ierownik)
	1089	kier_notatkaTextBox.ReadOnly = !User.Instance().IsKierownik;
	1090	kier_zatwierdzilCheckBox.Enabled = User.Instance().IsKierownik;
	1091	zablokuj_prowizjeCheckBox.Enabled = User.Instance().IsKierownik;
	1092
	1093	if (!User.Instance().IsKierownik)
1096	1094	{
1097	1095	cENA_JEDNTextBox.ReadOnly = zatwiedzonoDoDruku;
…	…
1537	1535	{
1538	1536	//ta opcja tylko dostepna dla produkcji
1539		if (!User.Instance().~~St_p~~rodukcja) return;
	1537	if (!User.Instance().IsProdukcja) return;
1540	1538
1541	1539	DataGridViewRow clickedRow = ukazaloSieDataGridView.Rows[e.RowIndex];

branches/ReklamaReorganizacja/BazaReklam/OrdersForm.cs

r645	r680
981	981	TreeNode node;
982	982
983		if (User.Instance().~~St_h~~andlowiec)
	983	if (User.Instance().IsHandlowiec)
984	984	{
985	985	node = new TreeNode("Moje zamówienia");
…	…
1013	1013
1014	1014
1015		if (User.Instance().~~St_k~~ierownik)
	1015	if (User.Instance().IsKierownik)
1016	1016	{
1017	1017	node = new TreeNode("Analiza ceny modu³u");
…	…
1179	1179	private void OrdersForm_Shown(object sender, EventArgs e)
1180	1180	{
1181		if (User.Instance().~~St_k~~ierownik)
	1181	if (User.Instance().IsKierownik)
1182	1182	{
1183	1183	agencjaToolStripComboBox.Text = User.Instance().SymbolAgencji;
1184	1184	}
1185		else if (User.Instance().~~St_handlowiec \| User.Instance().St_subh~~andlowiec)
	1185	else if (User.Instance().IsHandlowiec)
1186	1186	{
1187	1187	agentToolStripComboBox.Text = User.Instance().Login;

branches/ReklamaReorganizacja/BazaReklam/ProductionForm.cs

r661	r680
668	668	private void uprawnienia()
669	669	{
670		usunToolStripButton.Enabled = User.Instance().St_kierownik \| User.Instance().St_produkcja;
671
672		zamowienieToolStripButton.Visible = User.Instance().St_produkcja \| User.Instance().St_handlowiec \|
673		User.Instance().St_subhandlowiec \| User.Instance().St_kierownik;
674		klientToolStripButton.Visible = User.Instance().St_produkcja \| User.Instance().St_handlowiec \|
675		User.Instance().St_subhandlowiec \| User.Instance().St_kierownik;
676
677		zwrotToolStripButton.Enabled = User.Instance().St_produkcja \| User.Instance().St_korekta \|
678		User.Instance().St_dtp;
679		doDTPToolStripButton.Enabled = User.Instance().St_produkcja \|\| User.Instance().St_dtp;
680		proToolStripButton.Enabled = User.Instance().St_dtp;
681		doKorektyToolStripButton.Enabled = User.Instance().St_dtp;
682		doDTP2ToolStripButton.Enabled = User.Instance().St_korekta;
683		doKorekty2ToolStripButton.Enabled = User.Instance().St_dtp;
684		doAgentaToolStripButton.Enabled = User.Instance().St_korekta \| User.Instance().St_dtp;
685		akceptToolStripButton.Enabled = User.Instance().St_handlowiec \| User.Instance().St_subhandlowiec \|
686		User.Instance().St_kierownik \| User.Instance().St_produkcja;
687		nieakceptToolStripButton.Enabled = User.Instance().St_handlowiec \| User.Instance().St_subhandlowiec \|
688		User.Instance().St_kierownik;
689
690		if (!(User.Instance().St_produkcja \| User.Instance().St_kierownik \| User.Instance().St_dtp))
	670	usunToolStripButton.Enabled = User.Instance().IsKierownik \| User.Instance().IsProdukcja;
	671
	672	zamowienieToolStripButton.Visible = User.Instance().IsProdukcja \| User.Instance().IsHandlowiec \| User.Instance().IsKierownik;
	673	klientToolStripButton.Visible = User.Instance().IsProdukcja \| User.Instance().IsHandlowiec \| User.Instance().IsKierownik;
	674
	675	zwrotToolStripButton.Enabled = User.Instance().IsProdukcja \| User.Instance().IsKorekta \|
	676	User.Instance().IsDtp;
	677	doDTPToolStripButton.Enabled = User.Instance().IsProdukcja \|\| User.Instance().IsDtp;
	678	proToolStripButton.Enabled = User.Instance().IsDtp;
	679	doKorektyToolStripButton.Enabled = User.Instance().IsDtp;
	680	doDTP2ToolStripButton.Enabled = User.Instance().IsKorekta;
	681	doKorekty2ToolStripButton.Enabled = User.Instance().IsDtp;
	682	doAgentaToolStripButton.Enabled = User.Instance().IsKorekta \| User.Instance().IsDtp;
	683	akceptToolStripButton.Enabled = User.Instance().IsHandlowiec \| User.Instance().IsKierownik \| User.Instance().IsProdukcja;
	684	nieakceptToolStripButton.Enabled = User.Instance().IsHandlowiec \| User.Instance().IsKierownik;
	685
	686	if (!(User.Instance().IsProdukcja \| User.Instance().IsKierownik \| User.Instance().IsDtp))
691	687	{
692	688	tabControl1.TabPages.Remove(spisTabPage);
…	…
694	690	}
695	691
696		zapiszStronyButton.Enabled = User.Instance().~~St_produkcja \| User.Instance().St_k~~ierownik;
	692	zapiszStronyButton.Enabled = User.Instance().IsProdukcja \| User.Instance().IsKierownik;
697	693	}
698	694
…	…
787	783	doAgentaToolStripButton.Enabled = false;
788	784
789		if ((User.Instance().~~St_handlowiec) && (!User.Instance().St_k~~ierownik))
	785	if ((User.Instance().IsHandlowiec) && (!User.Instance().IsKierownik))
790	786	{
791	787	//handlowiec moze akceptowac tylko swoje projekty
…	…
810	806
811	807	//produkcja ma miec zawsze aktywny ten button
812		if (User.Instance().~~St_p~~rodukcja)
	808	if (User.Instance().IsProdukcja)
813	809	akceptToolStripButton.Enabled = true;
814	810	else
815	811	{
816		if ((User.Instance().~~St_handlowiec) && (!User.Instance().St_k~~ierownik))
	812	if ((User.Instance().IsHandlowiec) && (!User.Instance().IsKierownik))
817	813	{
818	814	//handlowiec moze akceptowac tylko swoje projekty
…	…
837	833	doAgentaToolStripButton.Enabled = false;
838	834
839		if ((User.Instance().~~St_handlowiec) && (!User.Instance().St_k~~ierownik))
	835	if ((User.Instance().IsHandlowiec) && (!User.Instance().IsKierownik))
840	836	{
841	837	//handlowiec moze akceptowac tylko swoje projekty
…	…
1047	1043	"SELECT * FROM dbo.PRODUKCJA WHERE STAN != 'ZAAKCEPTOWANE' AND STAN != 'NIEZAAKCEPTOWANE' AND STAN !='ZWROT Z PRODUKCJI'";
1048	1044
1049		if (User.Instance().~~St_p~~rodukcja)
	1045	if (User.Instance().IsProdukcja)
1050	1046	{
1051	1047	str =
…	…
1054	1050	}
1055	1051
1056		if (User.Instance().~~St_k~~ierownik)
	1052	if (User.Instance().IsKierownik)
1057	1053	{
1058	1054	str = "SELECT dbo.PRODUKCJA.* FROM dbo.PRODUKCJA LEFT JOIN dbo.AGENCI " +
…	…
1064	1060	}
1065	1061
1066		if (User.Instance().~~St_handlowiec \| User.Instance().St_subh~~andlowiec)
	1062	if (User.Instance().IsHandlowiec)
1067	1063	{
1068	1064	str = "SELECT * FROM dbo.PRODUKCJA WHERE STAN != 'ZAAKCEPTOWANE' AND STAN != 'NIEZAAKCEPTOWANE' AND datediff(day, DATA_AGENT,getdate()) <= 30 ";
…	…
1071	1067	}
1072	1068
1073		if (User.Instance().~~St_d~~tp)
	1069	if (User.Instance().IsDtp)
1074	1070	{
1075	1071	str = "select * from dbo.PRODUKCJA where STAN='DO DTP' OR STAN='W DTP' OR STAN='PO KOREKCIE' OR STAN='ZAMAWIAM'";
…	…
1077	1073	}
1078	1074
1079		if (User.Instance().~~St_k~~orekta)
	1075	if (User.Instance().IsKorekta)
1080	1076	{
1081	1077	str = "SELECT * FROM dbo.PRODUKCJA WHERE STAN='DO KOREKTY' OR STAN='W 2 KOREKCIE' ";

branches/ReklamaReorganizacja/BazaReklam/ProjectForm.cs

r652	r680
180	180	path_to_materialTextBox.ReadOnly = false;
181	181
182		usunButton.Enabled = (!string.IsNullOrEmpty(User.Instance().Symbol_agenta) && User.Instance().Symbol_agenta.ToLower() == projekt.AGENT.ToLower()) \|\| User.Instance().~~St_produkcja \|\| User.Instance().St_d~~tp;
	182	usunButton.Enabled = (!string.IsNullOrEmpty(User.Instance().Symbol_agenta) && User.Instance().Symbol_agenta.ToLower() == projekt.AGENT.ToLower()) \|\| User.Instance().IsProdukcja \|\| User.Instance().IsDtp;
183	183	}
184	184	else
185	185	{
186		dodajButton.Enabled = false \|\| User.Instance().~~St_produkcja \|\| User.Instance().St_d~~tp;
187		tYP_PROJEKTUComboBox.Enabled = false \|\| User.Instance().~~St_produkcja \|\| User.Instance().St_d~~tp;
188		zAMAWIAM_NADateTimePicker.Enabled = false \|\| User.Instance().~~St_produkcja \|\| User.Instance().St_d~~tp;
189		pRIORYTETComboBox.Enabled = false \|\| User.Instance().~~St_produkcja \|\| User.Instance().St_d~~tp;
190
191		lokalizacjaTextBox.ReadOnly = true && !User.Instance().~~St_p~~rodukcja;
192		oPISTextBox.ReadOnly = true && !User.Instance().~~St_p~~rodukcja;
193		uwagiTextBox.ReadOnly = true && !User.Instance().~~St_p~~rodukcja;
194		path_to_materialTextBox.ReadOnly = true && !User.Instance().~~St_p~~rodukcja;
195		dataEmisjiTextBox.ReadOnly = true && !User.Instance().~~St_p~~rodukcja;
196
197		usunButton.Enabled = User.Instance().~~St_k~~ierownik;
	186	dodajButton.Enabled = false \|\| User.Instance().IsProdukcja \|\| User.Instance().IsDtp;
	187	tYP_PROJEKTUComboBox.Enabled = false \|\| User.Instance().IsProdukcja \|\| User.Instance().IsDtp;
	188	zAMAWIAM_NADateTimePicker.Enabled = false \|\| User.Instance().IsProdukcja \|\| User.Instance().IsDtp;
	189	pRIORYTETComboBox.Enabled = false \|\| User.Instance().IsProdukcja \|\| User.Instance().IsDtp;
	190
	191	lokalizacjaTextBox.ReadOnly = true && !User.Instance().IsProdukcja;
	192	oPISTextBox.ReadOnly = true && !User.Instance().IsProdukcja;
	193	uwagiTextBox.ReadOnly = true && !User.Instance().IsProdukcja;
	194	path_to_materialTextBox.ReadOnly = true && !User.Instance().IsProdukcja;
	195	dataEmisjiTextBox.ReadOnly = true && !User.Instance().IsProdukcja;
	196
	197	usunButton.Enabled = User.Instance().IsKierownik;
198	198	}
199	199

branches/ReklamaReorganizacja/BazaReklam/Properties/AssemblyInfo.cs

r665	r680
30	30	//
31	31	[assembly: AssemblyVersion("1.0.0.0")]
32		[assembly: AssemblyFileVersion("1.1.13")]
	32	[assembly: AssemblyFileVersion("1.1.14")]

branches/ReklamaReorganizacja/BazaReklam/ProvisionForm.Designer.cs

r242	r680
30	30	{
31	31	this.components = new System.ComponentModel.Container();
32		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle13 = new System.Windows.Forms.DataGridViewCellStyle();
33		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
34		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();
35		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();
36		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();
37		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle();
38		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle();
39		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle();
40		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle();
41		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle9 = new System.Windows.Forms.DataGridViewCellStyle();
42		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle10 = new System.Windows.Forms.DataGridViewCellStyle();
43		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle11 = new System.Windows.Forms.DataGridViewCellStyle();
44		System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle12 = new System.Windows.Forms.DataGridViewCellStyle();
	32	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle26 = new System.Windows.Forms.DataGridViewCellStyle();
	33	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle14 = new System.Windows.Forms.DataGridViewCellStyle();
	34	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle15 = new System.Windows.Forms.DataGridViewCellStyle();
	35	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle16 = new System.Windows.Forms.DataGridViewCellStyle();
	36	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle17 = new System.Windows.Forms.DataGridViewCellStyle();
	37	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle18 = new System.Windows.Forms.DataGridViewCellStyle();
	38	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle19 = new System.Windows.Forms.DataGridViewCellStyle();
	39	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle20 = new System.Windows.Forms.DataGridViewCellStyle();
	40	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle21 = new System.Windows.Forms.DataGridViewCellStyle();
	41	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle22 = new System.Windows.Forms.DataGridViewCellStyle();
	42	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle23 = new System.Windows.Forms.DataGridViewCellStyle();
	43	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle24 = new System.Windows.Forms.DataGridViewCellStyle();
	44	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle25 = new System.Windows.Forms.DataGridViewCellStyle();
45	45	System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ProvisionForm));
46	46	this.aGENCIBindingSource = new System.Windows.Forms.BindingSource(this.components);
…	…
92	92	this.zapiszDaneToolStripButton = new System.Windows.Forms.ToolStripButton();
93	93	this.toolStripSeparator2 = new System.Windows.Forms.ToolStripSeparator();
94		~~this.pobierzDaneToolStripButton = new System.Windows.Forms.ToolStripButton();~~
95		~~this.stareProwizjeToolStripButton = new System.Windows.Forms.ToolStripButton();~~
96	94	this.zapiszToolStripButton = new System.Windows.Forms.ToolStripButton();
97		~~this.przeliczStripButton = new System.Windows.Forms.ToolStripButton();~~
98	95	this.naniesNaReklamyToolStripButton = new System.Windows.Forms.ToolStripButton();
99	96	this.printToolStripButton = new System.Windows.Forms.ToolStripButton();
…	…
107	104	this.agencjaToolStripComboBox = new System.Windows.Forms.ToolStripComboBox();
108	105	this.szukajToolStripButton = new System.Windows.Forms.ToolStripButton();
109		this.~~wyczyscToolStripButt~~on = new System.Windows.Forms.ToolStripButton();
	106	this.btnBlockProvision = new System.Windows.Forms.ToolStripButton();
110	107	this.agencjeTableAdapter1 = new Baza_Reklam.SLOWNIKDataSetTableAdapters.AGENCJETableAdapter();
111	108	this.ukrytyLabel = new System.Windows.Forms.Label();
…	…
205	202	this.prowizjeDataGridView.AllowUserToDeleteRows = false;
206	203	this.prowizjeDataGridView.AutoGenerateColumns = false;
207		~~this.prowizjeDataGridView.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;~~
208	204	this.prowizjeDataGridView.BackgroundColor = System.Drawing.Color.White;
209	205	this.prowizjeDataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
…	…
231	227	this.wREKLAMYDataGridViewTextBoxColumn});
232	228	this.prowizjeDataGridView.DataSource = this.pLANBindingSource;
233		dataGridViewCellStyle13.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
234		dataGridViewCellStyle13.BackColor = System.Drawing.SystemColors.Window;
235		dataGridViewCellStyle13.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(238)));
236		dataGridViewCellStyle13.ForeColor = System.Drawing.SystemColors.ControlText;
237		dataGridViewCellStyle13.SelectionBackColor = System.Drawing.SystemColors.Highlight;
238		dataGridViewCellStyle13.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
239		dataGridViewCellStyle13.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
240		this.prowizjeDataGridView.DefaultCellStyle = dataGridViewCellStyle13;
	229	dataGridViewCellStyle26.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
	230	dataGridViewCellStyle26.BackColor = System.Drawing.SystemColors.Window;
	231	dataGridViewCellStyle26.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(238)));
	232	dataGridViewCellStyle26.ForeColor = System.Drawing.SystemColors.ControlText;
	233	dataGridViewCellStyle26.SelectionBackColor = System.Drawing.SystemColors.Highlight;
	234	dataGridViewCellStyle26.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
	235	dataGridViewCellStyle26.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
	236	this.prowizjeDataGridView.DefaultCellStyle = dataGridViewCellStyle26;
241	237	this.prowizjeDataGridView.Dock = System.Windows.Forms.DockStyle.Fill;
242	238	this.prowizjeDataGridView.Location = new System.Drawing.Point(0, 31);
…	…
249	245	this.prowizjeDataGridView.CellLeave += new System.Windows.Forms.DataGridViewCellEventHandler(this.prowizjeDataGridView_CellLeave);
250	246	this.prowizjeDataGridView.Leave += new System.EventHandler(this.prowizjeDataGridView_Leave);
251		this.prowizjeDataGridView.DataError += new System.Windows.Forms.DataGridViewDataErrorEventHandler(this.prowizjeDataGridView_DataError_1);
	247	this.prowizjeDataGridView.CellEndEdit += new System.Windows.Forms.DataGridViewCellEventHandler(this.prowizjeDataGridView_CellEndEdit);
	248	this.prowizjeDataGridView.DataError += new System.Windows.Forms.DataGridViewDataErrorEventHandler(this.prowizjeDataGridView_DataError);
252	249	//
253	250	// sYMBOLDataGridViewTextBoxColumn
…	…
257	254	this.sYMBOLDataGridViewTextBoxColumn.DisplayMember = "Symbol";
258	255	this.sYMBOLDataGridViewTextBoxColumn.DisplayStyle = System.Windows.Forms.DataGridViewComboBoxDisplayStyle.Nothing;
259		this.sYMBOLDataGridViewTextBoxColumn.FillWeight = 253.8071F;
260		this.sYMBOLDataGridViewTextBoxColumn.HeaderText = "SYMBOL";
	256	this.sYMBOLDataGridViewTextBoxColumn.HeaderText = "Agent";
261	257	this.sYMBOLDataGridViewTextBoxColumn.Name = "sYMBOLDataGridViewTextBoxColumn";
262	258	this.sYMBOLDataGridViewTextBoxColumn.ReadOnly = true;
…	…
268	264	//
269	265	this.rOKDataGridViewTextBoxColumn.DataPropertyName = "ROK";
270		this.rOKDataGridViewTextBoxColumn.FillWeight = 91.90488F;
271		this.rOKDataGridViewTextBoxColumn.HeaderText = "ROK";
	266	this.rOKDataGridViewTextBoxColumn.HeaderText = "Rok";
272	267	this.rOKDataGridViewTextBoxColumn.Name = "rOKDataGridViewTextBoxColumn";
273	268	this.rOKDataGridViewTextBoxColumn.ReadOnly = true;
	269	this.rOKDataGridViewTextBoxColumn.Width = 43;
274	270	//
275	271	// mSDataGridViewTextBoxColumn
276	272	//
277	273	this.mSDataGridViewTextBoxColumn.DataPropertyName = "MS";
278		this.mSDataGridViewTextBoxColumn.FillWeight = 91.90488F;
279		this.mSDataGridViewTextBoxColumn.HeaderText = "MS";
	274	this.mSDataGridViewTextBoxColumn.HeaderText = "Mies.";
280	275	this.mSDataGridViewTextBoxColumn.Name = "mSDataGridViewTextBoxColumn";
281	276	this.mSDataGridViewTextBoxColumn.ReadOnly = true;
	277	this.mSDataGridViewTextBoxColumn.Width = 43;
282	278	//
283	279	// bUDZETDataGridViewTextBoxColumn
284	280	//
285		~~this.bUDZETDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;~~
286	281	this.bUDZETDataGridViewTextBoxColumn.DataPropertyName = "BUDZET";
287		dataGridViewCellStyle1.Format = "N0";
288		dataGridViewCellStyle1.NullValue = null;
289		this.bUDZETDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle1;
290		this.bUDZETDataGridViewTextBoxColumn.FillWeight = 91.90488F;
291		this.bUDZETDataGridViewTextBoxColumn.HeaderText = "BD";
	282	dataGridViewCellStyle14.Format = "N0";
	283	dataGridViewCellStyle14.NullValue = null;
	284	this.bUDZETDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle14;
	285	this.bUDZETDataGridViewTextBoxColumn.HeaderText = "Plan";
292	286	this.bUDZETDataGridViewTextBoxColumn.Name = "bUDZETDataGridViewTextBoxColumn";
293	287	this.bUDZETDataGridViewTextBoxColumn.ReadOnly = true;
…	…
297	291	//
298	292	this.sPOTKANIADataGridViewTextBoxColumn.DataPropertyName = "SPOTKANIA";
299		this.sPOTKANIADataGridViewTextBoxColumn.FillWeight = 91.90488F;
300		this.sPOTKANIADataGridViewTextBoxColumn.HeaderText = "SP";
	293	this.sPOTKANIADataGridViewTextBoxColumn.HeaderText = "Spotk.";
301	294	this.sPOTKANIADataGridViewTextBoxColumn.Name = "sPOTKANIADataGridViewTextBoxColumn";
302	295	this.sPOTKANIADataGridViewTextBoxColumn.ReadOnly = true;
	296	this.sPOTKANIADataGridViewTextBoxColumn.Width = 44;
303	297	//
304	298	// kONTAKTYDataGridViewTextBoxColumn
305	299	//
306	300	this.kONTAKTYDataGridViewTextBoxColumn.DataPropertyName = "KONTAKTY";
307		this.kONTAKTYDataGridViewTextBoxColumn.FillWeight = 91.90488F;
308		this.kONTAKTYDataGridViewTextBoxColumn.HeaderText = "KO";
	301	this.kONTAKTYDataGridViewTextBoxColumn.HeaderText = "Kontakt";
309	302	this.kONTAKTYDataGridViewTextBoxColumn.Name = "kONTAKTYDataGridViewTextBoxColumn";
310	303	this.kONTAKTYDataGridViewTextBoxColumn.ReadOnly = true;
	304	this.kONTAKTYDataGridViewTextBoxColumn.Width = 43;
311	305	//
312	306	// nKLIENCIDataGridViewTextBoxColumn
313	307	//
314	308	this.nKLIENCIDataGridViewTextBoxColumn.DataPropertyName = "N_KLIENCI";
315		this.nKLIENCIDataGridViewTextBoxColumn.FillWeight = 91.90488F;
316		this.nKLIENCIDataGridViewTextBoxColumn.HeaderText = "NKL";
	309	this.nKLIENCIDataGridViewTextBoxColumn.HeaderText = "N. Klien.";
317	310	this.nKLIENCIDataGridViewTextBoxColumn.Name = "nKLIENCIDataGridViewTextBoxColumn";
318	311	this.nKLIENCIDataGridViewTextBoxColumn.ReadOnly = true;
	312	this.nKLIENCIDataGridViewTextBoxColumn.Width = 43;
319	313	//
320	314	// kLIENCIDataGridViewTextBoxColumn
321	315	//
322	316	this.kLIENCIDataGridViewTextBoxColumn.DataPropertyName = "KLIENCI";
323		this.kLIENCIDataGridViewTextBoxColumn.FillWeight = 91.90488F;
324		this.kLIENCIDataGridViewTextBoxColumn.HeaderText = "KL";
	317	this.kLIENCIDataGridViewTextBoxColumn.HeaderText = "Klien.";
325	318	this.kLIENCIDataGridViewTextBoxColumn.Name = "kLIENCIDataGridViewTextBoxColumn";
326	319	this.kLIENCIDataGridViewTextBoxColumn.ReadOnly = true;
	320	this.kLIENCIDataGridViewTextBoxColumn.Width = 43;
327	321	//
328	322	// rEKLAMYDataGridViewTextBoxColumn
329	323	//
330	324	this.rEKLAMYDataGridViewTextBoxColumn.DataPropertyName = "REKLAMY";
331		this.rEKLAMYDataGridViewTextBoxColumn.FillWeight = 91.90488F;
332		this.rEKLAMYDataGridViewTextBoxColumn.HeaderText = "RE";
	325	this.rEKLAMYDataGridViewTextBoxColumn.HeaderText = "Rekl.";
333	326	this.rEKLAMYDataGridViewTextBoxColumn.Name = "rEKLAMYDataGridViewTextBoxColumn";
334	327	this.rEKLAMYDataGridViewTextBoxColumn.ReadOnly = true;
	328	this.rEKLAMYDataGridViewTextBoxColumn.Width = 43;
335	329	//
336	330	// oCENADataGridViewTextBoxColumn
337	331	//
338		~~this.oCENADataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;~~
339	332	this.oCENADataGridViewTextBoxColumn.DataPropertyName = "OCENA";
340		dataGridViewCellStyle2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
341		this.oCENADataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle2;
342		this.oCENADataGridViewTextBoxColumn.FillWeight = 91.90488F;
	333	dataGridViewCellStyle15.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
	334	this.oCENADataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle15;
343	335	this.oCENADataGridViewTextBoxColumn.HeaderText = "Ocena";
344	336	this.oCENADataGridViewTextBoxColumn.Name = "oCENADataGridViewTextBoxColumn";
345	337	this.oCENADataGridViewTextBoxColumn.ReadOnly = true;
346	338	this.oCENADataGridViewTextBoxColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True;
347		this.oCENADataGridViewTextBoxColumn.Width = 45;
	339	this.oCENADataGridViewTextBoxColumn.Width = 60;
348	340	//
349	341	// OCENAComboCoxColumn
…	…
354	346	this.OCENAComboCoxColumn.ReadOnly = true;
355	347	this.OCENAComboCoxColumn.Visible = false;
	348	this.OCENAComboCoxColumn.Width = 60;
356	349	//
357	350	// PR_PROWIZJI
358	351	//
359		~~this.PR_PROWIZJI.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;~~
360	352	this.PR_PROWIZJI.DataPropertyName = "PR_PROWIZJI";
361		dataGridViewCellStyle3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
362		dataGridViewCellStyle3.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(238)));
363		dataGridViewCellStyle3.Format = "P";
364		dataGridViewCellStyle3.NullValue = null;
365		this.PR_PROWIZJI.DefaultCellStyle = dataGridViewCellStyle3;
366		this.PR_PROWIZJI.FillWeight = 91.90488F;
	353	dataGridViewCellStyle16.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
	354	dataGridViewCellStyle16.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(238)));
	355	dataGridViewCellStyle16.Format = "P";
	356	dataGridViewCellStyle16.NullValue = null;
	357	this.PR_PROWIZJI.DefaultCellStyle = dataGridViewCellStyle16;
367	358	this.PR_PROWIZJI.HeaderText = "Prowizja";
368	359	this.PR_PROWIZJI.Name = "PR_PROWIZJI";
…	…
374	365	this.wBUDZETDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
375	366	this.wBUDZETDataGridViewTextBoxColumn.DataPropertyName = "W_BUDZET";
376		dataGridViewCellStyle4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
377		dataGridViewCellStyle4.Format = "N0";
378		this.wBUDZETDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle4;
379		this.wBUDZETDataGridViewTextBoxColumn.FillWeight = 91.90488F;
380		this.wBUDZETDataGridViewTextBoxColumn.HeaderText = "BD";
	367	dataGridViewCellStyle17.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
	368	dataGridViewCellStyle17.Format = "N0";
	369	this.wBUDZETDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle17;
	370	this.wBUDZETDataGridViewTextBoxColumn.HeaderText = "Sprzeda¿";
381	371	this.wBUDZETDataGridViewTextBoxColumn.Name = "wBUDZETDataGridViewTextBoxColumn";
382	372	this.wBUDZETDataGridViewTextBoxColumn.ReadOnly = true;
…	…
386	376	//
387	377	this.wSPOTKANIADataGridViewTextBoxColumn.DataPropertyName = "W_SPOTKANIA";
388		dataGridViewCellStyle5.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
389		this.wSPOTKANIADataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle5;
390		this.wSPOTKANIADataGridViewTextBoxColumn.FillWeight = 91.90488F;
391		this.wSPOTKANIADataGridViewTextBoxColumn.HeaderText = "SP";
	378	dataGridViewCellStyle18.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
	379	this.wSPOTKANIADataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle18;
	380	this.wSPOTKANIADataGridViewTextBoxColumn.HeaderText = "Spotk.";
392	381	this.wSPOTKANIADataGridViewTextBoxColumn.Name = "wSPOTKANIADataGridViewTextBoxColumn";
393	382	this.wSPOTKANIADataGridViewTextBoxColumn.ReadOnly = true;
	383	this.wSPOTKANIADataGridViewTextBoxColumn.Width = 43;
394	384	//
395	385	// wTELDataGridViewTextBoxColumn
396	386	//
397	387	this.wTELDataGridViewTextBoxColumn.DataPropertyName = "W_TEL";
398		dataGridViewCellStyle6.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
399		this.wTELDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle6;
400		this.wTELDataGridViewTextBoxColumn.FillWeight = 91.90488F;
401		this.wTELDataGridViewTextBoxColumn.HeaderText = "TE";
	388	dataGridViewCellStyle19.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
	389	this.wTELDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle19;
	390	this.wTELDataGridViewTextBoxColumn.HeaderText = "Tel.";
402	391	this.wTELDataGridViewTextBoxColumn.Name = "wTELDataGridViewTextBoxColumn";
403	392	this.wTELDataGridViewTextBoxColumn.ReadOnly = true;
	393	this.wTELDataGridViewTextBoxColumn.Width = 43;
404	394	//
405	395	// wEMAILDataGridViewTextBoxColumn
406	396	//
407	397	this.wEMAILDataGridViewTextBoxColumn.DataPropertyName = "W_EMAIL";
408		dataGridViewCellStyle7.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
409		this.wEMAILDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle7;
410		this.wEMAILDataGridViewTextBoxColumn.FillWeight = 91.90488F;
411		this.wEMAILDataGridViewTextBoxColumn.HeaderText = "EM";
	398	dataGridViewCellStyle20.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
	399	this.wEMAILDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle20;
	400	this.wEMAILDataGridViewTextBoxColumn.HeaderText = "Email";
412	401	this.wEMAILDataGridViewTextBoxColumn.Name = "wEMAILDataGridViewTextBoxColumn";
413	402	this.wEMAILDataGridViewTextBoxColumn.ReadOnly = true;
	403	this.wEMAILDataGridViewTextBoxColumn.Width = 43;
414	404	//
415	405	// wLISTDataGridViewTextBoxColumn
416	406	//
417	407	this.wLISTDataGridViewTextBoxColumn.DataPropertyName = "W_LIST";
418		dataGridViewCellStyle8.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
419		this.wLISTDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle8;
420		this.wLISTDataGridViewTextBoxColumn.FillWeight = 91.90488F;
421		this.wLISTDataGridViewTextBoxColumn.HeaderText = "LIST";
	408	dataGridViewCellStyle21.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
	409	this.wLISTDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle21;
	410	this.wLISTDataGridViewTextBoxColumn.HeaderText = "List";
422	411	this.wLISTDataGridViewTextBoxColumn.Name = "wLISTDataGridViewTextBoxColumn";
423	412	this.wLISTDataGridViewTextBoxColumn.ReadOnly = true;
	413	this.wLISTDataGridViewTextBoxColumn.Width = 44;
424	414	//
425	415	// wFAXDataGridViewTextBoxColumn
426	416	//
427	417	this.wFAXDataGridViewTextBoxColumn.DataPropertyName = "W_FAX";
428		dataGridViewCellStyle9.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
429		this.wFAXDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle9;
430		this.wFAXDataGridViewTextBoxColumn.FillWeight = 91.90488F;
431		this.wFAXDataGridViewTextBoxColumn.HeaderText = "FAX";
	418	dataGridViewCellStyle22.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
	419	this.wFAXDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle22;
	420	this.wFAXDataGridViewTextBoxColumn.HeaderText = "Fax";
432	421	this.wFAXDataGridViewTextBoxColumn.Name = "wFAXDataGridViewTextBoxColumn";
433	422	this.wFAXDataGridViewTextBoxColumn.ReadOnly = true;
	423	this.wFAXDataGridViewTextBoxColumn.Width = 43;
434	424	//
435	425	// wNKLIENCIDataGridViewTextBoxColumn
436	426	//
437	427	this.wNKLIENCIDataGridViewTextBoxColumn.DataPropertyName = "W_N_KLIENCI";
438		dataGridViewCellStyle10.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
439		this.wNKLIENCIDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle10;
440		this.wNKLIENCIDataGridViewTextBoxColumn.FillWeight = 91.90488F;
441		this.wNKLIENCIDataGridViewTextBoxColumn.HeaderText = "NKL";
	428	dataGridViewCellStyle23.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
	429	this.wNKLIENCIDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle23;
	430	this.wNKLIENCIDataGridViewTextBoxColumn.HeaderText = "N. Klien.";
442	431	this.wNKLIENCIDataGridViewTextBoxColumn.Name = "wNKLIENCIDataGridViewTextBoxColumn";
443	432	this.wNKLIENCIDataGridViewTextBoxColumn.ReadOnly = true;
	433	this.wNKLIENCIDataGridViewTextBoxColumn.Width = 43;
444	434	//
445	435	// wKLIENCIDataGridViewTextBoxColumn
446	436	//
447	437	this.wKLIENCIDataGridViewTextBoxColumn.DataPropertyName = "W_KLIENCI";
448		dataGridViewCellStyle11.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
449		this.wKLIENCIDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle11;
450		this.wKLIENCIDataGridViewTextBoxColumn.FillWeight = 91.90488F;
451		this.wKLIENCIDataGridViewTextBoxColumn.HeaderText = "KL";
	438	dataGridViewCellStyle24.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
	439	this.wKLIENCIDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle24;
	440	this.wKLIENCIDataGridViewTextBoxColumn.HeaderText = "Klien.";
452	441	this.wKLIENCIDataGridViewTextBoxColumn.Name = "wKLIENCIDataGridViewTextBoxColumn";
453	442	this.wKLIENCIDataGridViewTextBoxColumn.ReadOnly = true;
	443	this.wKLIENCIDataGridViewTextBoxColumn.Width = 43;
454	444	//
455	445	// wREKLAMYDataGridViewTextBoxColumn
456	446	//
457	447	this.wREKLAMYDataGridViewTextBoxColumn.DataPropertyName = "W_REKLAMY";
458		dataGridViewCellStyle12.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
459		this.wREKLAMYDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle12;
460		this.wREKLAMYDataGridViewTextBoxColumn.FillWeight = 91.90488F;
461		this.wREKLAMYDataGridViewTextBoxColumn.HeaderText = "RE";
	448	dataGridViewCellStyle25.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
	449	this.wREKLAMYDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle25;
	450	this.wREKLAMYDataGridViewTextBoxColumn.HeaderText = "Rekl";
462	451	this.wREKLAMYDataGridViewTextBoxColumn.Name = "wREKLAMYDataGridViewTextBoxColumn";
463	452	this.wREKLAMYDataGridViewTextBoxColumn.ReadOnly = true;
	453	this.wREKLAMYDataGridViewTextBoxColumn.Width = 43;
464	454	//
465	455	// bindingNavigator1
…	…
485	475	this.zapiszDaneToolStripButton,
486	476	this.toolStripSeparator2,
487		~~this.pobierzDaneToolStripButton,~~
488		~~this.stareProwizjeToolStripButton,~~
489	477	this.zapiszToolStripButton,
490		~~this.przeliczStripButton,~~
491	478	this.naniesNaReklamyToolStripButton,
492	479	this.printToolStripButton,
…	…
500	487	this.agencjaToolStripComboBox,
501	488	this.szukajToolStripButton,
502		this.~~wyczyscToolStripButt~~on});
	489	this.btnBlockProvision});
503	490	this.bindingNavigator1.Location = new System.Drawing.Point(0, 0);
504	491	this.bindingNavigator1.MoveFirstItem = this.bindingNavigatorMoveFirstItem;
…	…
622	609	this.toolStripSeparator2.Size = new System.Drawing.Size(6, 31);
623	610	//
624		~~// pobierzDaneToolStripButton~~
625		//
626		~~this.pobierzDaneToolStripButton.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;~~
627		~~this.pobierzDaneToolStripButton.Enabled = false;~~
628		~~this.pobierzDaneToolStripButton.Image = ((System.Drawing.Image)(resources.GetObject("pobierzDaneToolStripButton.Image")));~~
629		~~this.pobierzDaneToolStripButton.ImageTransparentColor = System.Drawing.Color.Magenta;~~
630		~~this.pobierzDaneToolStripButton.Name = "pobierzDaneToolStripButton";~~
631		~~this.pobierzDaneToolStripButton.Size = new System.Drawing.Size(28, 28);~~
632		~~this.pobierzDaneToolStripButton.Text = "Pobierz dane";~~
633		~~this.pobierzDaneToolStripButton.Click += new System.EventHandler(this.pobierzDaneToolStripButton_Click);~~
634		//
635		~~// stareProwizjeToolStripButton~~
636		//
637		~~this.stareProwizjeToolStripButton.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Text;~~
638		~~this.stareProwizjeToolStripButton.Image = ((System.Drawing.Image)(resources.GetObject("stareProwizjeToolStripButton.Image")));~~
639		~~this.stareProwizjeToolStripButton.ImageTransparentColor = System.Drawing.Color.Magenta;~~
640		~~this.stareProwizjeToolStripButton.Name = "stareProwizjeToolStripButton";~~
641		~~this.stareProwizjeToolStripButton.Size = new System.Drawing.Size(23, 28);~~
642		~~this.stareProwizjeToolStripButton.Text = "SP";~~
643		~~this.stareProwizjeToolStripButton.Click += new System.EventHandler(this.stareProwizjeToolStripButton_Click);~~
644		//
645	611	// zapiszToolStripButton
646	612	//
…	…
654	620	this.zapiszToolStripButton.Click += new System.EventHandler(this.zapiszToolStripButton_Click);
655	621	//
656		~~// przeliczStripButton~~
657		//
658		~~this.przeliczStripButton.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;~~
659		~~this.przeliczStripButton.Enabled = false;~~
660		~~this.przeliczStripButton.Image = ((System.Drawing.Image)(resources.GetObject("przeliczStripButton.Image")));~~
661		~~this.przeliczStripButton.ImageTransparentColor = System.Drawing.Color.Magenta;~~
662		~~this.przeliczStripButton.Name = "przeliczStripButton";~~
663		~~this.przeliczStripButton.Size = new System.Drawing.Size(28, 28);~~
664		~~this.przeliczStripButton.Text = "Przelicz";~~
665		~~this.przeliczStripButton.Visible = false;~~
666		~~this.przeliczStripButton.Click += new System.EventHandler(this.przeliczStripButton_Click);~~
667		//
668	622	// naniesNaReklamyToolStripButton
669	623	//
…	…
745	699	this.szukajToolStripButton.Click += new System.EventHandler(this.szukajToolStripButton_Click);
746	700	//
747		// wyczyscToolStripButton
748		//
749		this.wyczyscToolStripButton.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
750		this.wyczyscToolStripButton.Image = ((System.Drawing.Image)(resources.GetObject("wyczyscToolStripButton.Image")));
751		this.wyczyscToolStripButton.ImageTransparentColor = System.Drawing.Color.Magenta;
752		this.wyczyscToolStripButton.Name = "wyczyscToolStripButton";
753		this.wyczyscToolStripButton.Size = new System.Drawing.Size(28, 28);
754		this.wyczyscToolStripButton.Text = "Wyczyæ filtr";
755		this.wyczyscToolStripButton.Click += new System.EventHandler(this.wyczyscToolStripButton_Click);
	701	// btnBlockProvision
	702	//
	703	this.btnBlockProvision.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Text;
	704	this.btnBlockProvision.ForeColor = System.Drawing.Color.Red;
	705	this.btnBlockProvision.ImageTransparentColor = System.Drawing.Color.Transparent;
	706	this.btnBlockProvision.Name = "btnBlockProvision";
	707	this.btnBlockProvision.Size = new System.Drawing.Size(126, 28);
	708	this.btnBlockProvision.Text = "Prowizja blokuj/odblokuj";
	709	this.btnBlockProvision.TextImageRelation = System.Windows.Forms.TextImageRelation.TextBeforeImage;
	710	this.btnBlockProvision.Visible = false;
	711	this.btnBlockProvision.Click += new System.EventHandler(this.btnBlockProvision_Click);
756	712	//
757	713	// agencjeTableAdapter1
…	…
827	783	private System.Windows.Forms.ToolStripButton zapiszDaneToolStripButton;
828	784	private System.Windows.Forms.ToolStripSeparator toolStripSeparator2;
829		~~private System.Windows.Forms.ToolStripButton pobierzDaneToolStripButton;~~
830		~~private System.Windows.Forms.ToolStripButton przeliczStripButton;~~
831	785	private System.Windows.Forms.ToolStripButton zapiszToolStripButton;
832	786	private System.Windows.Forms.ToolStripButton naniesNaReklamyToolStripButton;
…	…
840	794	private System.Windows.Forms.ToolStripComboBox agencjaToolStripComboBox;
841	795	private System.Windows.Forms.ToolStripButton szukajToolStripButton;
842		~~private System.Windows.Forms.ToolStripButton wyczyscToolStripButton;~~
843	796	private Baza_Reklam.SLOWNIKDataSetTableAdapters.AGENCJETableAdapter agencjeTableAdapter1;
	797	private System.Windows.Forms.Label ukrytyLabel;
	798	private System.Windows.Forms.ToolStripButton printToolStripButton;
844	799	private System.Windows.Forms.DataGridViewComboBoxColumn sYMBOLDataGridViewTextBoxColumn;
845	800	private System.Windows.Forms.DataGridViewTextBoxColumn rOKDataGridViewTextBoxColumn;
…	…
863	818	private System.Windows.Forms.DataGridViewTextBoxColumn wKLIENCIDataGridViewTextBoxColumn;
864	819	private System.Windows.Forms.DataGridViewTextBoxColumn wREKLAMYDataGridViewTextBoxColumn;
865		private System.Windows.Forms.Label ukrytyLabel;
866		private System.Windows.Forms.ToolStripButton printToolStripButton;
867		private System.Windows.Forms.ToolStripButton stareProwizjeToolStripButton;
	820	private System.Windows.Forms.ToolStripButton btnBlockProvision;
868	821
869	822	}

branches/ReklamaReorganizacja/BazaReklam/ProvisionForm.cs

r593	r680
5	5	using System.Data.SqlClient;
6	6	using System.Windows.Forms;
	7
7	8	using Baza_Reklam.Classes.Interfaces;
	9	using Baza_Reklam.Classes.Helpers;
8	10
9	11	namespace Baza_Reklam
…	…
11	13	public partial class ProvisionForm : Form, IForm
12	14	{
13
14	15	private short rok;
15	16	private short miesiac;
16	17	private int agencja;
17	18
	19	private bool? _isProvisionBlocked;
18	20
19	21	/// <summary>
…	…
44	46	}
45	47
46
47
48
49	48	private static ProvisionForm provisionForm;
50	49
51		public static ProvisionForm getProvisionForm(MDIBazaReklam parent)
	50	public static ProvisionForm GetProvisionForm(MDIBazaReklam parent)
52	51	{
53	52	if (provisionForm == null)
…	…
78	77	OCENAComboCoxColumn.ValueMember = "value";
79	78
80		dodajPlanToolStripButton.Enabled = User.Instance().~~St_k~~ierownik;
81		usunToolStripButton.Enabled = User.Instance().~~St_k~~ierownik;
	79	dodajPlanToolStripButton.Enabled = User.Instance().IsKierownik;
	80	usunToolStripButton.Enabled = User.Instance().IsKierownik;
82	81	}
83	82
…	…
93	92	((ComboBox)agencjaToolStripComboBox.Control).SelectedValue = User.Instance().IdAgencji;
94	93
95		if (!User.Instance().~~St_k~~ierownik)
	94	if (!User.Instance().IsKierownik)
96	95	{
97	96	agencjaToolStripComboBox.Enabled = false;
…	…
100	99	}
101	100
102		/*
103		private void treeView1_AfterExpand(object sender, TreeViewEventArgs e)
104		{
105		SqlCommand command = new SqlCommand();
106		command.Connection = new SqlConnection(ConnString.getConnString().Value);
107
108		if (e.Node != null)
109		{
110		switch (e.Node.Level)
111		{
112		case 0:
113		e.Node.Nodes.Clear();
114
115		TreeNode node;
116
117		command.CommandText = "select distinct datepart(year,DATA_W) as rok from dbo.NR where datepart(year,DATA_W) is not null and datepart(year,DATA_W)>= 2003 order by rok desc";
118		command.Connection.Open();
119		SqlDataReader reader = command.ExecuteReader();
120
121		while (reader.Read())
122		{
123		node = new TreeNode(reader.GetValue(0).ToString());
124		node.Name = reader.GetValue(0).ToString();
125
126		for (int i = 12; i >= 1; i--)
127		{
128		TreeNode node2 = new TreeNode(i.ToString());
129		node2.Name = i.ToString();
130		// node2.Nodes.Add(new TreeNode());
131		node.Nodes.Add(node2);
132		}
133		e.Node.Nodes.Add(node);
134		}
135		command.Connection.Close();
136
137		break;
138		case 1:
139		break;
140		case 2:
141		break;
142		}
143		}
144		}
145		*/
146
147		/// <summary>
148		/// Pobiera dane o kontaktach i bud¿ecie.
149		/// </summary>
150		private void pobierzDaneToolStripButton_Click(object sender, EventArgs e)
	101	/// <summary>
	102	/// Krok 1
	103	/// Wylicza i zapisuje prowizjê agenta do planu
	104	/// </summary>
	105	private void zapiszToolStripButton_Click(object sender, EventArgs e)
151	106	{
152	107	Cursor = Cursors.WaitCursor;
153	108
154		SqlCommand command = new SqlCommand();
155		command.Connection = new SqlConnection(ConnString.getConnString().Value);
156		command.CommandType = CommandType.StoredProcedure;
157
158		command.CommandText = "PROC_WYLICZ_I_ZAPISZ_DANE_O_KONTAKTACH_I_BUDZECIE";
159		command.Parameters.AddWithValue("@rok", rok);
160		command.Parameters.AddWithValue("@ms", miesiac);
161
162		command.Connection.Open();
163
164		SqlTransaction transaction = command.Connection.BeginTransaction();
165
166		command.Transaction = transaction;
	109	SqlConnection conn = null;
	110	SqlTransaction transaction = null;
167	111
168	112	try
169	113	{
	114	conn = new SqlConnection(ConnString.getConnString().Value);
	115	conn.Open();
	116	transaction = conn.BeginTransaction();
	117
	118	SqlCommand command = new SqlCommand();
	119	command.CommandType = CommandType.StoredProcedure;
	120	command.Connection = conn;
	121	command.Transaction = transaction;
	122
	123	//Krok 1
	124	//oblicza procent prowizji i wykonany budzet, generuje dane dla wybranego biura za wybrany miesiac
	125	command.CommandText = "PROC_WYLICZ_I_ZAPISZ_DANE_O_KONTAKTACH_I_BUDZECIE";
	126	command.Parameters.AddWithValue("@rok", rok);
	127	command.Parameters.AddWithValue("@ms", miesiac);
170	128	command.ExecuteNonQuery();
	129
	130	//TODO: Zastanowic sie, czy ten krok jest jeszcze w ogole potrzebny...
	131	//TODO: Nawet gdyby zaplacono za fakture z 2008 to i tak nie bedzie sie liczyc do prowizji
	132	//Krok 2
	133	//nalicza prowizje dla faktur wystawionych przed 2009
	134	command.CommandText = "PROC_WYLICZ_I_ZAPISZ_PROWIZJE_DO_REKLAM";
	135	command.ExecuteNonQuery();
	136
	137	//Krok 3
	138	//Wylicza i zapisuje prowizjê agenta do planu
	139	command.CommandText = "PROC_WYLICZ_I_ZAPISZ_PROWIZJE_AGENTA_DO_PLANU";
	140	command.Parameters.AddWithValue("@id_Agencji", agencja);
	141	command.ExecuteNonQuery();
	142
171	143	transaction.Commit();
172		MessageBox.Show("Dane pobrano!");
	144	MessageBox.Show("Dane pobrano i prowizja zosta³a zapisana.", "Baza Reklam - Prowizje");
173	145	}
174	146	catch
175	147	{
176		transaction.Rollback();
	148	if (transaction != null)
	149	transaction.Rollback();
177	150	throw;
178	151	}
179	152	finally
180	153	{
181		command.Connection.Close();
	154	if (conn != null) conn.Close();
	155
182	156	rEKLAMADataSet.PLAN.Clear();
183	157	pLANTableAdapter.FillByAgencja(rEKLAMADataSet.PLAN, rok, miesiac, agencja);
	158
184	159	Cursor = Cursors.Default;
185	160	}
…	…
187	162
188	163	/// <summary>
189		/// Wylicza i zapisuje prowizjê agenta do planu
190		/// </summary>
191		private void zapiszToolStripButton_Click(object sender, EventArgs e)
	164	/// Krok 2
	165	/// dyrektor ma prawo zmienic recznie procent prowizji, dodac ocene dla wybranego handlowca, nanosi poprawione dane
	166	/// </summary>
	167	private void naniesNaReklamyToolStripButton_Click(object sender, EventArgs e)
192	168	{
193	169	Cursor = Cursors.WaitCursor;
…	…
199	175	command.CommandType = CommandType.StoredProcedure;
200	176
201		~~command.CommandText = "PROC_WYLICZ_I_ZAPISZ_PROWIZJE_AGENTA_DO_PLANU";~~
202		~~command.Parameters.AddWithValue("@rok", rok);~~
203		~~command.Parameters.AddWithValue("@ms", miesiac);~~
204		~~command.Parameters.AddWithValue("@id_Agencji", agencja);~~
205		~~command.Connection.Open();~~
206
207		~~SqlTransaction transaction = command.Connection.BeginTransaction();~~
208
209		~~command.Transaction = transaction;~~
210
211		~~try~~
212		{
213		~~command.ExecuteNonQuery();~~
214		~~transaction.Commit();~~
215		~~MessageBox.Show("Prowizja zosta³a zapisana!");~~
216		}
217		~~catch~~
218		{
219		~~transaction.Rollback();~~
220		~~throw;~~
221		}
222		~~finally~~
223		{
224		~~command.Connection.Close();~~
225
226		~~rEKLAMADataSet.PLAN.Clear();~~
227
228		~~pLANTableAdapter.FillByAgencja(rEKLAMADataSet.PLAN, rok, miesiac, agencja);~~
229
230		~~Cursor = Cursors.Default;~~
231		}
232		}
233
234		~~private void naniesNaReklamyToolStripButton_Click(object sender, EventArgs e)~~
235		{
236		~~Cursor = Cursors.WaitCursor;~~
237
238		~~SqlCommand command = new SqlCommand();~~
239
240		~~command.Connection = new SqlConnection(ConnString.getConnString().Value);~~
241
242		~~command.CommandType = CommandType.StoredProcedure;~~
243
244		~~// command.CommandText = "PROC_WYLICZ_I_ZAPISZ_PROWIZJE_DO_REKLAM";~~
245	177	command.CommandText = "PROC_WYLICZ_I_ZAPISZ_PROWIZJE";
246	178	command.Parameters.AddWithValue("@rok", rok);
…	…
258	190	command.ExecuteNonQuery();
259	191	transaction.Commit();
260		MessageBox.Show("Prowizja zosta³a naniesiona na zlecenia");
	192	MessageBox.Show("Prowizja zosta³a naniesiona na zlecenia", "Baza Reklam - Prowizje");
261	193	}
262	194	catch
…	…
269	201	command.Connection.Close();
270	202	Cursor = Cursors.Default;
271		~~MessageBox.Show("Prowizja naniesiona na zlecenia");~~
272	203	}
273	204	}
…	…
306	237	}
307	238
308		/*
309		~~private void ukryjKolumnyToolStripButton_Click(object sender, EventArgs e)~~
310		{
311		~~rOKDataGridViewTextBoxColumn.Visible = rOKDataGridViewTextBoxColumn.Visible ? false : true;~~
312
313		~~mSDataGridViewTextBoxColumn.Visible = mSDataGridViewTextBoxColumn.Visible ? false : true;~~
314		}
315		*/
316
317		~~private void prowizjeDataGridView_Leave(object sender, EventArgs e)~~
318		{
319		~~//ukrytyLabel.Select();~~
320		~~prowizjeDataGridView.EndEdit();~~
321		~~//pLANBindingSource.EndEdit();~~
322
323		~~REKLAMADataSet.PLANDataTable changes = rEKLAMADataSet.PLAN.GetChanges(DataRowState.Modified) as~~
324		~~REKLAMADataSet.PLANDataTable;~~
325
326		~~if (changes != null)~~
327		{
328		~~if (Validate())~~
329		{
330		~~pLANBindingSource.EndEdit();~~
331		~~pLANTableAdapter.Update(rEKLAMADataSet.PLAN);~~
332		}
333		}
334		}
335
336	239	/// <summary>
337	240	/// Podsumowuje bud¿et do wykonania
338	241	/// </summary>
339		private void uzupelnijBDsuma()
	242	private void UzupelnijBDsuma()
340	243	{
341	244	int kasa = 0;
…	…
350	253	/// Podsumowuje bud¿et wykonany
351	254	/// </summary>
352		private void ~~uzupelnijBD~~WykonanySuma()
	255	private void UzupelnijBudzetWykonanySuma()
353	256	{
354	257	int kasa = 0;
…	…
360	263	}
361	264
362		~~/// <summary>~~
363		~~/// Zamienia wpisan¹ liczbê do decimal~~
364		~~/// </summary>~~
365		~~private void prowizjeDataGridView_CellLeave(object sender, DataGridViewCellEventArgs e)~~
366		{
367		~~ukrytyLabel.Select();~~
368		~~prowizjeDataGridView.EndEdit();~~
369		~~pLANBindingSource.EndEdit();~~
370
371		~~if (prowizjeDataGridView.Columns[e.ColumnIndex].Name == "PR_PROWIZJI")~~
372		{
373
374		~~if (Convert.ToDecimal(prowizjeDataGridView[e.ColumnIndex, e.RowIndex].Value) >= 1)~~
375		{
376		~~prowizjeDataGridView[e.ColumnIndex, e.RowIndex].Value = Convert.ToDecimal(prowizjeDataGridView[e.ColumnIndex, e.RowIndex].Value) / 100;~~
377		}
378		}
379
380		~~REKLAMADataSet.PLANDataTable changes = rEKLAMADataSet.PLAN.GetChanges(DataRowState.Modified) as~~
381		~~REKLAMADataSet.PLANDataTable;~~
382
383		~~if (changes != null)~~
384		{
385		~~pLANBindingSource.EndEdit();~~
386		~~pLANTableAdapter.Update(rEKLAMADataSet.PLAN);~~
387		}
388		}
389
390	265	private void pLANBindingSource_ListChanged(object sender, ListChangedEventArgs e)
391	266	{
392		uzupelnijBDsuma();
393		uzupelnijBDWykonanySuma();
394		}
395
	267	UzupelnijBDsuma();
	268	UzupelnijBudzetWykonanySuma();
	269	}
396	270
397	271	private void szukajToolStripButton_Click(object sender, EventArgs e)
398	272	{
399		if (~~rokToolStripTextBox.Text != ""~~)
	273	if (!string.IsNullOrEmpty(rokToolStripTextBox.Text))
400	274	{
401	275	short i;
…	…
414	288	}
415	289
416		if (~~msToolStripTextBox.Text != ""~~)
	290	if (!string.IsNullOrEmpty(msToolStripTextBox.Text))
417	291	{
418	292	short i;
…	…
441	315	agencja = Convert.ToInt32(((ComboBox)agencjaToolStripComboBox.Control).SelectedValue);
442	316
443		~~uprawnienia(~~);
	317	Uprawnienia(agencja, rok, miesiac);
444	318
445	319	sLOWNIKDataSet.AGENCI.Clear();
…	…
448	322	aGENCITableAdapter.FillByIdAgencji(sLOWNIKDataSet.AGENCI, agencja);
449	323	pLANTableAdapter.FillByAgencja(rEKLAMADataSet.PLAN, rok, miesiac, agencja);
450		}
451
452		/*
453		private void szukajToolStripButton_Click(object sender, EventArgs e)
454		{
455		this.Cursor = Cursors.WaitCursor;
456
457		string query = "SELECT top 1000 [PLAN].* FROM AGENCJE INNER JOIN AGENCI ON AGENCJE.Id_agencji = AGENCI.ID_AGENCJI " +
458		" INNER JOIN [PLAN] ON AGENCI.Symbol = [PLAN].SYMBOL WHERE 1 = 1 ";
459
460		SqlCommand command = new SqlCommand();
461		command.CommandText = query;
462
463		if (rokToolStripTextBox.Text != "")
464		{
465		short i;
466		if (!Int16.TryParse(rokToolStripTextBox.Text, out i))
	324
	325
	326	btnBlockProvision.Visible = User.Instance().IsKsiegowosc;
	327	if (!User.Instance().IsKsiegowosc) return;
	328
	329	_isProvisionBlocked =
	330	new ProvisionHelper(ConnString.getConnString().Value).IsProvisionBlockedInDb(agencja, rok, miesiac);
	331
	332	SetBlockProvisionButtonText(_isProvisionBlocked.Value);
	333	}
	334
	335	private void Uprawnienia(int agencyId, int year, int month)
	336	{
	337	if (IsProvisionBlocked(agencyId, year, month, User.Instance().IsKierownik))
	338	{
	339	OCENAComboCoxColumn.Visible = false;
	340	oCENADataGridViewTextBoxColumn.Visible = true;
	341
	342	prowizjeDataGridView.ReadOnly = true;
	343	usunToolStripButton.Enabled = false;
	344	naniesNaReklamyToolStripButton.Enabled = false;
	345	zapiszDaneToolStripButton.Enabled = false;
	346	zapiszToolStripButton.Enabled = false;
	347	}
	348	else
	349	{
	350	OCENAComboCoxColumn.Visible = true;
	351	oCENADataGridViewTextBoxColumn.Visible = false;
	352	prowizjeDataGridView.ReadOnly = false;
	353
	354	usunToolStripButton.Enabled = true;
	355	naniesNaReklamyToolStripButton.Enabled = true;
	356	zapiszDaneToolStripButton.Enabled = true;
	357	zapiszToolStripButton.Enabled = true;
	358	}
	359	}
	360
	361	private bool IsProvisionBlocked(int agencyId, int year, int month, bool isKierownik)
	362	{
	363	ProvisionHelper provisionHelper = new ProvisionHelper(ConnString.getConnString().Value);
	364	return provisionHelper.IsProvisionBlocked(agencyId, year, month, isKierownik);
	365	}
	366
	367	private void prowizjeDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
	368	{
	369	if (Validate())
	370	{
	371	if (prowizjeDataGridView.Columns[e.ColumnIndex].Name == "PR_PROWIZJI")
467	372	{
468		MessageBox.Show("Podaj prawid³owy rok.");
469		this.Cursor = Cursors.Default;
470		return;
471		}
472		command.CommandText += " AND [PLAN].rok = @rok ";
473		command.Parameters.AddWithValue("@rok", rokToolStripTextBox.Text);
474		this.rok = Convert.ToInt16(rokToolStripTextBox.Text);
475		}
476
477		if (msToolStripTextBox.Text != "")
478		{
479		short i;
480		if (!Int16.TryParse(msToolStripTextBox.Text, out i))
481		{
482		MessageBox.Show("Podaj prawid³owy miesi¹c.");
483		this.Cursor = Cursors.Default;
484		return;
485		}
486		command.CommandText += " AND [PLAN].ms = @ms ";
487		command.Parameters.AddWithValue("ms", msToolStripTextBox.Text);
488		this.miesiac = Convert.ToInt16(msToolStripTextBox.Text);
489		}
490
491		if (((ComboBox)agencjaToolStripComboBox.Control).SelectedValue == null)
492		{
493		MessageBox.Show("Wybierz agencjê");
494		return;
495		}
496		else
497		{
498		command.CommandText += " AND AGENCJE.Id_Agencji=@agencja";
499		command.Parameters.AddWithValue("@agencja", ((ComboBox)agencjaToolStripComboBox.Control).SelectedValue);
500		this.agencja = Convert.ToInt32(((ComboBox)agencjaToolStripComboBox.Control).SelectedValue);
501		}
502
503		// uprawnienia();
504		poblokujWiersze();
505
506
507		this.sLOWNIKDataSet.AGENCI.Clear();
508		this.aGENCITableAdapter.FillByIdAgencji(this.sLOWNIKDataSet.AGENCI, this.agencja);
509
510		this.rEKLAMADataSet.PLAN.Clear();
511		// this.pLANTableAdapter.FillByAgencja(this.rEKLAMADataSet.PLAN, this.rok, this.miesiac, this.agencja);
512
513		command.Connection = new SqlConnection(ConnString.getConnString().Value);
514		SqlDataAdapter adapter = new SqlDataAdapter();
515		adapter.SelectCommand = command;
516
517		adapter.Fill(rEKLAMADataSet.PLAN);
518
519		this.Cursor = Cursors.Default;
520		}
521
522		private void poblokujWiersze()
523		{
524		if (User.Instance().St_kierownik)
525		{
526		prowizjeDataGridView.ReadOnly = false;
527		foreach (DataGridViewRow r in prowizjeDataGridView.Rows)
528		{
529		if (!((Convert.ToInt32(r.Cells["rOKDataGridViewTextBoxColumn"].Value) > DateTime.Today.Year) \|
530		((Convert.ToInt32(r.Cells["rOKDataGridViewTextBoxColumn"].Value) == DateTime.Today.Year) & (Convert.ToInt32(r.Cells["mSDataGridViewTextBoxColumn"].Value) >= DateTime.Today.Month - 1)) \|
531		((Convert.ToInt32(r.Cells["rOKDataGridViewTextBoxColumn"].Value) == DateTime.Today.Year - 1) & (Convert.ToInt32(r.Cells["mSDataGridViewTextBoxColumn"].Value) == 12) & (DateTime.Today.Month == 1))))
	373	if (Convert.ToDecimal(prowizjeDataGridView[e.ColumnIndex, e.RowIndex].Value) >= 1)
532	374	{
533		~~r.ReadOnly = true~~;
	375	prowizjeDataGridView[e.ColumnIndex, e.RowIndex].Value = Convert.ToDecimal(prowizjeDataGridView[e.ColumnIndex, e.RowIndex].Value) / 100;
534	376	}
535	377	}
536	378	}
537	379	}
538		*/
539
540		private void uprawnienia()
541		{
542		if (User.Instance().St_kierownik)
543		{
544
545		if (!((rok > DateTime.Today.Year) \|
546		((rok == DateTime.Today.Year) & (miesiac >= DateTime.Today.Month - 1)) \|
547		((rok == DateTime.Today.Year - 1) & (miesiac == 12) & (DateTime.Today.Month == 1))))
	380
	381	/// <summary>
	382	/// Zamienia wpisan¹ liczbê do decimal
	383	/// </summary>
	384	private void prowizjeDataGridView_CellLeave(object sender, DataGridViewCellEventArgs e)
	385	{
	386	if (!Validate())
	387	{
	388	if (prowizjeDataGridView.Columns[e.ColumnIndex].Name == "PR_PROWIZJI")
	389	MessageBox.Show("Proszê wprowadziæ prowizjê bez znaku % - tylko wartoæ liczbow¹");
	390	else
	391	MessageBox.Show("Proszê wprowadziæ poprawne dane");
	392
	393	return;
	394	}
	395
	396	ukrytyLabel.Select();
	397	prowizjeDataGridView.EndEdit();
	398	pLANBindingSource.EndEdit();
	399
	400	if (prowizjeDataGridView.Columns[e.ColumnIndex].Name == "PR_PROWIZJI")
	401	{
	402	if (Convert.ToDecimal(prowizjeDataGridView[e.ColumnIndex, e.RowIndex].Value) >= 1)
548	403	{
549		OCENAComboCoxColumn.Visible = false;
550		oCENADataGridViewTextBoxColumn.Visible = true;
551
552		prowizjeDataGridView.ReadOnly = true;
553		usunToolStripButton.Enabled = false;
554		pobierzDaneToolStripButton.Enabled = false;
555		naniesNaReklamyToolStripButton.Enabled = false;
556		zapiszDaneToolStripButton.Enabled = false;
557		zapiszToolStripButton.Enabled = false;
558
	404	prowizjeDataGridView[e.ColumnIndex, e.RowIndex].Value = Convert.ToDecimal(prowizjeDataGridView[e.ColumnIndex, e.RowIndex].Value) / 100;
559	405	}
560		else
561		{
562		OCENAComboCoxColumn.Visible = true;
563		oCENADataGridViewTextBoxColumn.Visible = false;
564		prowizjeDataGridView.ReadOnly = false;
565
566		usunToolStripButton.Enabled = true;
567		pobierzDaneToolStripButton.Enabled = true;
568		naniesNaReklamyToolStripButton.Enabled = true;
569		zapiszDaneToolStripButton.Enabled = true;
570		zapiszToolStripButton.Enabled = true;
571
572		stareProwizjeToolStripButton.Enabled = true;
573		}
574		}
575		}
576
577		private void prowizjeDataGridView_DataError_1(object sender, DataGridViewDataErrorEventArgs e)
578		{
579		MessageBox.Show("Wprowad poprawne dane");
580		}
581
582		private void ProvisionForm_Leave(object sender, EventArgs e)
	406	}
	407
	408	REKLAMADataSet.PLANDataTable changes = rEKLAMADataSet.PLAN.GetChanges(DataRowState.Modified) as
	409	REKLAMADataSet.PLANDataTable;
	410
	411	if (changes != null)
	412	{
	413	pLANBindingSource.EndEdit();
	414	pLANTableAdapter.Update(rEKLAMADataSet.PLAN);
	415	}
	416	}
	417
	418	private void prowizjeDataGridView_Leave(object sender, EventArgs e)
583	419	{
584	420	prowizjeDataGridView.EndEdit();
585		~~//pLANBindingSource.EndEdit();~~
586	421
587	422	REKLAMADataSet.PLANDataTable changes = rEKLAMADataSet.PLAN.GetChanges(DataRowState.Modified) as
588	423	REKLAMADataSet.PLANDataTable;
589	424
590		if (changes != null)
591		{
592		if (Validate())
593		{
594		pLANBindingSource.EndEdit();
595		pLANTableAdapter.Update(rEKLAMADataSet.PLAN);
596		}
	425	if (changes != null && Validate())
	426	{
	427	pLANBindingSource.EndEdit();
	428	pLANTableAdapter.Update(rEKLAMADataSet.PLAN);
	429	}
	430	}
	431
	432	//TODO: Wprowadziæ sensowniejsz¹ walidacjê danych
	433	private void prowizjeDataGridView_DataError(object sender, DataGridViewDataErrorEventArgs e)
	434	{
	435
	436	}
	437
	438	private void ProvisionForm_Leave(object sender, EventArgs e)
	439	{
	440	prowizjeDataGridView.EndEdit();
	441
	442	REKLAMADataSet.PLANDataTable changes =
	443	rEKLAMADataSet.PLAN.GetChanges(DataRowState.Modified) as REKLAMADataSet.PLANDataTable;
	444
	445	if (changes != null && Validate())
	446	{
	447	pLANBindingSource.EndEdit();
	448	pLANTableAdapter.Update(rEKLAMADataSet.PLAN);
597	449	}
598	450	}
…	…
603	455	}
604	456
605		~~private void wyczyscToolStripButton_Click(object sender, EventArgs e)~~
606		{
607
608		}
609
610		~~private void przeliczStripButton_Click(object sender, EventArgs e)~~
611		{
612
613		}
614
615		~~private void stareProwizjeToolStripButton_Click(object sender, EventArgs e)~~
616		{
617		~~Cursor = Cursors.WaitCursor;~~
618
619		~~SqlCommand command = new SqlCommand();~~
620
621		~~command.Connection = new SqlConnection(ConnString.getConnString().Value);~~
622
623		~~command.CommandType = CommandType.StoredProcedure;~~
624
625		~~command.CommandText = "PROC_WYLICZ_I_ZAPISZ_PROWIZJE_DO_REKLAM";~~
626		~~command.Parameters.AddWithValue("@rok", rok);~~
627		~~command.Parameters.AddWithValue("@ms", miesiac);~~
628
629		~~command.Connection.Open();~~
630
631		~~SqlTransaction transaction = command.Connection.BeginTransaction();~~
632
633		~~command.Transaction = transaction;~~
634
635		~~try~~
636		{
637		~~command.ExecuteNonQuery();~~
638		~~transaction.Commit();~~
639		~~MessageBox.Show("Prowizja zosta³a naniesiona na zlecenia");~~
640		}
641		~~catch (Exception)~~
642		{
643		~~transaction.Rollback();~~
644		~~throw;~~
645		}
646		~~finally~~
647		{
648		~~command.Connection.Close();~~
649		~~Cursor = Cursors.Default;~~
650		}
651		}
652
653	457	public void CloseForm()
654	458	{
655	459	provisionForm = null;
	460	}
	461
	462	private void btnBlockProvision_Click(object sender, EventArgs e)
	463	{
	464	if (!User.Instance().IsKsiegowosc) return;
	465
	466	if (!_isProvisionBlocked.HasValue) return;
	467
	468	ProvisionHelper provisionHelper = new ProvisionHelper(ConnString.getConnString().Value);
	469	provisionHelper.SetProvision(!_isProvisionBlocked.Value, agencja, rok, miesiac, User.Instance().Login);
	470
	471	_isProvisionBlocked = !_isProvisionBlocked.Value;
	472
	473	SetBlockProvisionButtonText(_isProvisionBlocked.Value);
	474
	475	Uprawnienia(agencja, rok, miesiac);
	476
	477	sLOWNIKDataSet.AGENCI.Clear();
	478	rEKLAMADataSet.PLAN.Clear();
	479
	480	aGENCITableAdapter.FillByIdAgencji(sLOWNIKDataSet.AGENCI, agencja);
	481	pLANTableAdapter.FillByAgencja(rEKLAMADataSet.PLAN, rok, miesiac, agencja);
	482	}
	483
	484	private void SetBlockProvisionButtonText(bool isBlocked)
	485	{
	486	btnBlockProvision.Text = isBlocked ? "Odblokuj edycjê prowizji" : "Zablokuj edycjê prowizji";
	487	btnBlockProvision.Checked = isBlocked;
656	488	}
657	489	}

branches/ReklamaReorganizacja/BazaReklam/ProvisionForm.resx

r593	r680
119	119	</resheader>
120	120	<metadata name="aGENCIBindingSource.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
121		<value>~~645, 56~~</value>
	121	<value>583, 17</value>
122	122	</metadata>
123	123	<metadata name="sLOWNIKDataSet.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
124		<value>793, 17</value>
	124	<value>445, 17</value>
	125	</metadata>
	126	<metadata name="sLOWNIKDataSet.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
	127	<value>445, 17</value>
125	128	</metadata>
126	129	<metadata name="pLANBindingSource.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
127		<value>~~478~~, 17</value>
	130	<value>297, 17</value>
128	131	</metadata>
129	132	<metadata name="rEKLAMADataSet.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
130	133	<value>17, 17</value>
131	134	</metadata>
	135	<metadata name="rEKLAMADataSet.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
	136	<value>17, 17</value>
	137	</metadata>
132	138	<metadata name="aGENCITableAdapter.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
133		<value>~~817, 56~~</value>
	139	<value>744, 17</value>
134	140	</metadata>
135	141	<metadata name="pLANTableAdapter.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
136		<value>323, 17</value>
	142	<value>153, 17</value>
137	143	</metadata>
138	144	<metadata name="OCENAComboCoxColumn.UserAddedColumn" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
…	…
143	149	</metadata>
144	150	<metadata name="bindingNavigator1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
145		<value>1~~91, 95~~</value>
	151	<value>1063, 17</value>
146	152	</metadata>
147	153	<assembly alias="System.Drawing" name="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
…	…
218	224	<value>
219	225	iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
220		YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABZBJREFUSEt9VglQ
221		lWUUPU8eIT~~x4ooAKPBYBRVRIcQFJ3FAQQUWWNM0l0xLcxlwaydwbc5zRUadmspLKlmkxWyZzabRlxhxl~~
222		~~bEpzH8sMsWlxAcdnD/7T+R5YgNibOfPPe9z/3Pude8/98MF9PpXAoAlA+VngWBXgUVh9a6H7gYgS4EAu~~
223		~~EKy//3IGcOtp3Y8X54GS48Dprcmx1rm0btwGbFJwnODb8qU9gPNT4Pjv2XG80COYe31sN94GKsqBAYr1~~
224		~~F2zN3hH5rM2JURZ3LCS3l5HPFfNLX5+aJGCGAjs2feEQYBf5nqph8eT0XmRRLFno4qXUYL4DXFNsX8HR~~
225		~~LMEx4Ku6bbPJLTNFPpFcXcg/C1O5BdirwLTGqrzvfAFsP9c/inyyL1mcwPqxLt4cFc5vEhxcosQKmSdE~~
226		~~NkuwD1j2a0EauWkquaaYXFEg5HF9hNMqAFYoOEbwOQKs25TUyeK8h8hHupPjY+keHckTGSF8A6h+AHhN~~
227		~~cebUnZolWAP0PNapXR23TCdXFZLPjCHLc/l36SC+BVwKBwo+BJZv6BJqceFQckoyrZIE1o2LYXVOZ64M~~
228		~~tFu9gZ0iXS2kCn4t++ansx10LxWxSbAsj3x6FLk4i1XD4/kqcHZdTIjFxcPJGb291VtF8azJi+Sh+EAj~~
229		~~jUTAi0Ke0P6eJpsfdgAzz6SpcWvHN5A/lUXOV7ULMvnzkARyib7PlO6Te5ATuvHOuCh+nxFqkl+WNK+L~~
230		~~4wkh2kjZsnrv9yFA6CfAFT6rUyzJFrHI52eSZQPJORnkrP7ko5qaSUmsL4zj5Zxw7m7rU9cVkPxYKUil~~
231		~~e6VpmsyuU6z7aWgiuXQkOU/kpSI3xDNSyanJqj5J2nfltXwX90YEcDKwSwRbhRyhXWvSNDtNoYz1sQ3X~~
232		~~uEhalzVWbcinpajyHrQkjXtsNI8mB3M9UCk3VYhgqmDGsnVp7mYwBnoPWFMR7PB45kqe2Rrbu+RG94mJ~~
233		~~3snxSPvDEf6U4PKbV5pegtrwP5+vgZTdwNHT6WpyuRpsNJ/Rp0EWVW7IWRxPqyCG1liZbJyLayP9rVWS~~
234		~~SJZNua/2J5VZ87X6YFBbd+3jMo+Rxmg+/UE1tKe3oV5D/UvuopUXwbrccHJ0R1bG+nOjxju5Yfab7yCd~~
235		~~rY02YuW5gXGaGhGXShJDPMVMiqqeJGJpbhV2UcXR5BgX60Xuye3MO9lhvDMijJ6cEJ5NcpjFeKYIyFeS~~
236		~~oKaNth16wH6DCweRj4l4cpOKjSTS2y05jJnMvqnXSvCMaiB3jwjl7awOvDU0mO5h7Vjdz8EKu61mLiDP~~
237		~~IfRuw21Gd0u298qgag0pS9QH7Zjb+VE8lRnGlTabdbFPe1r5Is9pTl472MmazEDeHBTIH3v5cXHDchwh~~
238		~~OPEZMHuXr732zgTp/LCIRcrxMao2irWq+nh6CHfabDf7AG8+D5y42Kcd67JD6W6s3JDXZgbxWoaDVQMC~~
239		~~+EGHNkz/b2zD8C7wbV1xV5GrYo2eJY090vi6HHpYc/4K8JurwaUbQ4Ay3T4/nEsOpHt4e9YOcarqIP41~~
240		~~0MGraQE8EGPncuA7+eIlxY/2mk6badGZRKfIpe3ocN7STr+c1ZGfu/xpKnY27BctWmQJ0d21TTboFjuV~~
241		~~FMDawUG8IvKTKX7c57Ib013UuJpiFgoJgh2jANf7NlRfHx7GqyPDeKSXkxV+Pp5pwEeypHGoaZhO7b1z~~
242		~~jUsd8UCGkhw9HOsrSXy4FjhfCuwXubYMdGOif+O4el3nOwcoegG4sN1m+2OBLivtfUO8WVAe9DCkTcbO~~
243		~~3LMB2gnpKnNXP+DlRknMKc0lY7wQ2CTeezGbBTVYWCSsEmYLmUKE0Jr9zTvGUD0FrS4jhLcQc4O1bUru~~
244		~~PYI+bRqzRulp/oPobKps/P1uTMunSWJurA6CMZa9NeJ/ACvU0yUljr9SAAAAAElFTkSuQmCC~~
	226	YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABYxJREFUSEt9VglQ
	227	lWUUPU8eITsKqMBDEFAEgQQXkMANZVcRMU1zibRwH3JpNPO5NdU4Y2NOzWQllS3TYrZM5tJoy4w5ytiU
	228	5j6WmUvT4gKOzx78p/M9oACxN3Pmn/e4/7n3O/ee++GFu3xqgZxJwIpTwOGLgFthjR2F7gEiJwJ7i4AQ
	229	/f2Xk4BLT+tuvDgDTDwCnHCmxlqnM/twM7BRwXGCd/uXdgJBnwJHfs+P49nkEO7ysl1/G6hZAQxWrK9g
	230	a/OOyGc7E6Mtbq0mt8wln6rgl95edUlApQK7tX5hP2AX+c6LI+LJmSnkhFiy3MHzGSF8B7iq2AGCf5sE
	231	h4GvGjZXkZtmiXwyuaacf5ZncBOwS4GZzVV53vkC2HJ6UDT56ACyIoGNYx28URjBbxL8uVSJFbJAiGqT
	232	YDew/NeyTHLjdHJtBbmqTCihMzLIKgNWKThG8DoIrHcmdbe44D7ygb7k+Fi6iqN4NDuUbwCX7wFeU5w5
	233	dfc2CdYC/Q53D27gppnk6nLyiTHkiiL+PSeHbwHnI4CyD4GVzl5hFquHk9NSaU1MYMO4GF4u6EFngN3q
	234	D2wT6RohQ/Bp3zcfnW2fa5mITYLlJeTjheSSPF4cGc9XgVPOmFCLS0aSlf091VsT4llXEsX98QFGGomA
	235	F4USocsdTTY/bAVmncxU49aNbyJ/LI9cqGoX5fLnYQnkUn2fJd2nJpOT+vD2uGh+nx1mkl+QNK+L4xGh
	236	p5GyffWe78OAsE+AS3xSp1iaL2KRL8wl5w4h52WTsweRD2pqpiSxsTyOFwoiuKOzV0NvQPLDKUilO6Vp
	237	ncyuU6z/aXgiuWw0uUDkc0RuiCszyOmpqj5J2vfm1VIHd0X6cSqwXQTPCwVCcEfStDlNuYz1sQ1XuVha
	238	z22u2pDPSFPlybQkjWtsTx5KDeHTQK3cVCOC6YIZy46laclgDPQesLYmxN/tni95qjS2LeRG98mJnslx
	239	S/sDkb6U4PKbR5oUQW34n8/XQNoO4NCJLDV5hRpsNK9Mb5JFlRtyVsTTKouhNVYmG+egM8rXWi2JZNm0
	240	u2p/TJk1X2v2BXZ21T8s8xhpjOYz71VD+3ka6jHUv+QOWiWRbCiKIIu7sTbWlxs03qlNs992B+lsnbQR
	241	a08PidPUiHiOJDHE08ykqOopIpbmVnkvVdyTHONgo8jdRT14Oz+ct0eF010QylNJ/mYxnpwAlCpJYOtG
	242	2/bfY7/O6hzyIRFPbVWxkUR6uySHMZPZN41aCe7CJnLXqDDeyuvKm8ND6BoRzMsD/Vljt9XNB+Q5hLU0
	243	3GZ0t2R7jwyq1pByovqgHXOrNJrHc8PptNmsc+ldaJWKvKAtef3QINblBvBGTgB/TPHhkqblOEoIwmdA
	244	1XZve/3tSdL5fhGLlONjVG0061X1kaxQbrPZbqQDbz4DHD2XHsyG/DC6mis35PW5gbya7c+Lg/34QddO
	245	zPpvbMPxLvBtQ0VvkatijZ4ljd3S+JocekBz/grwm6PJpRtCgbm6fX44nRpA18gurB8WpKoD+dcQf17J
	246	9OPeGDtXAt/JFy8pvthjOm2mxScTg0QubYsjeFM7/UJeN37u8KWpOKhpv2jRIk/o2Vfb5FndYseT/Fg/
	247	NJCXRH4szYe7HXZjunMaV1NMtZAg2FEION634fK1keG8MjqcB1OCWOPj5Z4BfCRLGoeahunUnjvXuNQ/
	248	HshWkkMHYr0liRfXAWfmAHtEri0D3ZgY1DyuHtd5zwMmvACc3WKz/bFIl5X2viF+TlAeJBvSVmNn7lk/
	249	7YQslbl9IPBysyTmlOaSMV4IaBXvuZjNghoqLBZWC1VCrhApdGR/844xVD9Bq8sI4SnE3GCdW5N7jqBP
	250	p+as0Xqa/yB6mCqbf2+Jaf80ScyN1VUwxrJ3RPwP4ZPS2IHkFmIAAAAASUVORK5CYII=
245	251	</value>
246	252	</data>
…	…
279	285	</value>
280	286	</data>
281		~~<data name="pobierzDaneToolStripButton.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">~~
282		~~<value>~~
283		~~iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8~~
284		~~YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABDdJREFUSEvNlXtQ~~
285		~~VFUcx+8qo21WUgQNOIrRiI9SZERIURqwGAIcHJQGynEj4ikYIu8WLkhDkBEqBiLZkgiygSBglCFgTYo5~~
286		~~1CiyruwCsjzktfLGeOh++51maeylwvBHO/OZs3vnnu/nd879nbsc97/5BKniOO+6QKrnGUJndusKUPPb~~
287		~~+GLNhtTq+5yDJJbCF82exE8ttuOlmp9vA8UKYPVHJLFJ2T87Er/uiE38Kc2PrcAZ+STSL48j9dI9mMbU~~
288		~~3+M2JfEkMZr5St7vDHuVz9VcoPAS+QQiy0cRXj5MjCCucgzGohuT3IbEGK1k7vSeiVf7Pgv+hKbqFm1L~~
289		~~/TjCvhlB2NkhBJcMIrCoH7uLBhBydgRLRHWTnFW8mMINiceUeLbtNeclmu9ZuGwC+8qGEVI6iKDiAfgX~~
290		~~9sFbegfv5fVCdEoNn8IBGIp+neQs+OjHk4hag8z445rvGoGCunGqeAhBZwYQcLofPl9TMIXuOtkDjxPd~~
291		~~cMvuxA5JFzxOqmHgXzrBrYuKfLjEU+Vvtr/6/vkWoKppAvy5YfgV9sO3oA9e+WqIcnvxDgW/ld0F1y87~~
292		~~se14N7Zm9cApqwtbJb3Q9aoe58xCw0nywj+3y7fN14La7+AVQHx+DHtpvwOKBuEp7cMu2o6dOT1wp+Dt~~
293		~~FOyS1QFnCrXhq2AtroB1Qg02f3Idtp+rsNCTJGvDQ/8q2dOz7Pnd12v0/S7KDN6tkBu4l93Udy9rXRl5~~
294		~~DZLau/DJ78EOVvEXt+Gc2Q6H9DbYH+2CNX8Bz3qUQviGpEX4pkQpdMxRCh2+Usx3yq3l9Fa7kGQhIWDd~~
295		~~xY79YsKNiCDYSY17+cPrkF77Df7Sbjge64BjRjvsj7TCNk2F19LaYRFdDb2dZaB7i4jPiHg2T5vhqm3f~~
296		~~OUzALELthaU0vkiYmEZcheTKKDxzO/H6kTZsOayCTWoLNqY0wyqlFWvCK6HrUcIEmYQdm6OFZbC2fWJq~~
297		~~BUwyJWKyP3gp5BccrRnG29kd2EzB1im3YHWgCeuSGmGepMKK0Eo87VbMBIeJFVPzHhincv91FBgH1yL1~~
298		~~h35sz2rD+uRmWCQ3Ym2iEq8kKLAqoQkmwRVY4Hp6SrD879U+NJ3dbBhwGYkVd+CU3oI1HyvpJafAyvgG~~
299		~~mMbKsTRWiUWBFRC6FMxcoO9zEeJyNbYcasZyFszfhIn4BhZHyWAY3QA9v3OY5yydueA5758QUdoLq2Ql~~
300		~~TGLkMI6WwShCBoNwGfTC5HjK+1voOObPXKDvfQm2GR0wjmuEMa+AoVgB/agG6IbV48kPrmKeVzkEDnlM~~
301		~~cIiY9jPg5tjlDenYZ92da5kzxhBYZo8JrI+NCtZnDHPmaUPcxoMDnGXmADffKJUEq6b7kFkTLCH2EJ8S~~
302		~~7CA9SIr2+gEag7UrmPb/NDso7ISbagPYNjDYb8YyLayQBTNZAVvFnwfvEd//s+1/B28LRwLFr91FAAAA~~
303		~~AElFTkSuQmCC~~
304		~~</value>~~
305		~~</data>~~
306		~~<data name="stareProwizjeToolStripButton.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">~~
307		~~<value>~~
308		~~iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8~~
309		~~YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAgxJREFUOE+lkvtL~~
310		~~U2EYx+0PEbtpFwnBKPGKiJImGP0gYhIYs1E5GF5gIxkpA00JRSmMEF0ohMh+GaRWYlqabMVcNdS2QpaI~~
311		~~VqiDIYhk397vA6fXhCjyhYdzeM/5fp7vczkAdeL2cwho7v/wWzT1zcN+Pwhr51uY2/y41PQaF+wzKKiZ~~
312		~~QvaN58g0jyLd5KEUcQbg+84P/Cm2tncQjW3j68YWIqubCC3FcOJc478BAuGoZM6zvoRnakXEruEIjhc4~~
313		~~/g5gZop9c+voGAyLbQIfeBZxLL9BA1jzXvuGbWamuKh+GmmVbswE19A59FEBbmoAG7YbsLtm2mZmiml9~~
314		~~cvabNDwpz6YB7LYBoMXCumkJr7LOmnnHzBQ/9X2Bo2cOibm1GsBREbAQiYmw/8lnuCeWkVzcgnZlnw1j~~
315		~~3HV/wuNXK6i/9x5Hc6wawDlTXHbLJ+LZUBQPRyKwdQdxutwl1h+NLXHh5Ht1ewBHsiwawCW57HyDAfWR~~
316		~~dvl0uhZQ1eqX8aVc7EKLqrum651ATLf9OJx5XQM4KmY0xPzZ0hFAiQJnXB0WwME0E3IsL5B17ZlADqWb~~
317		~~NYDrOepdlcysmTWWOrxqbceRWtaLk0VO1XW72D5Vckd2gMBfq8zdpmUG62NJvKM4+XyziDk24xmfWoGE~~
318		~~s1c0gHPmbrPTpHNJKOCo2G1mZs20zcwUJ5yp1AB5+8/zEwgF5GMVDxh4AAAAAElFTkSuQmCC~~
319		~~</value>~~
320		~~</data>~~
321	287	<data name="zapiszToolStripButton.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
322	288	<value>
…	…
351	317	</value>
352	318	</data>
353		~~<data name="przeliczStripButton.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">~~
354		~~<value>~~
355		~~iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8~~
356		~~YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAgxJREFUOE+lkvtL~~
357		~~U2EYx+0PEbtpFwnBKPGKiJImGP0gYhIYs1E5GF5gIxkpA00JRSmMEF0ohMh+GaRWYlqabMVcNdS2QpaI~~
358		~~VqiDIYhk397vA6fXhCjyhYdzeM/5fp7vczkAdeL2cwho7v/wWzT1zcN+Pwhr51uY2/y41PQaF+wzKKiZ~~
359		~~QvaN58g0jyLd5KEUcQbg+84P/Cm2tncQjW3j68YWIqubCC3FcOJc478BAuGoZM6zvoRnakXEruEIjhc4~~
360		~~/g5gZop9c+voGAyLbQIfeBZxLL9BA1jzXvuGbWamuKh+GmmVbswE19A59FEBbmoAG7YbsLtm2mZmiml9~~
361		~~cvabNDwpz6YB7LYBoMXCumkJr7LOmnnHzBQ/9X2Bo2cOibm1GsBREbAQiYmw/8lnuCeWkVzcgnZlnw1j~~
362		~~3HV/wuNXK6i/9x5Hc6wawDlTXHbLJ+LZUBQPRyKwdQdxutwl1h+NLXHh5Ht1ewBHsiwawCW57HyDAfWR~~
363		~~dvl0uhZQ1eqX8aVc7EKLqrum651ATLf9OJx5XQM4KmY0xPzZ0hFAiQJnXB0WwME0E3IsL5B17ZlADqWb~~
364		~~NYDrOepdlcysmTWWOrxqbceRWtaLk0VO1XW72D5Vckd2gMBfq8zdpmUG62NJvKM4+XyziDk24xmfWoGE~~
365		~~s1c0gHPmbrPTpHNJKOCo2G1mZs20zcwUJ5yp1AB5+8/zEwgF5GMVDxh4AAAAAElFTkSuQmCC~~
366		~~</value>~~
367		~~</data>~~
368	319	<data name="naniesNaReklamyToolStripButton.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
369	320	<value>
370	321	iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
371		YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABv1JREFUSEt1lglQ
372		~~k3caxr+AdltnRbeObXeqU9fd1qnjTtc6bHc9lu1eMrsVC1VaWOtKi5yCSqEuSKWKXCothykISUQQwxFC~~
373		~~uAI55JAAQsCCiVxyRYwaFBIg4Yw8+35ZYex095t55p/5Jnl+//d983++j8PQdf78xfes1ql1Vuv86oUF~~
374		~~ziqGsXeg1cFq5awC4GBvv9zBzu6FlbSusrNb7jA//5NV09PjD4xGo9xiMcpVqqqGe/c0k2T1lATW8wdX~~
375		~~UlK6IStLhKamTvT16dDfP0yrgdbHGBgw0WcT7tx5gvb2R2hufoCGhmHU1upQVNSOlBQZTpzIMR45whV7~~
376		~~ecX579zpv5HMXyBxliA8Xo5hbGwWnZ3j6OgAurut0OkmMTRkRE/PGDSaUXz/vRFq9RhaWkyorx+FXP4Q~~
377		E~~skQcnM7kZHRithYGUJCsuHtfXGEjDeTXloCXLrEM8zMLGB8fAqjo2YyNiMxUbnAmjU1jUCluk87HoRC~~
378		~~0Y2KinaIRDeRk1ONzMwKpKYW03cLEBeXj7NnhfD15RrJ+Bhp/SKAwwKo17BY5mAyTWFkZJJa8pRaoSbj~~
379		~~G7TbOjKuRnGxEgUFMly9WgmBoBzp6SUEEBNAZANERwtx+HAqC0gg/WoJkJjEM0zMEeHpU0yOT+PxYxaw~~
380		~~gJoaNZTKelRW1qG8vIZ6rkRengzZ2VLw+eVISyuhGYhx4UIhtSiPKsiDj48NcO4ZwDYHTnQMz7Dvmhn~~p
381		~~KiNmzTMYH5tEV9cC7bwJUmkdyspqaPfXafdyXMutQnZWBQS8MmSkScBNLkLSuXxciBUi7nQufA6nsIDz~~
382		~~pDcXB81JpwoUXTN4J34IW6LvokI9An0fUC1TQSmthrxcCVmJAtKiShQJpcjglSPmohQhiZU4FCfH3mgl~~
383		~~nKKqseVkAy4Iqi2cbYEZZP4OaZmtghiqYNRkheHRBJyT74LxaManAj12x7Tg1+E38XpIC1b4q8F43wJz~~
384		~~uB1MgBbM0TtgQrvBnOwB8xX95qteeEseIvny4Dzj0WYh332kl22A8LM8w78KLahofQLrqAl82TDeOt1F~~
385		~~ZmqsPtKCjSE3sTVchfdP3cCHZ2twIF4J/4QqhCWU4VS8CAkxQuQJKlHZoMOLXo1gPmmdIN8o0i9sgESq~~
386		~~4IrKhC3x9+CTpaP2jGBAM4syGmhJbhmKc0ohFclRIBBDmFmEbG4hBEn5SD2Xh1PRBfCPEqPkxl285t8~~A
387		~~5p911AHF4PP/JE74GZ6ht9cEWaMeP/+yE2tCOpCvGEX8d0ocPS9HcIoK35b0I+xqJ94IbcTK421gQm5T~~
388		~~i6jKiF5EXR+FYxS175NqrPiUAC+9mkOAsMWzwAkL5xl8SmcgrddD2zaMd09r8HI49diL+n2oHZ/xdXA+~~
389		~~04aTogdIUujxTZUOafIBXFb0oriuDyeu0Cw+kmO5Rz38IjLnyDiTtJv0U1uLThMgqXIEjt/ex5m8AfSq~~
390		~~h5Am0sM/RoqT8RJbRq3zlGDZnhIcCIzF8eMhOBp8zKZ9vtGw+1AKxlWBnV6pdLolU+SZQtpCsv/vkAnQ~~
391		~~otLhYlEfVp/owh9j70B1/SHSE/PBPXcNzY1a/MYzHczuImzwkkEzaEK/wQzNsBkbfarB7KnA9i9qsNf9~~
392		~~AAGqWMA3pE1L5yAsjGeQyQYgl3bjiqgLy/xv4e2YXrwSdJP+Sa2ILH4I36AwvHe0FszfRPgovgNDFI7e~~
393		~~3E4wzsV41VOB2mYtPvY8SIDSRcBbiwAmKOjSPYmkG2JxFyRiLUSFGvwhtgsbAmuxNVgBgbQHgUHH0Dk4~~
394		~~gTWuEnD+WoDIzA7Y/6UYds5lSBOq8OTJONz3exBA/GOAi8uxf/j6phlzc29T/GpwNbsdpdSuryOyEfnl~~
395		~~ZSiq2hAQcITS1oIc+X1w3s8D45QL5k8FcIuQUziOYYzixc3NnQCZPwaw09669e8HAgJSHvP5t8DjtRKo~~
396		~~h4Z5GcHBfErSVvj5BVLaztjkGtkEZlcOXqNqbmvvwmyeJrgZLi5uzwOWsogdtB17rDdv/rPnwYPJj9LT~~
397		~~WyiSuxEYyCPjDJSWqulB4oupqRlMT8+hf3gCK2kWyVn1dG/Wdn9y0oIPPnABl5v1iLzYsFuKaxawCPnZ~~
398		~~pk2/3+fhEXWfz2+n6M2AlxeXYroRhw59TkbTmJubR1WVbCEqQbig1Wqtg4OD83q9fs5gMMw6OTmNk1Eh~~
399		~~6QvSukXj51c2v1evX//2XlfX493OzgG927e71fr5hSpDQyP63d0/nty/f/+Eq6vr+K5du4ZY7dixY8jR~~
400		~~0XFo27Ztg2vXrhXS72NJvyW9+L8AtnNBojcL5nekYFLksx2xu/qaxD5M2Bawawwp+pnO0Ppv0h7Smv9n~~
401		~~vnifhawgvU7a8KxctmQ2HdnesgNk11+S2LeIRb1Bn9mItj0H2Os/QPDHP2+nQNIAAAAASUVORK5CYII=~~
	322	YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABv5JREFUSEt1lglQ
	323	lPcZxr8FTROnoo1jk050Ym0TJ46d1Do0rUdpesm0EQNREqix0iKnoBKIBYkbRQ4PEg43rLC7IrhyLbBc
	324	C3vIIQsICwYEuQR2V0RdFHYXWM6Vp++3dRkzab+ZZ/4738z3/P7v+37/51sOQ9eFC5fes1qn11mtC6sX
	325	FzmrGMbRiVYnq5WzCoCTo+NyJweHl1bSusrBYbnTwsIPVs3MmB8ajUaFxWJUqNVVDffvd06S1TMSWM/v
	326	XElJfENmpgRNTd0YGNBjcHCYVgOtTzA0ZKLfJty9+xTt7Y/R3PwQDQ3DqK3Vo7CwHSkpcpw4kW08coRX
	327	5OMTH7hzZ+BGMn+JxFmCCATZhvHxOXR3m9HRAfT2WqHXT0KnM6KvbxydnWP49lsjNJpxtLSYUF8/BoXi
	328	EaRSHcTibqSntyIuTo6wsCz4+l4aJePNpFeWAJcvCwyzs4swm6cxNjZFxlPgcnMXWbOmplGo1Q9ox1oo
	329	lb2oqGiHRHIL2dnVyMioQGpqMRIT8xEfn4ezZ3Pg788zkvEx0no7gMMCqNewWOZhMk1jdHSSWvKMWqEh
	330	45u02zoyrkZxsQr5+XJcu1YJkagcfH4JAYoIILEBYmJycPhwKgs4R/r5EiAxSWCYmCfCs2eYNM/gyRMW
	331	sIiaGg1UqnpUVtahvLyGeq5Cbq4cWVkyCIXlSEsroRkU4eLFAmpRLlWQCz8/G+D8c4BtDpyYWIFh3/Up
	332	8NVGzE3Nwjw+iZ6eRdp5E2SyOpSV1dDub9DuFbgurkJWZgVEgjKkp0nBSy5E0vk8XIzLQfxpMfwOp7CA
	333	C6S37IPm8KkCZc8s3k3QYUvMPVRoRjEyAFTL1VDJqqEoV0FeooSssBKFOTKkC8oRe0mGsMRKHIpXYG+M
	334	Ci7camw52YCLomoLZ1twOpm/S1pmqyCWKhgzWWF4PAHX5HtgvJrxqWgEu2Nb8IvIW3gjrAUrAjVgfG+D
	335	OdwOJqgLzNG7YMJ7wZzsA/MFPfNFP3ylj5B8RbvAeLVZyHcf6VUbIPKswPCPAgsqWp/COmaCUD6Mt0/3
	336	kJkGq4+0YGPYLWyNVOP9Uzfx4dkaHEhQIfBcFSLOleFUggTnYnOQK6pEZYMeL/s0gvmkdYJ8uaSf2gCJ
	337	VMFVtQlbEu7DL1NP7RnFUOccymigJeIyFGeXQiZRIF9UhJyMQmTxCiBKykPq+VycislHILcIJTfv4fXA
	338	BjB/r6MOKLUvvkmcyDMCQ3+/CfLGEfzk826sCetAnnIMCd+ocPSCAqEpanxdMoiIa914M7wRK4+3gQm7
	339	Qy2iKqP6wb0xBmcute+Taqz4lACvvJZNgAj7WeBERAoMfqWzkNWPoKttGL863YlXI6nHPtTvQ+34p1AP
	340	1zNtOCl5iCTlCL6q0iNNMYQryn4U1w3gxFWaxUcKLPeqR0BUxjwZZ5B2k35oa9FpAiRVjsL56wc4kzuE
	341	fo0OaZIRBMbKcDJBasuodd5SLNtTggPBcTh+PAxHQ4/ZtM8/Bg4fysC4K7HTJ5VOt3SaPFNIW0iO/x0y
	342	AVrUelwqHMDqEz34fdxdqG88Aj8xD7zz19Hc2IVfevPB7C7EBh85OrUmDBqm0Dk8hY1+1WD2VGD7ZzXY
	343	63mAAFUs4CvSpqVzEBEhMMjlQ1DIenFV0oNlgbfxTmw/fhxyi96kVkQXP4J/SATeO1oL5i8SfJTQAR2F
	344	oy+vG4xrMV7zVqK2uQsfex8kQKkd8LYdwISEXL4vlfaiqKgH0qIuSAo68bu4HmwIrsXWUCVEsj4EhxxD
	345	t3YCa9yl4Pw5H9EZHXD8UzEcXMuQlqPG06dmeO73IkDR9wFubsf+5u+fZhSL71D8duJaVjtKqV1fRmUh
	346	+vMrUFa1ISjoCKWtBdmKB+C8nwvGRQzmD/nwiFJQOI5jnOLFw8OTABnfB7DT3rr1rweCglKeCIW3IRC0
	347	EqiPhnkFoaFCStJWBAQEU9rO2uQe3QRmVzZep2rudN3D1NQMwafg5ubxImApi9hBO7DHevPmP3ofPJj8
	348	mM9voUjuRXCwgIzTUVqqoQ+JP6anZzEzM4/B4QmspFkkZ9bTvTnb/clJCz74wA08XuZj8mLDbimuWYAd
	349	8qNNm367z8uL+0AobKfoTYePD49iuhGHDv2LjGYwP79AcPEil5u62NXVZdVqtQsjIyPzBoNhzsXFxUxG
	350	BaTPSOvsxi+ubH6vXr/+nb3u7sd7XV2D+rdv96gNCAhXhYdHDXp6fjy5f//+CXd3d/OuXbt0rHbs2KFz
	351	dnbWbdu2Tbt27docej6O9GvSy/8LYDsXJPpnwfyGFEqKfr4jdldfktiPCdsCdo0lxTzXGVr/TdpDWvP/
	352	zO33WcgK0hukDc/LZUtm05HtLTtAdv0Zif0XYdeb9JuNaNt3gL3+A1LoxrVgm6UXAAAAAElFTkSuQmCC
402	353	</value>
403	354	</data>
…	…
405	356	<value>
406	357	iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
407		YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABY1JREFUSEuVVXtM
408		U~~2ccLZubGFnmBo5FSJZt0cnQmEU3BlmmfxBHeAg6mCI61G0ZD3WgKKjIQ+URxfEyghoQ5CkI8irUldIC~~
409		~~g3RIZYiwWl7yaIGWWoqAIJOz33fXbCYqGzc5ube9veec3/m+nmvEe/lhNM89zHPvxbfy8vK2nTsXezAm~~
410		~~JiYs6syp86cjItLOnI4sjD4d/Uvc+ThpYnKyPCkpqYWetiAsXrBAenp6zeDwKAbUDzGom4RqYg6qaWBg~~
411		~~Buh6DCjoOvFq3tzq1asDifw9wisLEklMTIxSavUY/xNQE5lqEuh7RMRjQPtDoE0HCNv64bB581UitiMY~~
412		~~L0ggMjLSteF2K3RP/iYfmAB6x4FOPSAnkXsk0EafDx3wbSTiHQTTBQm4uLiY3ygpe6IhASUJMDSPPEWF~~
413		~~Ygbpv0/ibIMex2vG4Br/62OrI0U3VgWX+Z+LPGlzIT7+y7179y4nsUWE+TYGbxHFJNPMAXdGgSDhNEKE~~
414		~~jxApfoSAKj1+4o/hYMUY9hN+LNXCMVOF3SkNkDVIkJOTMxkaGhpvamq6gkRee+FkjY2N9pmZmYpb1WJU~~
415		~~3apGhUSKC3VDOMDXIaVpGsdJ7FAlCZQ/hA8JfF+ihW1KP67Vd2NE2Y/a2locPnyYT+SrnttlMpnMRSwW~~
416		~~z3R3dz+dmJiAdlSDIeUgRpUPUC57ALccFc43TCGwUge/Mi1+uKmB940R7CocwcexcvTI7+L+/fsoL6+A~~
417		~~m5tbPAl8YIiMx6NYFgsEgoHZ2VmMj49Dq9VCo9Ggr68PcrkcfZ1/ILVajh3XhxEm0pP7UewrVmN34TC8~~
418		~~CoaxIbkXFypaUZxzCSJBCUJCQrTGxsb/boKsrKxvOjo6MDU1BZ1Oh9HRUQwPD2NoaAjt7e1oaWmB4q4M~~
419		~~HukdOHZLRwIa7CH3XiToka+CU+YgtiTfQ1Pat5it2IaM7EKsXbs2iSZYw02Rmpqaxlzr9XqOXK1Wc+QD~~
420		~~AwOgyCCVSnH7NymEtVLYXexDkECLXeR8O5G75yjhSvGtOdUKaVU2psv3oVrSiE2bNlUSuTPhTd7ly5dv~~
421		~~s9xZLCMjIxz54OAgFxEDLT7q6+sha6yDZ+od+JSosZPcb7+uwte5Kmy80o9PIpvQIBFBWFMPsaQWnp6e~~
422		~~bUTuQ3iXl52drRobG+NiUalUHHl/fz96e3vR09ODpqYmiEQiiEXVKBfU4MOYbnxxaRDrEnqx/KQCnxN5~~
423		~~lVAEQSUfxAWJRAJ/f/8RIj/BVUpKSoqOuWfRKJVKzjUjZ/F0dnaiubkZVVVVHISCSly7KURoRi3O5tWi~~
424		~~vIKPrLSLOH4sGI6OjrC3t0dQUBCcnZ2lRB5BeJ8XHBwcFhcXh4KCAnR1dXETMOcKhYLbeq2trSgtLUVZ~~
425		~~WRkqySVzmn7lEsJOHIOb6xbY2Nhg5cqVsLa2hoODA3MPExOTDCLfT1jBCwgIsM/NzQWfz0dsbCxoIo6U~~
426		~~ibBtyq6Li4s5geTkZHh4eMDW1hbUqrCysmILCm9vb865r69v7/r1668bGRn9TOQbCUt55ubmS318fI7Q~~
427		~~e+ABI2IIDw9HdHQ06urquCmKiopYHbA/EUfMXNNC4ujRo/Dz85txd3cXW1hYsJZNJYQT3LgFNlQ663Xz~~
428		~~JUuWbHFyckolIXV+fj7oBQSKD9QxCAwM5EYnIlYHiIqKYsR9JFRAz6XT88zxAcJmwkeEt//5J9MFO1gT~~
429		~~vkWwXrZsmdfWrVszSEhP3cRim6OJ5hISEthkT7y8vCSWlpYZFMMVw0LupPOnBEuCCeFVA+dzJ1a1rAnN~~
430		C~~OvMzMy+I6GCiIgIPa1Tl52dXaHBLeuag4SvDG7Z79krdN6qflaN/fB1FhthA2GPwSnb18ztZwa3bxgm~~
431		~~f5nh//yeCTFn7xBYO7L38ILd/qeKYXQm9r8jeJb0Lz9T1mfj3EQKAAAAAElFTkSuQmCC~~
	358	YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABY5JREFUSEuVVXtM
	359	U1ccLpubGFnmBo5FSJZt0cnQmEU3BlmmfxBHeAg6mCI61G0ZD3WgKKjIQ+URwfGoEdTAQJ6CIK9CHZQW
	360	GKQgyBBhyFOgLbSlliIgyOTb79w1m4nKxk2+3NPee77v+/3Oud8x4L38MljgGRZ49uJHOTk5O2Jiog9H
	361	RUWFRJw7c+FsWFjKubPh+ZFnI3+NvRArTeDzuxITE1tpthlh6aIFUlNTq2WjYxhWPYRMOwXF5DwUM8Dw
	362	LND7GOimcWgMf37t2rX+RP4e4ZVFiSQkJETINTpM/AmoiEwxBQw+IuJxoOMh0K4FKtuHYLd16y9EbEMw
	363	XJRAeHi4c/3tNmif/E0+PAkMTAA9OqCLRO6RQDv9PnLIu4GIdxGMFyXg5ORkeqOo5ImaBOQkwNCsfIqy
	364	7lmk/j6F8/U6nKweh3Pcb48tjhXcWBNY4hsTftrqYlzcl/v3719JYksIC20M3hJqU4t6HrgzBgRUziCo
	365	8hHCxY/gV6HDT4JxHC4bx0HCj8Ua2KcrsDepHi31EmRlZU0FBwfHGRsbryKR115YWUNDg216enr3rSox
	366	Km5VoUwixcXaERwSaJHUNIOTJHaknARKH8KLBL4v0sA6aQjX6vqglA+hpqYGR48eFRD5mud2WUtLi5NY
	367	LJ5tbGx8Ojk5Cc2YGiNyGcbkD1Da8gAuWQpcqJ+Gf7kWPiUa/HBTDc8bSuzJV+Lj6C70d93F/fv3UVpa
	368	BhcXlzgS+EDfMh6P2rJUKBQOz83NYWJiAhqNBmq1GoODg+jq6sJgzx9IrurCruujCBHpyP0YDhSqsDd/
	369	FB55o9jEH8DFsjYUZl2GSFiEoKAgjaGh4b+bICMj45vOzk5MT09Dq9VibGwMo6OjGBkZQUdHB1pbW9F9
	370	twVuqZ04cUtLAmrsI/ceJOiWq4BDugzb+PfQlPIt5sp2IC0zH+vXr0+kCtZxVSQnJ6cw1zqdjiNXqVQc
	371	+fDwMPr6+iCVSnG7UYrKGilsLg0iQKjBHnK+k8hds+RwpvatO9MGaUUmZkoPoErSgC1btpQTuSPhTd6V
	372	K1dus76ztiiVSo5cJpNxLWKgxUddXR1aGmrhnnwHXkUq7Cb3O68r8HW2ApuvDuGT8CbUS0SorK6DWFID
	373	d3f3diL3IrzLy8zMVIyPj3NtUSgUHPnQ0BAGBgbQ39+PpqYmiEQiiEVVKBVW48OoPnxxWYYN8QNYebob
	374	nxN5RaUIwnIBiAsSiQS+vr5KIj/FRUpSUpKWuWetkcvlnGtGztrT09OD5uZmVFRUcKgUluPazUoEp9Xg
	375	fE4NSssEyEi5hJMnAmFvbw9bW1sEBATA0dFRSuRhhPd5gYGBIbGxscjLy0Nvby9XAXPe3d3Nbb22tjYU
	376	FxejpKQE5eSSOU29ehkhp07AxXkbrKyssHr1alhaWsLOzo65h5GRURqRHySs4vn5+dlmZ2dDIBAgOjoa
	377	VBFHykTYNmXjwsJCToDP58PNzQ3W1tagVIWFhQVbUHh6enLOvb29BzZu3HjdwMDgZyLfTFjOMzU1Xe7l
	378	5XWMzoEHjIghNDQUkZGRqK2t5aooKChgccA+Io6YuaaFxPHjx+Hj4zPr6uoqNjMzYymbTAgluHALrI90
	379	luumy5Yt2+bg4JBMQqrc3FzQAQRqHyhj4O/vz5VORCwOEBERwYgHSSiP5qXSfOb4EGEr4SPC2/98yTRg
	380	F0vCtwiWK1as8Ni+fXsaCekom1g18wzx8fFs/MTDw0Nibm6eRm24ql/I3XT/lGBOMCK8qud87sailiWh
	381	CWGDiYnJdySUFxYWpqN16rWxscnXu2VZc5jwld4te58doQtG9bNq7MXXWdsImwj79E7ZvmZuP9O7fUNf
	382	+csM/+f/TIg5e4fA0pGdw4t2+58q+tKZ2P9uwbOkfwHOANXWFh5yiAAAAABJRU5ErkJggg==
432	383	</value>
433	384	</data>
…	…
469	420	</value>
470	421	</data>
471		~~<data name="wyczyscToolStripButton.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">~~
472		~~<value>~~
473		~~iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8~~
474		~~YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAktJREFUSEvtlN9P~~
475		~~zXEYx58zOrXUDA1RSmudWYYboTIm86MSpR+0KMuPkgwzopg10rBYrLopO9GYGZs7d1zRX2BuuPRrVDvs~~
476		~~XL68v31PdNf3NBcu+m6vne2c5/t+P8/785yP2czzvyfgU4NeiG6OL1nWMrbCRkezLfQ9zUIfI7xPtdDw~~
477		~~Egu9XWSh1/EWehlrP/ri7aLU54vZnl3GAjZCsBGGmlwGjsDdg3C9ClqLoDkf6lbCnlQextgnCRdHTLx5~~
478		~~jKhjHjVD8JhL/2G4UwPXyuB8ITTlwoFsKF3GA799lWqrSPOmrqpv4wYn/hoMRAyuyuCCDI5rghpNsPeP~~
479		~~Qadey/Rq4HMyJ9gA9xWNQ18d3NoP7aVwbgc0rodqZ4KUiQkmDJyFmPLxfXAMeiV6T7l3K5quaugoh7Zd~~
480		~~cHoL1K+FyiwoSSboRhSdwbsUGdzUgTqiHRXqXNFcKoGz26Bhg/Jfpe7TYXsSA9MxGF4sg8u7tTHFLi07~~
481		~~4UyBss+DQ6uhIhMKk6Egkd6YaUzwRjvOqc1wcpPYqK3RoR7NgVqJVyma4qUSnwd5fnpmTcPglWNQLzFH~~
482		~~sHaNuzH7AlC2HIoi4rmxkGN0+6I3sBdxNkqVxCozXMrTlLmEixaq87mQ7x8XZ51xw+zzpEOecoPGC/rn~~
483		~~WOdQgv16nmhhh2cJFn4qnsT7wkNxFh70W/h2jIV7fPZzq9ljvdIm0r2pu1ULRJloF11TcEW/l0R1VajY~~
484		~~ubiSRIbIihDQ52QmvndqnIa8X3aTRvVyVXv690YT30ztv03gNz/zY6SMcWgzAAAAAElFTkSuQmCC~~
485		~~</value>~~
486		~~</data>~~
487	422	<metadata name="agencjeTableAdapter1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
488		<value>~~17, 95~~</value>
	423	<value>900, 17</value>
489	424	</metadata>
490	425	<metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

branches/ReklamaReorganizacja/BazaReklam/ReportsForm.cs

r657	r680
102	102	stareRaportyTreeView.Nodes["Pozosta³e"].Nodes.Add(node);
103	103
104		if (User.Instance().~~St_handlowiec \| User.Instance().St_subhandlowiec \| User.Instance().St_kierownik \| User.Instance().St_s~~ekretarka)
	104	if (User.Instance().IsHandlowiec \| User.Instance().IsKierownik \| User.Instance().IsSekretarka)
105	105	{
106	106	node = new TreeNode();
…	…
160	160	}
161	161
162		if (User.Instance().~~St_handlowiec \| User.Instance().St_subhandlowiec \| User.Instance().St_k~~ierownik)
	162	if (User.Instance().IsHandlowiec \| User.Instance().IsKierownik)
163	163	{
164	164	node = new TreeNode();
…	…
178	178	}
179	179
180		if (User.Instance().~~St_k~~ierownik) {
	180	if (User.Instance().IsKierownik) {
181	181
182	182	node = new TreeNode();
…	…
365	365	{
366	366	case "s":
367		return User.Instance().~~St_kierownik \| User.Instance().St_handlowiec \| User.Instance().St_subhandlowiec \| User.Instance().St_s~~ekretarka;
	367	return User.Instance().IsKierownik \| User.Instance().IsHandlowiec \| User.Instance().IsSekretarka;
368	368	case "h":
369		return User.Instance().~~St_kierownik \| User.Instance().St_handlowiec \| User.Instance().St_subh~~andlowiec;
	369	return User.Instance().IsKierownik \| User.Instance().IsHandlowiec;
370	370	case "k":
371		return User.Instance().~~St_k~~ierownik;
	371	return User.Instance().IsKierownik;
372	372	case "a":
373		return User.Instance().~~St_a~~dmin;
	373	return User.Instance().IsAdmin;
374	374	default:
375	375	return false;
…	…
449	449	)
450	450	{
451		if (!User.Instance().~~St_k~~ierownik)
	451	if (!User.Instance().IsKierownik)
452	452	{
453		if (User.Instance().~~St_s~~ekretarka)
	453	if (User.Instance().IsSekretarka)
454	454	{
455	455	List<ReportParameter> paramList = new List<ReportParameter>();
…	…
457	457	reportViewer1.ServerReport.SetParameters(paramList);
458	458	}
459		else if (User.Instance().~~St_handlowiec \| User.Instance().St_subh~~andlowiec)
	459	else if (User.Instance().IsHandlowiec)
460	460	{
461	461	List<ReportParameter> paramList = new List<ReportParameter>();
…	…
477	477	reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/OcenaAgenta")
478	478	{
479		if (!User.Instance().~~St_k~~ierownik)
	479	if (!User.Instance().IsKierownik)
480	480	{
481	481	List<ReportParameter> paramList = new List<ReportParameter>();
…	…
487	487	if (reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/WynikAgenta")
488	488	{
489		if (!User.Instance().~~St_k~~ierownik)
	489	if (!User.Instance().IsKierownik)
490	490	{
491	491	List<ReportParameter> paramList = new List<ReportParameter>();

branches/ReklamaReorganizacja/BazaReklam/StartForm.cs

r601	r680
32	32	kontaktTypTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;
33	33
34		if (User.Instance().~~St_k~~ierownik)
	34	if (User.Instance().IsKierownik)
35	35	{
36	36	wynikAgencji();
37	37	}
38		else if (User.Instance().~~St_handlowiec \| User.Instance().St_subh~~andlowiec)
	38	else if (User.Instance().IsHandlowiec)
39	39	{
40	40	wynikAgenta();
…	…
84	84	SqlDataReader reader;
85	85
86		if (User.Instance().~~St_k~~ierownik)
	86	if (User.Instance().IsKierownik)
87	87	{
88	88	command.CommandText = "select Symbol from dbo.AGENCI where aktywny=1 and ID_AGENCJI=@param order by Symbol";
…	…
432	432	// MessageBox.Show("ddd");
433	433
434		if (User.Instance().~~St_k~~ierownik)
	434	if (User.Instance().IsKierownik)
435	435	{
436	436	agencjaToolStripComboBox.Text = User.Instance().SymbolAgencji;
437	437	}
438		else if (User.Instance().~~St_handlowiec \| User.Instance().St_subh~~andlowiec)
	438	else if (User.Instance().IsHandlowiec)
439	439	{
440	440	agentToolStripComboBox.Text = User.Instance().Login;
…	…
452	452	{
453	453
454		if (User.Instance().~~St_k~~ierownik)
	454	if (User.Instance().IsKierownik)
455	455	{
456	456	shedulerTableAdapter.FillByAgencjaWgDaty(rEKLAMADataSet.sheduler, User.Instance().IdAgencji);
…	…
463	463	if (pierwszaAktywacja) return;
464	464
465		if (User.Instance().~~St_k~~ierownik)
	465	if (User.Instance().IsKierownik)
466	466	{
467	467	wynikAgencji();
468	468	}
469		else if (User.Instance().~~St_handlowiec \| User.Instance().St_subh~~andlowiec)
	469	else if (User.Instance().IsHandlowiec)
470	470	{
471	471	wynikAgenta();

branches/ReklamaReorganizacja/BazaReklam/ZamowieniaForm.cs

r665	r680
96	96	private void ZamowieniaForm_Load(object sender, EventArgs e)
97	97	{
98		usunFaktureButton.Enabled = User.Instance().~~St_k~~ierownik;
99		dtpZmianaDaty.Enabled = User.Instance().~~St_k~~ierownik;
	98	usunFaktureButton.Enabled = User.Instance().IsKierownik;
	99	dtpZmianaDaty.Enabled = User.Instance().IsKierownik;
100	100	dtpZmianaDaty.Value = DateTime.Today;
101	101	dtpZmianaDaty.MaxDate = DateTime.Today;
…	…
648	648	naglowekFaktury.DATA_WYSTAWIENIA = DateTime.Today;
649	649
650		if (User.Instance().~~St_k~~ierownik)
	650	if (User.Instance().IsKierownik)
651	651	{
652	652	if (dtpZmianaDaty.Value != DateTime.Today)

branches/ReklamaReorganizacja/BazaReklam/ZestawienieZamowienForm.cs

r645	r680
191	191	rokToolStripTextBox.Text = DateTime.Today.Year.ToString();
192	192
193		if (User.Instance().~~St_k~~ierownik)
	193	if (User.Instance().IsKierownik)
194	194	{
195	195	agencjaToolStripComboBox.Text = User.Instance().SymbolAgencji;
196	196	}
197		else if (User.Instance().~~St_handlowiec \| User.Instance().St_subh~~andlowiec)
	197	else if (User.Instance().IsHandlowiec)
198	198	{
199	199	kodRozliczeniowyToolStripTextBox.Text = User.Instance().Kod_agenta;

branches/ReklamaReorganizacja/BazaReklamSetup/BazaReklamSetup.vdproj

r665	r680
725	725	"Name" = "8:Microsoft Visual Studio"
726	726	"ProductName" = "8:Baza Reklam"
727		"ProductCode" = "8:{B~~9DCA616-E7C3-45ED-AAEB-9C0D463A7D20~~}"
728		"PackageCode" = "8:{~~A117DAEB-B2BA-4751-8496-660834D728D6~~}"
	727	"ProductCode" = "8:{B8393EA3-0643-4C96-A5D4-49FFB974873B}"
	728	"PackageCode" = "8:{ECC79476-2F79-49E5-8252-8DDDD07AABD7}"
729	729	"UpgradeCode" = "8:{4E2DBBA4-3139-4790-8DDB-7AADFC963A7D}"
730	730	"RestartWWWService" = "11:FALSE"
…	…
732	732	"DetectNewerInstalledVersion" = "11:TRUE"
733	733	"InstallAllUsers" = "11:TRUE"
734		"ProductVersion" = "8:1.1.13"
	734	"ProductVersion" = "8:1.1.14"
735	735	"Manufacturer" = "8:AACT"
736	736	"ARPHELPTELEPHONE" = "8:"

branches/ReklamaReorganizacja/SQL/StoredProcedures/PROC_WYLICZ_I_ZAPISZ_DANE_O_KONTAKTACH_I_BUDZECIE.txt

r473	r680
9	9	@MS INTEGER = 2
10	10	As
11		~~update dbo.PLAN_TYLKO_CT set~~
12		~~w_budzet=wk_budzet,~~
13		~~w_spotkania=spotkanie,~~
14		~~w_tel=tel,~~
15		~~w_email=email,~~
16		~~w_list=list,~~
17		~~w_fax=fax,~~
18		~~w_n_klienci=nkl,~~
19		~~w_klienci=il_klientow,~~
20		~~w_reklamy=il_reklam~~
21		~~from~~
22		(
23		~~--WYLICZENIE ILOSCI KONTAKTOW ITP~~
24		~~SELECT ROK, MS, AGENT, IL_KONTKTOW, IL_KLIENTOW, SPOTKANIE, FAX, EMAIL, LIST, TEL ,~~
25		~~ISNULL(IL_REKLAM,0) AS IL_REKLAM, ROUND(ISNULL(BUDZET,0) ,0) AS wk_BUDZET, ISNULL(NKL,0) AS NKL, HANDEL, PRODUKT, RYNEK, FIRMA~~
26		~~FROM~~
27		(
28		~~SELECT ROK , MS, AGENT, COUNT(Id_kontaktu) AS IL_KONTKTOW, COUNT(DISTINCT customerId) AS IL_KLIENTOW,~~
29
30		~~SUM( CASE WHEN RODZAJ='TEL' THEN 1 ELSE 0 END) AS TEL,~~
31		~~SUM( CASE WHEN RODZAJ='FAX' THEN 1 ELSE 0 END) AS FAX,~~
32		~~SUM( CASE WHEN RODZAJ='LIST' THEN 1 ELSE 0 END) AS LIST,~~
33		~~SUM( CASE WHEN RODZAJ='E-MAIL' THEN 1 ELSE 0 END) AS EMAIL,~~
34		~~SUM( CASE WHEN RODZAJ='SPOTKANIE' THEN 1 ELSE 0 END) AS SPOTKANIE~~
35		~~FROM~~
36		(
37		~~SELECT dbo.KONTAKTY.Id_kontaktu, dbo.KONTAKTY.rodzaj as RODZAJ,~~
38		~~symbol_agenta AS AGENT, dbo.KONTAKTY.customerId,~~
39		~~DATEPART(YEAR, dbo.KONTAKTY.data) AS ROK,~~
40		~~DATEPART(Month, dbo.kontakty.data) As MS~~
41		~~FROM dbo.KONTAKTY~~
42		~~WHERE DATEPART(YEAR, dbo.KONTAKTY.data) = @ROK and DATEPART(Month, dbo.kontakty.data) = @MS~~
43		~~) KO~~
44		~~GROUP BY ROK, MS , AGENT~~
45		~~) P_K~~
46		~~--WYLICZENIE ILOSCI REKLAM~~
47		~~FULL OUTER JOIN~~
48		(
49		~~SELECT [SYMBOL AKWIZYTORA] AS R_AGENT, COUNT(*) AS IL_REKLAM_1,~~
50		~~DATEPART(YEAR,[DATA ZAMÓWIENIA]) AS R_ROK,~~
51		~~DATEPART(MONTH,[DATA ZAMÓWIENIA]) AS R_MS~~
52		~~FROM REKLAMA~~
53		~~WHERE~~
54		~~DATEPART(YEAR,[DATA ZAMÓWIENIA])=@ROK AND~~
55		~~DATEPART(MONTH,[DATA ZAMÓWIENIA])=@MS AND~~
56		~~[ZATWIERDZONO DO DRUKU]=1~~
57		~~GROUP BY [SYMBOL AKWIZYTORA] , DATEPART(YEAR,[DATA ZAMÓWIENIA]), DATEPART(MONTH,[DATA ZAMÓWIENIA])~~
58		~~) P_R~~
59		~~ON R_AGENT=AGENT AND ROK=R_ROK AND MS=R_MS~~
60		~~FULL OUTER JOIN~~
61		(
62		~~SELECT USERNAME, DATEPART(YEAR,DATA) AS K_ROK, DATEPART(MONTH,DATA) AS K_MS, COUNT(*) AS NKL FROM KLIENCI~~
63		~~WHERE DATEPART(YEAR,DATA)=@ROK AND DATEPART(MONTH,DATA)=@MS~~
64		~~GROUP BY USERNAME, DATEPART(YEAR,DATA), DATEPART(MONTH,DATA)~~
65		~~) AS P_NK~~
66		~~ON USERNAME=AGENT AND ROK=K_ROK AND MS=K_MS~~
67		~~--WYLICZENIE BUD¯ETU~~
68		~~FULL OUTER JOIN~~
69		(
70		~~SELECT B_ROK, B_MS,~~
71		~~Sum(NETTO) AS BUDZET,~~
72		~~count(LiczbaReklam) as IL_REKLAM,~~
73		~~b_agent as B_AGENT~~
74		~~FROM dbo.VIEW_POMOCNICZY_BUDZET~~
75		~~where B_ROK =@ROK and~~
76		~~B_MS =@MS~~
77		~~GROUP BY B_ROK, B_MS,B_AGENT ) P_B~~
78		~~ON B_AGENT=AGENT AND ROK=B_ROK AND MS=B_MS~~
79		~~-- WYLICZENIE DANYCH DO TESTU WIEDZY~~
80		~~FULL OUTER JOIN~~
81		(
82		~~SELECT user_name AS T_AGENT, DATEPART(YEAR,[DATA]) AS T_ROK, DATEPART(MONTH,[DATA]) AS T_MS,~~
83		~~SUM(HANDEL) AS HANDEL, SUM(PRODUKT) AS PRODUKT, SUM(RYNEK) AS RYNEK, SUM(FIRMA) AS FIRMA~~
84		~~FROM VIEW_ZESTAWIENIE_TEST_WIEDZY~~
85		~~WHERE~~
86		~~DATEPART(YEAR,[DATA])=@ROK AND~~
87		~~DATEPART(MONTH,[DATA])=@MS~~
88		~~GROUP BY user_name, DATEPART(YEAR,[DATA]) , DATEPART(MONTH,[DATA])~~
89		~~) P_T~~
90		~~ON T_AGENT=AGENT AND ROK=T_ROK AND MS=T_MS~~
91		~~) wl~~
92		~~--Koñcówka instrukcji Update~~
93		~~inner join dbo.[PLAN_TYLKO_CT] on wl.agent=[dbo].[PLAN_TYLKO_CT].symbol and wl.rok=[dbo].[PLAN_TYLKO_CT].rok and wl.ms=[dbo].[PLAN_TYLKO_CT].ms~~
94
95	11
96	12	update dbo.[PLAN] set

branches/ReklamaReorganizacja/SQL/StoredProcedures/PROC_WYLICZ_I_ZAPISZ_PROWIZJE.txt

r411	r680
5	5	GO
6	6
7		ALTER Procedure [dbo].[PROC_WYLICZ_I_ZAPISZ_PROWIZJE]
8		@ROK INTEGER = 2003,
9		@MS INTEGER = 2,
10		@idAgencji integer = 2
11		As
12		delete from PROWIZJE
13		where ROK =@ROK and MS =@MS and agencja =
14		(select symbol from agencje where id_Agencji = @idAgencji)
	7	ALTER PROCEDURE [dbo].[PROC_WYLICZ_I_ZAPISZ_PROWIZJE]
	8	@ROK INT = 2003,
	9	@MS INT = 2,
	10	@idAgencji INT = 2
	11	AS
15	12
16		insert into PROWIZJE
17		SELECT a2.symbol,b_agent, B_ROK,b_ms,numer_faktury,NETTO,NrKorygowanejFaktury,
18		case z.zp
19		when 1 then z.procentProwizji
20		else round(P.PR_PROWIZJI,2)
21		end,
22		z.zp,
23		case z.zp
24		when 1 then round(z.procentProwizji * Netto,2)
25		else round(round(P.PR_PROWIZJI,2) * Netto,2)
26		end
27		as kwotaProwizji, id_faktury
28		FROM dbo.VIEW_POMOCNICZY_BUDZET VPB left join dbo.[PLAN] P on
29		VPB.b_rok = P.rok and VPB.b_ms = P.ms and P.symbol = VPB.b_agent left join
30		zamowienia Z on Z.idZamowienia = VPB.idZamowienia left join
31		agenci A1 on A1.symbol = VPB.B_agent left join
32		agencje A2 on A2.id_agencji = A1.id_agencji
33		where B_ROK =@ROK and B_MS =@MS and A1.id_agencji = @idAgencji
34
35		-- aktualizuj prowizjie dla faktur z poprzednich miesiecy
36
37		DECLARE @Prowizje TABLE
38		(
39		idProwizji INT,
40		procentProwizji float,
41		kwotaProwizji money,
42		ZP bit
43		)
44
45		INSERT INTO @Prowizje
46		SELECT
47		Pr.idProwizji,
48		procentProwizji =
49		CASE
50		WHEN Z.ZP=1 THEN ROUND(Z.procentProwizji, 2)
51		ELSE ROUND(PL.Pr_Prowizji, 2)
52		END,
53		kwotaProwizji =
54		CASE
55		WHEN Z.ZP=1 THEN ROUND(Pr.Netto * Z.procentProwizji, 2)
56		ELSE ROUND(Pr.Netto * PL.Pr_Prowizji, 2)
57		END,
58		Z.ZP
59		FROM WplywyByTytul W
60		INNER JOIN Prowizje Pr ON Pr.idFaktury = W.ID_FAKTURY
61		INNER JOIN Agencje A ON A.Symbol = W.Agencja
62		INNER JOIN Faktury F ON F.ID_FAKTURY = W.ID_FAKTURY
63		INNER JOIN Zamowienia Z ON Z.idZamowienia = F.idZamowienia
64		LEFT OUTER JOIN [PLAN] Pl ON Pl.Symbol = W.Symbol AND Pl.Rok=YEAR(W.dataWplaty) AND Pl.MS=MONTH(W.dataWplaty)
65		WHERE YEAR(W.dataWplaty)=@ROK and MONTH(W.dataWplaty)=@MS
66		AND A.id_Agencji=@idAgencji
67		AND PR.ms<>@MS
68
69		UPDATE P
70		SET
71		P.procentProwizji=P1.procentProwizji,
72		P.kwotaProwizji=P1.kwotaProwizji,
73		P.ZP=P1.ZP
74		FROM Prowizje P INNER JOIN @Prowizje P1 ON P.idProwizji=P1.idProwizji
	13	-- wyczysc wszystko dla danej agencji
	14	DELETE FROM Prowizje
	15	WHERE Rok = @Rok
	16	AND Ms = @Ms
	17	AND Agencja = (SELECT symbol FROM Agencje where Id_Agencji = @idAgencji)
75	18
76	19
77		return
	20	INSERT INTO Prowizje
	21	SELECT
	22	W.Agencja,
	23	W.Symbol,
	24	YEAR(W.dataWplaty) AS Rok,
	25	Month(W.dataWplaty) AS Ms,
	26	W.NR_FK,
	27	W.Netto,
	28	NULL AS nrFakturyKorygowanej,
	29	procentProwizji =
	30	CASE
	31	WHEN Z.Zp = 1 THEN CAST(Z.procentProwizji AS decimal(9,2))
	32	ELSE COALESCE(CAST(P.Pr_Prowizji AS decimal(9,2)), 0)
	33	END,
	34	Z.Zp,
	35	W.ID_FAKTURY
	36	FROM WplywyByTytul AS W
	37	INNER JOIN Faktury AS F ON W.ID_FAKTURY = F.Id_Faktury
	38	INNER JOIN Zamowienia AS Z ON Z.idZamowienia = F.idZamowienia
	39	LEFT OUTER JOIN [Plan] AS P ON P.Rok=@rok AND P.Ms=@ms AND P.Symbol=W.Symbol
	40	WHERE (YEAR(W.dataWplaty) = @rok)
	41	AND (MONTH(W.dataWplaty) = @ms)
	42	--TODO: dodac pole typ faktury, ktory bedzie jednoznacznie okreslal jakie faktury nas interesuja...
	43	AND F.Numer_Roz<>'POZ' AND F.Numer_Roz<>'KAT'
	44	AND W.roznica_nowa<=60
	45	AND F.Id_Sprzedawcy=@idAgencji
	46	AND F.Korekta<>1
	47	ORDER BY Pr_Prowizji
	48
	49
	50	RETURN
78	51	GO
79	52

branches/ReklamaReorganizacja/SQL/Views/WplywyByTytul.txt

r535	r680
49	49	END,
50	50	T.Symb AS Tytul,
51		~~--COALESCE(FD.Wyroznienie , 0) AS Wyroznienie,~~
52	51	F.SystemKsiegowyId
53	52	FROM FAKTURY F
…	…
82	81	AGENCJE.Symbol,
83	82	KLIENCI.kodKlienta,
84		P.procentProwizji, ~~P.kwotaProwizji,~~
	83	P.procentProwizji,
85	84	R.[PROCENT PROWIZJI], R.PROWIZJA, R.zablokuj_prowizje,
86	85	Z.ZP, Z.procentProwizji,

branches/ReklamaReorganizacja/SQL/Views/WplywyByTytul_Wyroznienia.txt

r535	r680
83	83	AGENCJE.Symbol,
84	84	KLIENCI.kodKlienta,
85		P.procentProwizji, ~~P.kwotaProwizji,~~
	85	P.procentProwizji,
86	86	R.[PROCENT PROWIZJI], R.PROWIZJA, R.zablokuj_prowizje,
87	87	Z.ZP, Z.procentProwizji,

Nawigacja

Zbiór zmian 680 dla branches

Legenda:

branches/ReklamaReorganizacja/BazaReklam/AddZamowienieForm.cs

branches/ReklamaReorganizacja/BazaReklam/AdminForm.Designer.cs

branches/ReklamaReorganizacja/BazaReklam/AdminForm.resx

branches/ReklamaReorganizacja/BazaReklam/Baza Reklam.csproj

branches/ReklamaReorganizacja/BazaReklam/Classes/User.cs

branches/ReklamaReorganizacja/BazaReklam/ClientsForm.cs

branches/ReklamaReorganizacja/BazaReklam/Docs/versioninfo.html

branches/ReklamaReorganizacja/BazaReklam/FactureViewer.cs

branches/ReklamaReorganizacja/BazaReklam/Facturer.cs

branches/ReklamaReorganizacja/BazaReklam/FacturesForm.cs

branches/ReklamaReorganizacja/BazaReklam/FacturesFormNew.cs

branches/ReklamaReorganizacja/BazaReklam/InfoForm.cs

branches/ReklamaReorganizacja/BazaReklam/KorektyForm.cs

branches/ReklamaReorganizacja/BazaReklam/Logowanie.cs

branches/ReklamaReorganizacja/BazaReklam/MDIBazaReklam.cs

branches/ReklamaReorganizacja/BazaReklam/OrderDetails.cs

branches/ReklamaReorganizacja/BazaReklam/OrdersForm.cs

branches/ReklamaReorganizacja/BazaReklam/ProductionForm.cs

branches/ReklamaReorganizacja/BazaReklam/ProjectForm.cs

branches/ReklamaReorganizacja/BazaReklam/Properties/AssemblyInfo.cs

branches/ReklamaReorganizacja/BazaReklam/ProvisionForm.Designer.cs

branches/ReklamaReorganizacja/BazaReklam/ProvisionForm.cs

branches/ReklamaReorganizacja/BazaReklam/ProvisionForm.resx

branches/ReklamaReorganizacja/BazaReklam/ReportsForm.cs

branches/ReklamaReorganizacja/BazaReklam/StartForm.cs

branches/ReklamaReorganizacja/BazaReklam/ZamowieniaForm.cs

branches/ReklamaReorganizacja/BazaReklam/ZestawienieZamowienForm.cs

branches/ReklamaReorganizacja/BazaReklamSetup/BazaReklamSetup.vdproj

branches/ReklamaReorganizacja/SQL/StoredProcedures/PROC_WYLICZ_I_ZAPISZ_DANE_O_KONTAKTACH_I_BUDZECIE.txt

branches/ReklamaReorganizacja/SQL/StoredProcedures/PROC_WYLICZ_I_ZAPISZ_PROWIZJE.txt

branches/ReklamaReorganizacja/SQL/Views/WplywyByTytul.txt

branches/ReklamaReorganizacja/SQL/Views/WplywyByTytul_Wyroznienia.txt

Pobierz w innym formacie: