//aktualizacj naglowka WZ
public void fAktualizujWZGlowka(string sIDWz, string sNetto, string sVat, string sBrutto)
{
//string sReturn = "Error";
string query = "update GM_WZ set " +
"WAL_WARTOSC_NETTO = " + sNetto.Replace(",", ".") + ", " +
"WAL_KWOTA_VAT = " + sVat.Replace(",", ".") + ", " +
"WAL_WARTOSC_BRUTTO = " + sBrutto.Replace(",", ".") + ", " +
"PLN_WARTOSC_NETTO = " + sNetto.Replace(",", ".") + ", " +
"WARTOSC_ROZRACHUNKU = " + sBrutto.Replace(",", ".") + ", " +
"PLN_KWOTA_VAT = " + sVat.Replace(",", ".") + ", " +
"PLN_WARTOSC_BRUTTO = " + sBrutto.Replace(",", ".") + " " +
" where (ID = " + sIDWz + ") ";
//Open connection
if (this.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
FbCommand cmd = new FbCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
this.CloseConnection();
}
fbLogowanie = new fblog();
fbLogowanie.sLOG(settings.IDLogin, settings.osoba, "2", settings.login, settings.pass, query);
}
public void fAktualizujWZStawkiVat(string sIDWz, string sNetto, string sVat, string sBrutto)
{
//string sReturn = "Error";
string query = "update GM_SPRZEDAZ_VAT set " +
"NETTO = " + sNetto.Replace(",",".") + ", " +
"VAT = " + sVat.Replace(",", ".") + ", " +
"BRUTTO = " + sBrutto.Replace(",", ".") + " " +
" where (ID_WZ = " + sIDWz + ") ";
//Open connection
if (this.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
FbCommand cmd = new FbCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
this.CloseConnection();
}
fbLogowanie = new fblog();
fbLogowanie.sLOG(settings.IDLogin, settings.osoba, "2", settings.login, settings.pass, query);
}
public void fAktualizujWZPoz(string sIDPoz, string sNetto, string sBrutto)
{
//string sReturn = "Error";
string query = "update GM_WZPOZ set " +
"CENA_SPRZEDAZY_PO = " + sNetto.Replace(",", ".") + ", " +
"CENA_NETTO_SPRZ_PO_RAB_PO = " + sNetto.Replace(",", ".") + ", " +
"CENA_SPRZ_WAL_PO_RAB_PO = " + sNetto.Replace(",", ".") + ", " +
"CENA_SP_NETTO_ALT_PO = " + sNetto.Replace(",", ".") + ", " +
"CENA_SP_PLN_ALT_PO = " + sNetto.Replace(",", ".") + ", " +
"CENA_KATALOGOWA = " + sNetto.Replace(",", ".") + ", " +
"CENA_BRUTTO_SPRZ_PO_RAB_PO = " + sBrutto.Replace(",", ".") + ", " +
"CENA_SP_BRUTTO_ALT_PO = " + sBrutto.Replace(",", ".") + " " +
" where (ID = " + sIDPoz + ") ";
//Open connection
if (this.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
FbCommand cmd = new FbCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
this.CloseConnection();
}
fbLogowanie = new fblog();
fbLogowanie.sLOG(settings.IDLogin, settings.osoba, "2", settings.login, settings.pass, query);
}
private void button2_Click(object sender, EventArgs e)
{
//InitializeConnStr();
string sLogin = ""; string sPass = "";
//if (textBox3.Text != "0")
//{
// sLogin = "******";
// sPass = "******";
//}
//else
//{
sLogin = textBox1.Text;
sPass = textBox2.Text;
//}
fbLogowanie = new fblog();
List<string>[] lstLogin = fbLogowanie.sLogowanie(sLogin, sPass);
if (lstLogin[0].Count == 0)
{
MessageBox.Show("Nie znaleziono użytkownika. \r\n Spróbuj ponownie.");
fbLogowanie.sLOGErr(sLogin, sPass);
textBox2.Text = "";
return;
}
if (lstLogin[4][0].ToString() == "0")
{
MessageBox.Show("Użytkownik " + sLogin + " ma wyłaczone konto\nSkontaktuj się z administratorem");
fbLogowanie.sLOGErr(sLogin, sPass, true);
textBox2.Text = "";
return;
}
fbLogowanie.sLOG(lstLogin[0][0].ToString(),lstLogin[3][0].ToString(),"1",sLogin, sPass);
settings.IDLogin = lstLogin[0][0].ToString();
settings.osoba = lstLogin[3][0].ToString();
settings.login = sLogin;
settings.pass = sPass;
settings.Save();
//frmWZ = new zt();
//frmWZ.Show();
frmZnaczniki = new znaczniki();
frmZnaczniki.Show();
this.Visible = false;
//this.Close();
}
