Nawigacja

← Previous Change
Next Change →

Zbiór zmian 486 dla trunk

Data:

2009-03-25 17:31:18 (17 years ago)

Autor:

marek

Opis:

fixes #139

Lokalizacja:

trunk

Pliki:

: 1 dodane
: 10 zmodyfikowane

SQL/StoredProcedures/proc_NowaPlatnoscEcard.txt (dodane)
SQL/Views/vDanePlatnosciEcard.txt (zmodyfikowane) (1 diff)
eCard/Expo/Default.aspx.cs (zmodyfikowane) (2 diffs)
eCard/Expo/Global.asax (zmodyfikowane) (1 diff)
eCard/Expo/Merchant.aspx.cs (zmodyfikowane) (3 diffs)
eCard/Expo/Web.Config (zmodyfikowane) (1 diff)
eCard/Expo/ecard/Web.config (zmodyfikowane) (1 diff)
eCard/Expo/login.aspx.cs (zmodyfikowane) (3 diffs)
eCard/Expo/platnosc.aspx.cs (zmodyfikowane) (6 diffs)
eCard/Expo/platnosci.4.1.resharper.user (zmodyfikowane) (5 diffs)
eCard/Expo/platnosci.suo (zmodyfikowane) (poprzedni)

Legenda:

: Bez zmian
: Dodane
: Usunięte

trunk/SQL/Views/vDanePlatnosciEcard.txt

r478	r486
7	7	ALTER VIEW [dbo].[vDanePlatnosciEcard]
8	8	AS
9		SELECT dbo.REKLAMA.ReklamaID AS Id, dbo.AGENCJE.kod, dbo.AGENCJE.miasto, dbo.AGENCJE.woj, dbo.AGENCI.Imiê, dbo.AGENCI.Nazwisko,
10		dbo.REKLAMA.TYTU£ AS Tytul, dbo.REKLAMA.TYP, dbo.REKLAMA.[ID REKLAMY], dbo.REKLAMA.SZER, dbo.REKLAMA.WYS, dbo.REKLAMA.KOLOR,
11		dbo.REKLAMA.[WSKAZANIE MIEJSCA] AS WskazanieMiejsca, dbo.REKLAMA.RABAT, dbo.REKLAMA.[RABAT WARTOÆ] AS RabatWartosc,
12		dbo.REKLAMA.INFO, dbo.REKLAMA.[CENA JEDN] AS CenaJedn, dbo.REKLAMA.NETTO, dbo.REKLAMA.VAT, dbo.REKLAMA.PVAT,
13		dbo.REKLAMA.BRUTTO, dbo.REKLAMA.[DATA ZAP£ATY] AS DataZaplaty,
14		CAST(dbo.FAKTURY.NUMER AS NVARCHAR) + '/' + dbo.FAKTURY.NUMER_ROZ + '/' + CAST(dbo.FAKTURY.NUMER_ROK AS NVARCHAR) AS [FAKTURA NUMER],
15		dbo.FAKTURY.DATA_WYSTAWIENIA AS [FAKTURA DATA WYSTAWIENIA], dbo.REKLAMA.[SYMBOL POTWIERDZENIA] AS SymbolPotwierdzenia, dbo.REKLAMA.STRONA,
16		dbo.KLIENCI.FirstName, dbo.KLIENCI.LastName, dbo.KLIENCI.OrganizationName, dbo.KLIENCI.Address, dbo.KLIENCI.City, dbo.KLIENCI.PostalCode,
17		dbo.KLIENCI.State, dbo.KLIENCI.Country, REPLACE(REPLACE(dbo.KLIENCI.Nip, ' ', ''), '-', '') AS nip,
18		dbo.REKLAMA.[FAKTURA DATA SPRZEDA¯Y] AS FakturaDataSprzedazy, dbo.REKLAMA.[FAKTURA RODZAJ] AS FakturaRodzaj, dbo.KLIENCI.osw_nr,
19		dbo.REKLAMA.ZAP£ACONO AS Zaplacono, dbo.KLIENCI.Adres_Fkatura, dbo.KLIENCI.Adres_Kor, dbo.AGENCJE.Adres_Fk AS sprzedawca_adres_fk,
20		dbo.REKLAMA.F_NR_ROZ, dbo.REKLAMA.F_NR_ROK, dbo.REKLAMA.F_NR, dbo.FAKTURY.ID_FAKTURY, dbo.FAKTURY.SPOSOB_ZAPLATY,
21		dbo.FAKTURY.TERMIN_ZAPLATY, dbo.FAKTURY.NABYWCA_NIP, dbo.FAKTURY.suma_zaplat, dbo.AGENCJE.ulica, dbo.AGENCJE.telefon,
22		dbo.AGENCJE.fax, dbo.AGENCJE.Nazwa3, dbo.FAKTURY.waluta_brutto, dbo.FAKTURY.waluta_miano, dbo.FAKTURY.SystemKsiegowyId
23		FROM dbo.AGENCJE
24		INNER JOIN dbo.AGENCI ON dbo.AGENCJE.Id_agencji = dbo.AGENCI.ID_AGENCJI
25		INNER JOIN dbo.REKLAMA ON dbo.AGENCI.Symbol = dbo.REKLAMA.[SYMBOL AKWIZYTORA]
26		INNER JOIN dbo.KLIENCI ON dbo.REKLAMA.CustomerID = dbo.KLIENCI.CustomerID
27		INNER JOIN dbo.FAKTURY ON dbo.REKLAMA.ID_FAKTURY = dbo.FAKTURY.ID_FAKTURY
28		UNION
29		SELECT dbo.REKLAMA.ReklamaID AS Id, dbo.AGENCJE.kod, dbo.AGENCJE.miasto, dbo.AGENCJE.woj, dbo.AGENCI.Imiê, dbo.AGENCI.Nazwisko,
30		dbo.REKLAMA.TYTU£ AS Tytul, dbo.REKLAMA.TYP, dbo.REKLAMA.[ID REKLAMY], dbo.REKLAMA.SZER, dbo.REKLAMA.WYS, dbo.REKLAMA.KOLOR,
31		dbo.REKLAMA.[WSKAZANIE MIEJSCA] AS WskazanieMiejsca, dbo.REKLAMA.RABAT, dbo.REKLAMA.[RABAT WARTOÆ] AS RabatWartosc,
32		dbo.REKLAMA.INFO, dbo.REKLAMA.[CENA JEDN] AS CenaJedn, dbo.REKLAMA.NETTO, dbo.REKLAMA.VAT, dbo.REKLAMA.PVAT,
33		dbo.REKLAMA.BRUTTO, dbo.REKLAMA.[DATA ZAP£ATY] AS DataZaplaty,
34		CAST(dbo.FAKTURY.NUMER AS NVARCHAR) + '/' + dbo.FAKTURY.NUMER_ROZ + '/' + CAST(dbo.FAKTURY.NUMER_ROK AS NVARCHAR) AS [FAKTURA NUMER],
35		dbo.FAKTURY.DATA_WYSTAWIENIA AS [FAKTURA DATA WYSTAWIENIA], dbo.REKLAMA.[SYMBOL POTWIERDZENIA] AS SymbolPotwierdzenia, dbo.REKLAMA.STRONA,
36		dbo.KLIENCI.FirstName, dbo.KLIENCI.LastName, dbo.KLIENCI.OrganizationName, dbo.KLIENCI.Address, dbo.KLIENCI.City, dbo.KLIENCI.PostalCode,
37		dbo.KLIENCI.State, dbo.KLIENCI.Country, REPLACE(REPLACE(dbo.KLIENCI.Nip, ' ', ''), '-', '') AS nip,
38		dbo.REKLAMA.[FAKTURA DATA SPRZEDA¯Y] AS FakturaDataSprzedazy, dbo.REKLAMA.[FAKTURA RODZAJ] AS FakturaRodzaj, dbo.KLIENCI.osw_nr,
39		dbo.REKLAMA.ZAP£ACONO AS Zaplacono, dbo.KLIENCI.Adres_Fkatura, dbo.KLIENCI.Adres_Kor, dbo.AGENCJE.Adres_Fk AS sprzedawca_adres_fk,
40		dbo.REKLAMA.F_NR_ROZ, dbo.REKLAMA.F_NR_ROK, dbo.REKLAMA.F_NR, dbo.FAKTURY.ID_FAKTURY, dbo.FAKTURY.SPOSOB_ZAPLATY,
41		dbo.FAKTURY.TERMIN_ZAPLATY, dbo.FAKTURY.NABYWCA_NIP, dbo.FAKTURY.suma_zaplat, dbo.AGENCJE.ulica, dbo.AGENCJE.telefon,
42		dbo.AGENCJE.fax, dbo.AGENCJE.Nazwa3, dbo.FAKTURY.waluta_brutto, dbo.FAKTURY.waluta_miano, dbo.FAKTURY.SystemKsiegowyId
43		FROM dbo.AGENCJE
44		INNER JOIN dbo.AGENCI ON dbo.AGENCJE.Id_agencji = dbo.AGENCI.ID_AGENCJI
45		INNER JOIN dbo.REKLAMA ON dbo.AGENCI.Symbol = dbo.REKLAMA.[SYMBOL AKWIZYTORA]
46		INNER JOIN dbo.KLIENCI ON dbo.REKLAMA.CustomerID = dbo.KLIENCI.CustomerID
47		INNER JOIN dbo.Zamowienia ON dbo.REKLAMA.idZamowienia = dbo.Zamowienia.idZamowienia
48		INNER JOIN dbo.Faktury on dbo.Faktury.idZamowienia = dbo.Zamowienia.idZamowienia
	9
	10	SELECT
	11	F.ID_faktury,
	12	F.Numer,
	13	F.Numer_Roz,
	14	F.Numer_Rok,
	15	F.SystemKsiegowyId,
	16	K.FirstName,
	17	K.LastName,
	18	K.Address,
	19	K.PostalCode,
	20	K.City,
	21	REPLACE(REPLACE(K.nip, ' ', ''), '-', '') AS nip,
	22	CAST(F.Numer AS nvarchar) + '/' + F.Numer_Roz + '/' + CAST(F.Numer_Rok AS nvarchar) AS [Faktura Numer],
	23	F.Nabywca_nip,
	24	CAST(COALESCE(SUM(FD.Netto * (1 + FD.S_Vat)), 0) AS decimal(9,2)) AS Brutto,
	25	F.Data_Wystawienia,
	26	F.Termin_zaplaty,
	27	F.Sposob_zaplaty,
	28	A.[Imiê] AS Imie,
	29	A.Nazwisko,
	30	Ag.ulica,
	31	Ag.kod,
	32	Ag.miasto,
	33	Ag.telefon,
	34	CAST(COALESCE(F.waluta_brutto, 0) AS decimal(9,2)) AS waluta_brutto,
	35	F.waluta_miano
	36	FROM Faktury AS F
	37	INNER JOIN Faktura_Details AS FD ON FD.Id_Faktury=F.Id_Faktury
	38	INNER JOIN Agenci AS A ON A.F_ROZ= F.NUMER_ROZ
	39	INNER JOIN Agencje AS Ag ON Ag.Id_agencji= F.Id_Sprzedawcy
	40	INNER JOIN Klienci AS K ON K.CustomerId = F.Id_Nabywcy
	41	GROUP BY
	42	F.Numer_Rok,
	43	F.Numer_Roz,
	44	F.Numer,
	45	K.FirstName,
	46	K.LastName,
	47	K.Address,
	48	K.PostalCode,
	49	K.City,
	50	K.nip,
	51	F.Nabywca_nip,
	52	F.Data_Wystawienia,
	53	F.Termin_zaplaty,
	54	F.Sposob_zaplaty,
	55	F.ID_faktury,
	56	A.[Imiê],
	57	A.Nazwisko,
	58	Ag.ulica,
	59	Ag.kod,
	60	Ag.miasto,
	61	Ag.telefon,
	62	F.waluta_brutto,
	63	F.waluta_miano,
	64	F.SystemKsiegowyId
	65
