public void ButtonSave_Click(object sender, EventArgs e) { if (!BaseConnection.openConnection()) { return; } string command = "select * from (select Name from Contractors inner join Users on Contractors.Id_User = Users.id where Users.id =" + Session["User"] + ") as tabelka where tabelka.Name = '" + TextBoxName.Text + "'; "; // check if already added if (BaseConnection.execScalar(command) != null) { BaseConnection.closeConnection(); string title = "Błąd"; string body = "Kontrahent o takiej nazwie już isnieje!"; ClientScript.RegisterStartupScript(this.GetType(), "Popup", "showModalError('" + title + "', '" + body + "');", true); return; } Dictionary <string, string> pair = new Dictionary <string, string>(); pair.Add("@userId", Session["User"].ToString()); pair.Add("@name", TextBoxName.Text); pair.Add("@postTown", TextBoxPostTown.Text); pair.Add("@postCode", TextBoxPostCode.Text); pair.Add("@city", TextBoxCity.Text); pair.Add("@street", TextBoxStreet.Text); if (!String.IsNullOrEmpty(TextBoxNIP.Text)) { pair.Add("@nip", TextBoxNIP.Text); } else { pair.Add("@nip", "null"); } pair.Add("@regon", "null"); if (!String.IsNullOrEmpty(TextBoxPESEL.Text)) { pair.Add("@pesel", TextBoxPESEL.Text); } else { pair.Add("@pesel", "null"); } BaseConnection.execProcedure("AddContractor", pair); BaseConnection.closeConnection(); Response.Redirect("Contractors.aspx"); }
public GenerateInvoice(int idUser, int invoiceId, string nr) { _stringWriter = new StringWriter(); _writer = new HtmlTextWriter(_stringWriter); _idInvoice = invoiceId; _nr = nr; _idUser = idUser; if (!BaseConnection.openConnection()) { return; } string query = "select Id_contractor from Invoices where Id =" + invoiceId; _idContractor = (int)BaseConnection.execScalar(query); BaseConnection.closeConnection(); }
protected void ButtonAddProduct_Click(object sender, EventArgs e) { if (!BaseConnection.openConnection()) { return; } string command = "select * from Products where Name='" + TextBoxName.Text + "' and Id_user="******"User"]; if (BaseConnection.execScalar(command) != null) { BaseConnection.closeConnection(); string title = "Błąd"; string body = "Taki produkt już istnieje!"; ClientScript.RegisterStartupScript(this.GetType(), "Popup", "showModalError('" + title + "', '" + body + "');", true); return; } command = "insert into Products values (" + Session["User"] + ",'" + TextBoxName.Text + "'," + DropDownListUnit.SelectedValue + " )"; if ((int)BaseConnection.execCommand(command) == 1) { LabelError.Text = "Produkt dodany"; LabelError.CssClass = "text-success"; LabelError.Visible = true; } else { LabelError.Text = "Nie udało się dodać do bazy"; LabelError.CssClass = "text-danger"; LabelError.Visible = true; } BaseConnection.closeConnection(); Response.Redirect("Product.aspx"); }