49	66	GO
50	67

trunk/eCard/Expo/Default.aspx.cs

r477	r486
1	1	using System;
2		~~using System.Data;~~
3		~~using System.Configuration;~~
4		~~using System.Collections;~~
5		~~using System.Web;~~
6		~~using System.Web.Security;~~
7		~~using System.Web.UI;~~
8		~~using System.Web.UI.WebControls;~~
9		~~using System.Web.UI.WebControls.WebParts;~~
10		~~using System.Web.UI.HtmlControls;~~
11	2
12	3	public partial class _Default : System.Web.UI.Page
…	…
14	5	protected void Page_Load(object sender, EventArgs e)
15	6	{
16		Response.Redirect("~~platnosc~~.aspx");
	7	Response.Redirect("login.aspx");
17	8	}
18	9	}

trunk/eCard/Expo/Global.asax

r477	r486
34	34
35	35	// Email Error
36		string strEmail = "~~central~~a@ct.com.pl";
	36	string strEmail = "marek.stachura@ct.com.pl";
37	37	SendMail email = new SendMail();
38	38	email.Wyslij(strEmail, strEmail, "platnosci.admoto.pl Error", strErrorMsg);
39	39
40
	40	Response.Redirect("Error.aspx");
41	41	}
42	42

trunk/eCard/Expo/Merchant.aspx.cs

r477	r486
68	68	string nip = (string)Session["nip"];
69	69	string nrZlec = (string)Session["nrFaktury"];
70		string idFaktury = (string)Session["IDFaktury"];
	70	string idFaktury = (string)Session["IdFaktury"];
71	71	string tORDERNUMBER = "";
72	72	using (SqlConnection conn = new SqlConnection(connString))
…	…
127	127	stIn.Close();
128	128
129		// Sprawdzenie odpowiedzi
130		if (strResponse == "zlyHash")
131		{
132		// b³êdne parametry - z³y numer zamówienia, opis, kwota lub waluta
	129	//// Sprawdzenie odpowiedzi
	130	//if (strResponse == "zlyHash")
	131	//{
	132	// // b³êdne parametry - z³y numer zamówienia, opis, kwota lub waluta
133	133
134		}
135		else if (strResponse == "wrongPassword")
136		{
137		// Niepoprawne has³o
138		}
139		else
140		{
141		//OK
142		}
	134	//}
	135	//else if (strResponse == "wrongPassword")
	136	//{
	137	// // Niepoprawne has³o
	138	//}
	139	//else
	140	//{
	141	// //OK
	142	//}
143	143
144	144	string tHASH = strResponse;
…	…
147	147	string tMERCHANTID = (string)Session["MERCHANTID"];
148	148	MERCHANTID.Text = "<input name='MERCHANTID' type='hidden' value='" + tMERCHANTID + "'/>";
149		LINKOK.Text = Int32.Parse(systemKsiegowy) == 1 ? "<input name='LINKOK' type='hidden' value='http://platnosci.admoto.pl/info.aspx?status=ok'/>" : "<input name='LINKOK' type='hidden' value='http://pay.truck-expo.com/info.aspx?status=ok'/>"; ;
150		LINKFAIL.Text = Int32.Parse(systemKsiegowy) == 1 ? "<input name='LINKFAIL' type='hidden' value='http://platnosci.admoto.pl/info.aspx?status=fail'/>" : "<input name='LINKFAIL' type='hidden' value='http://pay.truck-expo.com/info.aspx?status=fail'/>";
	149	LINKOK.Text = "<input name='LINKOK' type='hidden' value='" + ConfigurationManager.AppSettings["StatusLink"] + "?status=ok'/>";
	150	LINKFAIL.Text = "<input name='LINKFAIL' type='hidden' value='" + ConfigurationManager.AppSettings["StatusLink"] + "?status=fail'/>";
151	151	}
152	152	else

trunk/eCard/Expo/Web.Config

r477	r486
16	16	<add key="SmtpUser" value="marek.stachura@ct.com.pl"/>
17	17	<add key="SmtpPwd" value="mageroni"/>
	18	<add key="StatusLink" value="http://platnosci.admoto.pl/info.aspx"/>
	19	<!--<add key="StatusLink" value="http://pay.truck-expo.com/info.aspx"/>-->
18	20	</appSettings>
19	21	<connectionStrings>

trunk/eCard/Expo/ecard/Web.config

r477	r486
1	1	<?xml version="1.0"?>
2		~~<!--~~
3		~~Note: As an alternative to hand editing this file you can use the~~
4		~~web admin tool to configure settings for your application. Use~~
5		~~the Website->Asp.Net Configuration option in Visual Studio.~~
6		~~A full list of settings and comments can be found in~~
7		~~machine.config.comments usually located in~~
8		~~\Windows\Microsoft.Net\Framework\v2.x\Config~~
9		~~-->~~
10	2	<configuration>
11	3	<appSettings/>
12	4	<connectionStrings>
13	5	<add name="BazaReklamConn"
14		connectionString="SERVER=10.0.0.21;DATABASE=~~Truck_Expo~~;UID=wwwadmin;PWD=adm1648;"
	6	connectionString="SERVER=10.0.0.21;DATABASE=Baza_Reklam;UID=wwwadmin;PWD=adm1648;"
15	7	providerName="System.Data.SqlClient" />
16	8	</connectionStrings>

trunk/eCard/Expo/login.aspx.cs

r477	r486
2	2	using System.Data;
3	3	using System.Configuration;
4		~~using System.Collections;~~
5		~~using System.Web;~~
6	4	using System.Web.Security;
7		~~using System.Web.UI;~~
8		~~using System.Web.UI.WebControls;~~
9		~~using System.Web.UI.WebControls.WebParts;~~
10		~~using System.Web.UI.HtmlControls;~~
11	5	using System.Data.SqlClient;
12	6	using System.Threading;
13	7	using System.Globalization;
14		~~using System.Resources;~~
15	8
16	9	public partial class login : System.Web.UI.Page
…	…
37	30
38	31	FakturaImageButton.ImageUrl = Resources.Common.Faktura;
39		if (!IsPostBack) { SetFocus(NIPTextBox); }
	32	if (!IsPostBack) { SetFocus(NIPTextBox); }
40	33	}
41	34
42	35	protected void ZalogujButton_Click(object sender, EventArgs e)
43	36	{
44		string nip = NIPTextBox.Text;
45		string nrZlec = NrZlecTextBox.Text;
	37	string nip = NIPTextBox.Text.Replace(" ", string.Empty).Replace("-", string.Empty);
	38	string nrZlec = NrZlecTextBox.Text.Replace(" ", string.Empty);
46	39	bool czyZalogowany = Zaloguj(nip, nrZlec);
47	40	if (czyZalogowany)
48	41	{
49		FormsAuthentication.RedirectFromLoginPage(nip, false);
	42	FormsAuthentication.RedirectFromLoginPage(nip, false);
50	43	}
51	44	else
…	…
57	50	bool Zaloguj(string nip, string nrFaktury)
58	51	{
	52	string fakturaNr = nrFaktury.Split('/')[0];
	53	string fakturaRoz = nrFaktury.Split('/')[1];
	54	string fakturaRok = nrFaktury.Split('/')[2];
	55
59	56	string connString = ConfigurationManager.ConnectionStrings["BazaReklamConn"].ConnectionString;
60		string cmdText = "SELECT COUNT(*) FROM dbo.vDanePlatnosciEcard WHERE nip=@nip AND [Faktura Numer]=@nrFaktury";
61		nip = nip.Replace(" ", "");
62		nip = nip.Replace("-", "");
63		int znalezione = 0;
64		using(SqlConnection conn = new SqlConnection(connString))
	57	const string cmdText = "SELECT ID_Faktury FROM dbo.vDanePlatnosciEcard WHERE nip=@nip AND [Numer]=@numer AND [Numer_Roz]=@numerRoz AND [Numer_Rok]=@numerRok";
	58	bool znalezione = false;
	59	using (SqlConnection conn = new SqlConnection(connString))
65	60	{
66	61	SqlCommand cmd = new SqlCommand(cmdText, conn);
67	62	cmd.Parameters.Add("@nip", SqlDbType.NVarChar, 50).Value = nip;
68		cmd.Parameters.Add("@nrFaktury", SqlDbType.NVarChar, 20).Value = nrFaktury;
	63	cmd.Parameters.Add("@numer", SqlDbType.NVarChar, 10).Value = fakturaNr;
	64	cmd.Parameters.Add("@numerRoz", SqlDbType.NVarChar, 10).Value = fakturaRoz;
	65	cmd.Parameters.Add("@numerRok", SqlDbType.NVarChar, 10).Value = fakturaRok;
69	66	conn.Open();
70		znalezione = (int)cmd.ExecuteScalar();
71		if (znalezione > 0)
	67
	68	SqlDataReader reader = cmd.ExecuteReader();
	69	if (reader == null)
72	70	{
73		~~Session["nip"] = nip~~;
74		~~Session["nrFaktury"] = nrFaktury~~;
	71	conn.Close();
	72	return false;
75	73	}
	74
	75	if (reader.Read())
	76	{
	77	Session["Nip"] = nip;
	78	Session["NrFaktury"] = nrFaktury;
	79	Session["IdFaktury"] = reader.GetInt32(0);
	80	znalezione = true;
	81	}
	82	reader.Close();
	83	reader.Dispose();
76	84	conn.Close();
77	85	}
78		return ~~(znalezione > 0)~~;
	86	return znalezione;
79	87	}
80
81	88	}

trunk/eCard/Expo/platnosc.aspx.cs

r477	r486
32	32	}
33	33
34		~~protected string wartoscNaString(SqlDataReader reader, int i, string rodzajZmiennej)~~
35		{
36		~~string wartosc = "";~~
37		~~if (rodzajZmiennej == "string")~~
38		{
39		~~try~~
40		{
41		~~if (!reader[i].Equals(System.DBNull.Value)) { wartosc = (string)reader[i]; };~~
42		}
43		~~catch (System.NullReferenceException err)~~
44		{
45		~~wartosc = "Error: " + err.ToString();~~
46		}
47		~~return wartosc;~~
48		}
49		~~if (rodzajZmiennej == "DateTime")~~
50		{
51		~~DateTime data;~~
52		~~try~~
53		{
54		~~if (!reader[i].Equals(System.DBNull.Value))~~
55		{
56		~~data = (DateTime)reader[i];~~
57		~~wartosc = data.ToShortDateString();~~
58		}
59
60		}
61		~~catch (System.NullReferenceException err)~~
62		{
63		~~wartosc = "Error: " + err.ToString();~~
64		}
65		}
66		~~if (rodzajZmiennej == "double")~~
67		{
68		~~double liczba;~~
69		~~try~~
70		{
71		~~if (!reader[i].Equals(System.DBNull.Value))~~
72		{
73		~~liczba = (double)reader[i];~~
74		~~wartosc = liczba.ToString();~~
75		}
76
77		}
78		~~catch (System.NullReferenceException err)~~
79		{
80		~~wartosc = "Error: " + err.ToString();~~
81		}
82		}
83		~~return wartosc;~~
84
85		}
86
87		~~protected string przeliczNaGrosze(SqlDataReader reader, int i)~~
88		{
89		~~string grosze = "";~~
90		~~double dGrosze;~~
91		~~try~~
92		{
93		~~if (!reader[i].Equals(System.DBNull.Value))~~
94		{
95		~~dGrosze = (double)reader[i];~~
96		~~dGrosze = dGrosze * 100;~~
97		~~grosze = dGrosze.ToString();~~
98		}
99
100		}
101		~~catch (System.NullReferenceException err)~~
102		{
103		~~grosze = "Error: " + err.ToString();~~
104		}
105		~~return grosze;~~
106		}
107
108	34	protected void Page_Load(object sender, EventArgs e)
109	35	{
	36	if (string.IsNullOrEmpty(Session["IdFaktury"].ToString())) Response.Redirect("login.aspx");
110	37
111	38	if (!IsPostBack)
112	39	{
113	40	string connString = ConfigurationManager.ConnectionStrings["BazaReklamConn"].ConnectionString;
114		string cmdText = "SELECT [ID Reklamy], FirstName, LastName, Address, PostalCode, City, State, Country, [Faktura Numer], Nabywca_nip, Brutto, [Faktura Data Wystawienia], Termin_zaplaty, Sposob_zaplaty, ID_faktury, [Imię], Nazwisko, ulica, kod, miasto, telefon, fax, waluta_brutto, waluta_miano, SystemKsiegowyId FROM dbo.vDanePlatnosciEcard WHERE nip=@nip AND [Faktura Numer]=@nrFaktury";
115		string nip = (string)Session["nip"];
116		string nrZlec = (string)Session["nrFaktury"];
	41	string cmdText = "SELECT SystemKsiegowyId, FirstName, LastName, Address, PostalCode, City, nip, Nabywca_nip, Brutto, Data_Wystawienia, Termin_zaplaty, Sposob_zaplaty, Imie, Nazwisko, ulica, kod, miasto, telefon, waluta_brutto, waluta_miano FROM dbo.vDanePlatnosciEcard WHERE ID_Faktury=@idFaktury";
	42	//string nip = (string)Session["nip"];
	43	//string nrZlec = (string)Session["nrFaktury"];
	44	int idFaktury = Int32.Parse(Session["IdFaktury"].ToString());
117	45	using (SqlConnection conn = new SqlConnection(connString))
118	46	{
119	47	SqlCommand cmd = new SqlCommand(cmdText, conn);
120		cmd.Parameters.Add("@nip", SqlDbType.NVarChar, 50).Value = nip;
121		cmd.Parameters.Add("@~~nrFaktury", SqlDbType.NVarChar, 20).Value = nrZlec~~;
	48	//cmd.Parameters.Add("@nip", SqlDbType.NVarChar, 50).Value = nip;
	49	cmd.Parameters.Add("@idFaktury", SqlDbType.Int).Value = idFaktury;
122	50
123	51	conn.Open();
…	…
126	54
127	55	// formaPlatnosci i waluta
128		string formaPlatnosci = wartoscNaString(reader, 13, "string");
129		string walBrutto = wartoscNaString(reader, 22, "double");
130		string walMiano = wartoscNaString(reader, 23, "string");
131		string systemKsiegowy = reader.GetByte(24).ToString();
	56	string walBrutto = reader["waluta_brutto"].ToString(); //wartoscNaString(reader, 22, "double");
	57	string walMiano = reader["waluta_miano"].ToString(); // wartoscNaString(reader, 23, "string");
	58	string systemKsiegowy = reader["SystemKsiegowyId"].ToString(); // reader.GetByte(24).ToString();
132	59	if (walMiano != "" && walBrutto != "")
133	60	{
…	…
137	64	values.Add(walMiano);
138	65	WyborWaluty.DataSource = values;
139		WyborWaluty.DataBind();
140		}
141		formaPlatnosci = "karta";
142		// Czy faktura jest zapłacona?
143		/*string formaPlatnosci = "";
144		try
145		{
146		if (!reader[13].Equals(System.DBNull.Value)) { formaPlatnosci = (string)reader[13]; };
147		}
148		catch (System.NullReferenceException err)
149		{
150		formaPlatnosci = "Error: " + err.ToString();
151		}*/
152		if (formaPlatnosci == "karta")
153		{
154		FormaPlatnosci = "karta";
155
156		string firstName = wartoscNaString(reader, 1, "string");
157		string lastName = wartoscNaString(reader, 2, "string");
158		string adres = wartoscNaString(reader, 3, "string");
159		string kod = wartoscNaString(reader, 4, "string");
160		string miasto = wartoscNaString(reader, 5, "string");
161		string tNIP = wartoscNaString(reader, 9, "string");
162		string tNrFaktury = wartoscNaString(reader, 8, "string");
163		Session["NrFaktury"] = tNrFaktury;
164		string tDataWystawienia = wartoscNaString(reader, 11, "DateTime");
165		string tTerminPlatnosci = wartoscNaString(reader, 12, "DateTime");
166		string tBrutto = wartoscNaString(reader, 10, "double");
167		// Amount
168		string AmountPLN = przeliczNaGrosze(reader, 10);
169		string AmountWaluta = przeliczNaGrosze(reader, 22);
170		// tIDFaktury
171		string tIDFaktury = "";
172		int iIDFaktury;
173		try
174		{
175		if (!reader[14].Equals(System.DBNull.Value))
176		{
177		iIDFaktury = (int)reader[14];
178		tIDFaktury = iIDFaktury.ToString();
179		}
180
181		}
182		catch (System.NullReferenceException err)
183		{
184		tIDFaktury = "Error: " + err.ToString();
185		}
186
187		string ImieHandlowca = wartoscNaString(reader, 15, "string");
188		string NazwiskoHandlowca = wartoscNaString(reader, 16, "string");
189		string AdresBiuraUlica = wartoscNaString(reader, 17, "string");
190		string AdresBiuraKod = wartoscNaString(reader, 18, "string");
191		string AdresBiuraMiasto = wartoscNaString(reader, 19, "string");
192		string AdresBiuraTelefony = wartoscNaString(reader, 20, "string");
193		string WalutaBrutto = wartoscNaString(reader, 22, "double");
194		string WalutaMiano = wartoscNaString(reader, 23, "string");
195
196		// ------------- Ustawienie zmiennych -----------------------
197		kwotaPLN = tBrutto;
198		kwotaWaluta = WalutaBrutto;
199		kwotaGroszePLN = AmountPLN;
200		kwotaGroszeWaluta = AmountWaluta;
201		// ------------ Dane do wyświetlenia ------------------------
202
203		// --------- Nazwa
204		string nazwa = "";
205		if (firstName == "")
206		{
207		nazwa = lastName;
208		}
209		else
210		{
211		nazwa = firstName + " " + lastName;
212		}
213
214		Nazwa.Text = nazwa;
215		// --------- Adres
216		Adres.Text = adres + ", " + kod + " " + miasto;
217		// --------- NIP
218		NIP.Text = tNIP;
219		// -------- NrFaktury
220		NrFaktury.Text = tNrFaktury;
221		// --------- DataWystawienia
222		DataWystawienia.Text = tDataWystawienia;
223		// --------- TerminPlatnosci
224		TerminPlatnosci.Text = tTerminPlatnosci;
225
226		//------------- Informacje do kontaktu z handlowcem
227		Handlowiec.Text = ImieHandlowca + " " + NazwiskoHandlowca;
228		BiuroAdres.Text = AdresBiuraUlica + ", " + AdresBiuraKod + " " + AdresBiuraMiasto;
229		BiuroTelefon.Text = AdresBiuraTelefony;
230
231		// ---------------------- Dane przekazywane do sesji ------------
232
233		// -------------- ORDERDESCRIPTION
234		string ORDERDESCRIPTION = (string)Session["nrFaktury"];
235		Session["ORDERDESCRIPTION"] = ORDERDESCRIPTION;
236		// ---------------- ORDERNUMBER
237		string ORDERNUMBER = "1";
238		Session["ORDERNUMBER"] = ORDERNUMBER;
239		// ----------------- SESSIONID
240		string SESSIONID = Session.SessionID;
241		Session["SESSIONID"] = SESSIONID;
242		// ------------- LANGUAGE PL - polski, EN - angielski, DE - niemiecki, FR - francuski, RU - rosyjski
243		string LANGUAGE = "PL";
244
245		Session["SystemKsiegowy"] = systemKsiegowy;
246
247		if ((string)Session["CURRENCY"] == "978")
248		{
249		Session["CURRENCY"] = "978";
250		Session["AMOUNT"] = kwotaGroszeWaluta;
251		Brutto.Text = kwotaWaluta + " €";
252		WyborWaluty.SelectedValue = "EUR";
253		}
254		else if ((string)Session["CURRENCY"] == "985")
255		{
256		Session["CURRENCY"] = "985";
257		Session["AMOUNT"] = kwotaGroszePLN;
258		Brutto.Text = kwotaPLN + " zł";
259		WyborWaluty.SelectedValue = "PLN";
260		}
	66	WyborWaluty.DataBind();
	67	}
	68
	69	FormaPlatnosci = "karta";
	70
	71	string firstName = reader["FirstName"].ToString();
	72	string lastName = reader["LastName"].ToString();
	73	string adres = reader["Address"].ToString();
	74	string kod = reader["PostalCode"].ToString();
	75	string miasto = reader["City"].ToString();
	76	string tNIP = reader["Nabywca_nip"].ToString();
	77	string tNrFaktury = Session["NrFaktury"].ToString();
	78	string tDataWystawienia = DateTime.Parse(reader["Data_Wystawienia"].ToString()).ToString("yyyy-MM-dd");
	79	string tTerminPlatnosci = DateTime.Parse(reader["Termin_zaplaty"].ToString()).ToString("yyyy-MM-dd");
	80	string tBrutto = reader["Brutto"].ToString();
	81	// Amount
	82	string AmountPLN = Convert.ToInt32(Convert.ToDecimal(reader["Brutto"])*100).ToString();
	83	string AmountWaluta = Convert.ToInt32(Convert.ToDecimal(reader["waluta_brutto"]) * 100).ToString();
	84	// tIDFaktury
	85	string tIDFaktury = Session["IdFaktury"].ToString();
	86	string ImieHandlowca = reader["Imie"].ToString(); //wartoscNaString(reader, 15, "string");
	87	string NazwiskoHandlowca = reader["Nazwisko"].ToString(); //wartoscNaString(reader, 16, "string");
	88	string AdresBiuraUlica = reader["Ulica"].ToString(); //wartoscNaString(reader, 17, "string");
	89	string AdresBiuraKod = reader["Kod"].ToString(); //wartoscNaString(reader, 18, "string");
	90	string AdresBiuraMiasto = reader["Miasto"].ToString(); //wartoscNaString(reader, 19, "string");
	91	string AdresBiuraTelefony = reader["Telefon"].ToString(); //wartoscNaString(reader, 20, "string");
	92	string WalutaBrutto = reader["waluta_brutto"].ToString(); //wartoscNaString(reader, 22, "double");
	93	string WalutaMiano = reader["Waluta_Miano"].ToString(); //wartoscNaString(reader, 23, "string");
	94
	95	// ------------- Ustawienie zmiennych -----------------------
	96	kwotaPLN = tBrutto;
	97	kwotaWaluta = WalutaBrutto;
	98	kwotaGroszePLN = AmountPLN;
	99	kwotaGroszeWaluta = AmountWaluta;
	100	// ------------ Dane do wyświetlenia ------------------------
	101
	102	// --------- Nazwa
	103	string nazwa;
	104	if (firstName == "")
	105	{
	106	nazwa = lastName;
	107	}
	108	else
	109	{
	110	nazwa = firstName + " " + lastName;
	111	}
	112
	113	Nazwa.Text = nazwa;
	114	// --------- Adres
	115	Adres.Text = adres + ", " + kod + " " + miasto;
	116	// --------- NIP
	117	NIP.Text = tNIP;
	118	// -------- NrFaktury
	119	NrFaktury.Text = tNrFaktury;
	120	// --------- DataWystawienia
	121	DataWystawienia.Text = tDataWystawienia;
	122	// --------- TerminPlatnosci
	123	TerminPlatnosci.Text = tTerminPlatnosci;
	124
	125	//------------- Informacje do kontaktu z handlowcem
	126	Handlowiec.Text = ImieHandlowca + " " + NazwiskoHandlowca;
	127	BiuroAdres.Text = AdresBiuraUlica + ", " + AdresBiuraKod + " " + AdresBiuraMiasto;
	128	BiuroTelefon.Text = AdresBiuraTelefony;
	129
	130	// ---------------------- Dane przekazywane do sesji ------------
	131
	132	// -------------- ORDERDESCRIPTION
	133	string ORDERDESCRIPTION = (string) Session["nrFaktury"];
	134	Session["ORDERDESCRIPTION"] = ORDERDESCRIPTION;
	135	// ---------------- ORDERNUMBER
	136	string ORDERNUMBER = "1";
	137	Session["ORDERNUMBER"] = ORDERNUMBER;
	138	// ----------------- SESSIONID
	139	string SESSIONID = Session.SessionID;
	140	Session["SESSIONID"] = SESSIONID;
	141	// ------------- LANGUAGE PL - polski, EN - angielski, DE - niemiecki, FR - francuski, RU - rosyjski
	142	string LANGUAGE = "PL";
	143
	144	Session["SystemKsiegowy"] = systemKsiegowy;
	145
	146	if ((string) Session["CURRENCY"] == "978")
	147	{
	148	Session["CURRENCY"] = "978";
	149	Session["AMOUNT"] = kwotaGroszeWaluta;
	150	Brutto.Text = kwotaWaluta + " €";
	151	WyborWaluty.SelectedValue = "EUR";
	152	}
	153	else if ((string) Session["CURRENCY"] == "985")
	154	{
	155	Session["CURRENCY"] = "985";
	156	Session["AMOUNT"] = kwotaGroszePLN;
	157	Brutto.Text = kwotaPLN + " zł";
	158	WyborWaluty.SelectedValue = "PLN";
	159	}
261	160	//else if ((string)Session["CURRENCY"] == "826")
262	161	//{
…	…
266	165	// WyborWaluty.SelectedValue = "GBP";
267	166	//}
268		~~else~~
269		{
270		~~Session["CURRENCY"] = "985";~~
271		~~Session["AMOUNT"] = kwotaGroszePLN;~~
272		~~Brutto.Text = kwotaPLN + " zł";~~
273		~~WyborWaluty.SelectedValue = "PLN";~~
274		}
275		~~if (Thread.CurrentThread.CurrentCulture.Name == "pl-PL")~~
276		{
277		~~Session["culture"] = "pl-PL";~~
278		~~LANGUAGE = "PL";~~
279		}
280		~~else if (Thread.CurrentThread.CurrentCulture.Name == "en-US")~~
281		{
282		~~Session["culture"] = "en-US";~~
283		~~LANGUAGE = "EN";~~
284		}
285		~~else if (Thread.CurrentThread.CurrentCulture.Name == "fr-FR")~~
286		{
287		~~Session["culture"] = "fr-FR";~~
288		~~LANGUAGE = "FR";~~
289		}
290		~~else if (Thread.CurrentThread.CurrentCulture.Name == "it-IT")~~
291		{
292		~~Session["culture"] = "it-IT";~~
293		~~LANGUAGE = "IT";~~
294		}
295		~~else if (Thread.CurrentThread.CurrentCulture.Name == "de-DE")~~
296		{
297		~~Session["culture"] = "de-DE";~~
298		~~LANGUAGE = "DE";~~
299		}
300		~~else~~
301		{
302		~~Session["culture"] = "en-US";~~
303		~~LANGUAGE = "EN";~~
304		}
305		~~Session["LANGUAGE"] = LANGUAGE;~~
306		~~// ----------------- CHARSET~~
307		~~string CHARSET = "ISO-8859-2";~~
308		~~Session["CHARSET"] = CHARSET;~~
309		~~// ---------------- COUNTRY 616 - Polska~~
310		~~string COUNTRY = "616";~~
311		~~Session["COUNTRY"] = COUNTRY;~~
312		~~// ---------------- PAYMENTTYPE~~
313		~~string PAYMENTTYPE = "CARDS";~~
314		~~Session["PAYMENTTYPE"] = PAYMENTTYPE;~~
315		~~// --------------- MERCHANTID~~
316		~~Session["MERCHANTID"] = Int32.Parse(systemKsiegowy) == 1 ? "170906000" : "171485000";~~
317		~~// ---------------- AUTODEPOSIT~~
318		~~Session["AUTODEPOSIT"] = "1";~~
319		~~// ---------------- IDFAKTURY~~
320		~~Session["IDFaktury"] = tIDFaktury;~~
321		}
322
323	167	else
324	168	{
325		FormaPlatnosci = "";
326		}
	169	Session["CURRENCY"] = "985";
	170	Session["AMOUNT"] = kwotaGroszePLN;
	171	Brutto.Text = kwotaPLN + " zł";
	172	WyborWaluty.SelectedValue = "PLN";
	173	}
	174	if (Thread.CurrentThread.CurrentCulture.Name == "pl-PL")
	175	{
	176	Session["culture"] = "pl-PL";
	177	LANGUAGE = "PL";
	178	}
	179	else if (Thread.CurrentThread.CurrentCulture.Name == "en-US")
	180	{
	181	Session["culture"] = "en-US";
	182	LANGUAGE = "EN";
	183	}
	184	else if (Thread.CurrentThread.CurrentCulture.Name == "fr-FR")
	185	{
	186	Session["culture"] = "fr-FR";
	187	LANGUAGE = "FR";
	188	}
	189	else if (Thread.CurrentThread.CurrentCulture.Name == "it-IT")
	190	{
	191	Session["culture"] = "it-IT";
	192	LANGUAGE = "IT";
	193	}
	194	else if (Thread.CurrentThread.CurrentCulture.Name == "de-DE")
	195	{
	196	Session["culture"] = "de-DE";
	197	LANGUAGE = "DE";
	198	}
	199	else
	200	{
	201	Session["culture"] = "en-US";
	202	LANGUAGE = "EN";
	203	}
	204	Session["LANGUAGE"] = LANGUAGE;
	205	// ----------------- CHARSET
	206	string CHARSET = "ISO-8859-2";
	207	Session["CHARSET"] = CHARSET;
	208	// ---------------- COUNTRY 616 - Polska
	209	string COUNTRY = "616";
	210	Session["COUNTRY"] = COUNTRY;
	211	// ---------------- PAYMENTTYPE
	212	string PAYMENTTYPE = "CARDS";
	213	Session["PAYMENTTYPE"] = PAYMENTTYPE;
	214	// --------------- MERCHANTID
	215	Session["MERCHANTID"] = Int32.Parse(systemKsiegowy) == 1 ? "170906000" : "171485000";
	216	// ---------------- AUTODEPOSIT
	217	Session["AUTODEPOSIT"] = "1";
	218	// ---------------- IDFAKTURY
	219	Session["IdFaktury"] = tIDFaktury;
327	220	reader.Close();
328	221	conn.Close();
329
330	222	}
331	223	}
…	…
333	225	{
334	226	string connString = ConfigurationManager.ConnectionStrings["BazaReklamConn"].ConnectionString;
335		string cmdText = "SELECT [ID Reklamy], FirstName, LastName, Address, PostalCode, City, State, Country, [Faktura Numer], Nabywca_nip, Brutto, [Faktura Data Wystawienia], Termin_zaplaty, Sposob_zaplaty, ID_faktury, [Imię], Nazwisko, ulica, kod, miasto, telefon, fax, waluta_brutto, waluta_miano, SystemKsiegowyId FROM dbo.vDanePlatnosciEcard WHERE nip=@nip AND [Faktura Numer]=@nrFaktury";
336		string nip = (string)Session["nip"];
337		string nrZlec = (string)Session["nrFaktury"];
	227	string cmdText = "SELECT SystemKsiegowyId, FirstName, LastName, Address, PostalCode, City, nip, Nabywca_nip, Brutto, Data_Wystawienia, Termin_zaplaty, Sposob_zaplaty, Imie, Nazwisko, ulica, kod, miasto, telefon, waluta_brutto, waluta_miano FROM dbo.vDanePlatnosciEcard WHERE ID_Faktury=@idFaktury";
	228	//string nip = (string)Session["nip"];
	229	//string nrZlec = (string)Session["nrFaktury"];
	230	int idFaktury = Int32.Parse(Session["IdFaktury"].ToString());
338	231	using (SqlConnection conn = new SqlConnection(connString))
339	232	{
340	233	SqlCommand cmd = new SqlCommand(cmdText, conn);
341		cmd.Parameters.Add("@nip", SqlDbType.NVarChar, 50).Value = nip;
342		cmd.Parameters.Add("@nrFaktury", SqlDbType.NVarChar, 20).Value = nrZlec;
	234	//cmd.Parameters.Add("@nip", SqlDbType.NVarChar, 50).Value = nip;
	235	//cmd.Parameters.Add("@nrFaktury", SqlDbType.NVarChar, 20).Value = nrZlec;
	236	cmd.Parameters.Add("@idFaktury", SqlDbType.Int).Value = idFaktury;
343	237
344	238	conn.Open();
…	…
347	241
348	242	// Wartości
349		string tBrutto = ~~wartoscNaString(reader, 10, "double"~~);
350		string WalutaBrutto = ~~wartoscNaString(reader, 22, "double"~~);
351		string AmountPLN = przeliczNaGrosze(reader, 10);
352		string AmountWaluta = przeliczNaGrosze(reader, 22);
	243	string tBrutto = reader["Brutto"].ToString();
	244	string WalutaBrutto = reader["Waluta_Brutto"].ToString();
	245	string AmountPLN = (Convert.ToInt32(reader["Brutto"]) * 100).ToString(); // reader[""].ToString(); //przeliczNaGrosze(reader, 10);
	246	string AmountWaluta = (Convert.ToInt32(reader["waluta_brutto"]) * 100).ToString(); //przeliczNaGrosze(reader, 22);
353	247
354	248	// ------------- Ustawienie zmiennych -----------------------

trunk/eCard/Expo/platnosci.4.1.resharper.user

r477	r486
14	14	<RecentFiles>
15	15	<RecentFiles>
16		~~<File id="d:Miscellaneous Files/f:Merchant.aspx.cs" caret="5883" scrollPosition="0\|0" />~~
17		~~<File id="d:Miscellaneous Files/f:platnosc.aspx.cs" caret="0" scrollPosition="0\|0" />~~
18	16	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_LocalResources/f:login.aspx.de.resx" caret="6889" scrollPosition="0\|129" />
19	17	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_LocalResources/f:login.aspx.fr.resx" caret="6817" scrollPosition="0\|128" />
…	…
21	19	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_LocalResources/f:login.aspx.pl.resx" caret="6881" scrollPosition="0\|128" />
22	20	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_LocalResources/f:login.aspx.resx" caret="6866" scrollPosition="0\|129" />
23		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:DummyGlobalAsax/f:Global.asax" caret="1403" scrollPosition="0\|0" />~~
24	21	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_Code/f:SendMail.cs" caret="1331" scrollPosition="0\|0" />
25		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx" caret="2063" scrollPosition="72\|0" />~~
26	22	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:MasterPage.master" caret="1783" scrollPosition="0\|0" />
27		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="1033" scrollPosition="0\|0" />~~
28		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_Code/f:Web.Config" caret="2037" scrollPosition="0\|0" />~~
29	23	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx" caret="3701" scrollPosition="0\|0" />
30		~~<File id="d:Miscellaneous Files/f:Web.config" caret="762" scrollPosition="0\|0" />~~
31	24	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:ecard/f:Status.aspx" caret="0" scrollPosition="0\|0" />
32	25	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:ecard/f:Status.aspx.cs" caret="1946" scrollPosition="0\|13" />
33		<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:info.aspx.cs" caret="835" scrollPosition="0\|30" />
34		<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="4730" scrollPosition="0\|106" />
35		<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Merchant.aspx.cs" caret="7502" scrollPosition="0\|121" />
	26	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:info.aspx" caret="0" scrollPosition="0\|0" />
	27	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Merchant.aspx" caret="0" scrollPosition="0\|0" />
	28	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Error.aspx.cs" caret="0" scrollPosition="0\|0" />
	29	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:DummyGlobalAsax/f:Global.asax" caret="0" scrollPosition="0\|0" />
	30	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:info.aspx.cs" caret="0" scrollPosition="0\|0" />
	31	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:MasterPage.master.cs" caret="0" scrollPosition="0\|66" />
	32	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_Code/f:Web.Config" caret="3599" scrollPosition="0\|15" />
	33	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Merchant.aspx.cs" caret="3377" scrollPosition="0\|57" />
	34	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Default.aspx.cs" caret="197" scrollPosition="0\|0" />
	35	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="1636" scrollPosition="0\|38" />
	36	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx" caret="1190" scrollPosition="0\|0" />
	37	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="997" scrollPosition="0\|13" />
36	38	</RecentFiles>
37	39	<RecentEdits>
38		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="2328" scrollPosition="0\|51" />~~
39		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="4043" scrollPosition="0\|107" />~~
40		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Merchant.aspx.cs" caret="3941" scrollPosition="0\|58" />~~
41		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="3552" scrollPosition="190\|101" />~~
42		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="14518" scrollPosition="190\|319" />~~
43		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="10284" scrollPosition="0\|207" />~~
44		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="13635" scrollPosition="0\|279" />~~
45		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Merchant.aspx.cs" caret="5539" scrollPosition="6\|86" />~~
46		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Merchant.aspx.cs" caret="6142" scrollPosition="54\|86" />~~
47		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_LocalResources/f:login.aspx.de.resx" caret="6889" scrollPosition="0\|129" />~~
48		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_LocalResources/f:login.aspx.fr.resx" caret="6817" scrollPosition="0\|128" />~~
49		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_LocalResources/f:login.aspx.it.resx" caret="6822" scrollPosition="0\|128" />~~
50		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_LocalResources/f:login.aspx.pl.resx" caret="6881" scrollPosition="0\|128" />~~
51		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_LocalResources/f:login.aspx.resx" caret="6866" scrollPosition="0\|129" />~~
52		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:DummyGlobalAsax/f:Global.asax" caret="474" scrollPosition="0\|0" />~~
53		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx" caret="151" scrollPosition="27\|0" />~~
54		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:MasterPage.master" caret="328" scrollPosition="0\|0" />~~
55		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:MasterPage.master" caret="1783" scrollPosition="0\|21" />~~
56		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx" caret="157" scrollPosition="31\|0" />~~
57		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_Code/f:SendMail.cs" caret="1648" scrollPosition="0\|23" />~~
58		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:DummyGlobalAsax/f:Global.asax" caret="1330" scrollPosition="0\|0" />~~
59		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_Code/f:SendMail.cs" caret="1331" scrollPosition="0\|21" />~~
60		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx" caret="1273" scrollPosition="27\|0" />~~
61		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx" caret="1726" scrollPosition="0\|0" />~~
62		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="1033" scrollPosition="0\|21" />~~
63		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_Code/f:Web.Config" caret="2062" scrollPosition="0\|0" />~~
64		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="4549" scrollPosition="0\|98" />~~
65		~~<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx" caret="3701" scrollPosition="0\|24" />~~
66		~~<File id="d:Miscellaneous Files/f:Web.config" caret="559" scrollPosition="0\|0" />~~
67	40	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Merchant.aspx.cs" caret="7273" scrollPosition="0\|121" />
	41	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="1236" scrollPosition="0\|27" />
	42	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="2744" scrollPosition="0\|51" />
	43	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="2051" scrollPosition="0\|54" />
	44	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="2977" scrollPosition="0\|54" />
	45	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="3128" scrollPosition="0\|66" />
	46	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="90" scrollPosition="0\|0" />
	47	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="2333" scrollPosition="0\|39" />
	48	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/d:App_Code/f:Web.Config" caret="2042" scrollPosition="0\|0" />
	49	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="2102" scrollPosition="0\|101" />
	50	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="3950" scrollPosition="0\|137" />
	51	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:login.aspx.cs" caret="2909" scrollPosition="0\|45" />
	52	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="4897" scrollPosition="0\|162" />
	53	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="11536" scrollPosition="0\|323" />
	54	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Merchant.aspx.cs" caret="3377" scrollPosition="0\|57" />
	55	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Default.aspx.cs" caret="169" scrollPosition="0\|0" />
	56	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:Default.aspx.cs" caret="13" scrollPosition="0\|0" />
	57	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="11208" scrollPosition="0\|326" />
	58	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="1709" scrollPosition="0\|95" />
	59	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="3817" scrollPosition="0\|147" />
	60	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="12127" scrollPosition="0\|336" />
	61	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="969" scrollPosition="0\|69" />
	62	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="969" scrollPosition="0\|13" />
	63	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="2290" scrollPosition="0\|22" />
	64	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="10488" scrollPosition="0\|226" />
	65	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="3013" scrollPosition="0\|61" />
	66	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="3013" scrollPosition="0\|52" />
	67	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="3126" scrollPosition="0\|52" />
	68	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="4053" scrollPosition="0\|61" />
	69	<File id="F0F32C90-5ED1-4BB1-94B9-CC80CDC2A929/f:platnosc.aspx.cs" caret="5358" scrollPosition="0\|82" />
68	70	</RecentEdits>
69	71	</RecentFiles>
…	…
79	81	<ItemStatistics item="Qualified:@System.Data.SqlDbType">
80	82	<Item value="NVarChar" priority="1" />
	83	<Item value="Int" priority="0" />
81	84	</ItemStatistics>
82	85	<ItemStatistics item="Default">
83		<Item value="string" priority="1" />
84		<Item value="reader" priority="0" />
85		<Item value="Session" priority="1" />
	86	<Item value="string" priority="5" />
	87	<Item value="reader" priority="3" />
	88	<Item value="Session" priority="3" />
86	89	<Item value="systemKsiegowy" priority="1" />
87	90	<Item value="Int32" priority="0" />
…	…
91	94	<Item value="new" priority="0" />
92	95	<Item value="ApplicationException" priority="0" />
	96	<Item value="if" priority="0" />
	97	<Item value="return" priority="0" />
	98	<Item value="false" priority="1" />
	99	<Item value="conn" priority="0" />
	100	<Item value="bool" priority="0" />
	101	<Item value="true" priority="0" />
	102	<Item value="int" priority="2" />
	103	<Item value="Convert" priority="1" />
	104	<Item value="Response" priority="0" />
93	105	</ItemStatistics>
94	106	<ItemStatistics item="Qualified:System.Data.SqlClient.SqlDataReader">
95	107	<Item value="GetString" priority="0" />
96	108	<Item value="GetByte" priority="0" />
	109	<Item value="Read" priority="0" />
	110	<Item value="GetInt32" priority="0" />
	111	<Item value="Close" priority="0" />
	112	<Item value="Dispose" priority="0" />
97	113	</ItemStatistics>
98	114	<ItemStatistics item="Qualified:@System.Int32">
99		<Item value="Parse" priority="0" />
	115	<Item value="Parse" priority="1" />
100	116	</ItemStatistics>
101	117	<ItemStatistics item="Qualified:System.Object">
102		<Item value="ToString" priority="0" />
	118	<Item value="ToString" priority="11" />
103	119	</ItemStatistics>
104	120	<ItemStatistics item="Qualified:@System.Configuration.ConfigurationManager">
…	…
108	124	<Item value="ToString" priority="0" />
109	125	</ItemStatistics>
	126	<ItemStatistics item="Qualified:System.String">
	127	<Item value="Replace" priority="1" />
	128	<Item value="Trim" priority="0" />
	129	<Item value="Split" priority="0" />
	130	</ItemStatistics>
	131	<ItemStatistics item="Qualified:@System.String">
	132	<Item value="Empty" priority="1" />
	133	<Item value="IsNullOrEmpty" priority="0" />
	134	</ItemStatistics>
	135	<ItemStatistics item="Qualified:System.Data.SqlClient.SqlConnection">
	136	<Item value="Close" priority="0" />
	137	</ItemStatistics>
	138	<ItemStatistics item="Qualified:@System.Convert">
	139	<Item value="ToDecimal" priority="0" />
	140	<Item value="ToInt32" priority="0" />
	141	</ItemStatistics>
	142	<ItemStatistics item="Qualified:System.Decimal">
	143	<Item value="ToString" priority="0" />
	144	</ItemStatistics>
	145	<ItemStatistics item="Qualified:System.Web.HttpResponse">
	146	<Item value="Redirect" priority="0" />
	147	</ItemStatistics>
110	148	</CompletionStatisticsManager>
111	149	</Configuration>

Nawigacja

Zbiór zmian 486 dla trunk

Legenda:

Pobierz w innym formacie: