protected void Page_Load(object sender, EventArgs e) { conn = new SqlConnection( ConfigurationManager.ConnectionStrings["MySchoolCommunityConnectionString"].ConnectionString); proc = new DBProcedures(); LoggedinLiteral.Text = Login.currentlyLoggedIn; }
protected void btInsert_Click(object sender, EventArgs e) { int orderID; SqlCommand command = new SqlCommand("", DBConnection.connection); if (DBConnection.userID == 0) { Response.Redirect("AuthorizationPage.aspx"); } else { decimal Cost; command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT (Price) FROM [Product] where [ID_Product] = " + Convert.ToInt32(ddlProduct.SelectedValue) + ""; DBConnection.connection.Open(); Cost = Convert.ToDecimal(command.ExecuteScalar().ToString()); command.ExecuteNonQuery(); DBConnection.connection.Close(); int Sum = Convert.ToInt32(tbQuantity.Text) * Convert.ToInt32(Cost); string time = DateTime.Now.ToString("h:mm"); DateTime theDate = DateTime.ParseExact(tbSaledDate.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string date = theDate.ToString("dd.MM.yyyy"); DBProcedures dBProcedures = new DBProcedures(); dBProcedures.Order_Insert(Convert.ToInt32(ddlProduct.SelectedValue), Convert.ToInt32(tbQuantity.Text), Convert.ToInt32(ddlClient.SelectedValue), Convert.ToDecimal(Sum)); command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT MAX(ID_Order) FROM [Order]"; DBConnection.connection.Open(); orderID = Convert.ToInt32(command.ExecuteScalar().ToString()); command.ExecuteNonQuery(); DBConnection.connection.Close(); dBProcedures.Check_Insert(time, date, DBConnection.userID, orderID); DeleteData(); gvFill(QR); } }
protected void Page_Load(object sender, EventArgs e) { procedures = new DBProcedures(); connection = new SqlConnection (@"Data Source=OMAR-PC\SQLEXPRESS;Initial Catalog=MySchoolCommunity;Integrated Security=True"); LoggedinLiteral.Text = Login.currentlyLoggedIn; }
protected void btUpdate_Click(object sender, EventArgs e) { int checkID; //Проверка доставерности номера чека SqlCommand command = new SqlCommand("", DBConnection.connection); command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT [ID_Check] FROM [Check] where [Check_Number] like '%" + tbNumber.Text + "%'"; DBConnection.connection.Open(); try { checkID = Convert.ToInt32(command.ExecuteScalar().ToString()); } catch { checkID = 0; } command.ExecuteNonQuery(); DBConnection.connection.Close(); if (checkID == 0) { lblError.Visible = true; } else { lblError.Visible = false; lblUqnError.Visible = false; DateTime theDate = DateTime.ParseExact(tbDate.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string date = theDate.ToString("dd.MM.yyyy"); DBProcedures dBProcedures = new DBProcedures(); dBProcedures.Return_List_Update(DBConnection.selectedRow, date, checkID, tbReason.Text); gvFill(QR); DeleteData(); } }
protected void btInsert_Click(object sender, EventArgs e) { string Comment; if (DBConnection.idUser == 0) { Response.Redirect("Authorization.aspx"); } else { if (tbComment.Text == "") { Comment = Convert.ToString(DBNull.Value); } else { Comment = tbComment.Text.ToString(); } DBProcedures procedures = new DBProcedures(); DateTime theDate = DateTime.ParseExact(tbDate.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string dateToInsert = theDate.ToString("dd.MM.yyyy"); procedures.InformationOBronirovanieInsert(Convert.ToInt32(ddlNumber.SelectedValue), dateToInsert, false, Convert.ToInt32(tbQuantity.Text), Comment, Convert.ToInt32(ddlTime.SelectedValue)); procedures.KlientBronirovanieInsert(DBConnection.idUser); Cleaner(); gvFill(QR); } }
//Подтверждение заказа protected void btConfirm_Click(object sender, EventArgs e) { DBProcedures procedures = new DBProcedures(); procedures.RabotaKuhni_Update(DBConnection.idRecord); Response.Redirect("Orders.aspx"); }
protected void Page_Load(object sender, EventArgs e) { LoggedinLiteral.Text = Login.currentlyLoggedIn; uid = Convert.ToInt32(Page.Request.QueryString["uid"]); type = Page.Request.QueryString["type"]; procedures = new DBProcedures(); }
protected void btInsert_Click(object sender, EventArgs e) { if (DBConnection.idPersonal == 0) { Response.Redirect("Authorization.aspx"); } else { string Comment; int Sum; //Сумма заказа if (tbComment.Text == "") { Comment = Convert.ToString(DBNull.Value); } else { Comment = tbComment.Text.ToString(); } Sum = Convert.ToInt32(tbQuantity.Text) * Convert.ToInt32(tbPrice.Text); DBProcedures procedures = new DBProcedures(); procedures.ObslujivanieKlientaInsert(Convert.ToInt32(tbQuantity.Text), Comment, tbTime.Text, Sum, DBConnection.idPersonal, Convert.ToInt32(ddlNameBluda.SelectedValue), Convert.ToInt32(tbNumber.Text)); gvFill(QR); Cleaner(); } }
private void BtEnter_Click(object sender, RoutedEventArgs e) { DBProcedures procedures = new DBProcedures(); Int32 ID_Record = procedures.Authorization(tbEnterLogin.Password.ToString(), tbEnterPassword.Password.ToString()); switch (ID_Record) { case (0): tbEnterLogin.Clear(); tbEnterPassword.Clear(); MessageBox.Show("Данные не верны! " + "\n Повторите попытку ввода!", "NightCrow", MessageBoxButton.OK, MessageBoxImage.Warning); break; default: DBConnection.IDuser = ID_Record; Menu Menu = new Menu(); Menu.Show(); Visibility = Visibility.Collapsed; break; } }
//Регистрация protected void btEnter_Click(object sender, EventArgs e) { DBConnection connection = new DBConnection(); //Проверка уникальности логина if (connection.LoginCheck(tbLogin.Text) > 0 & tbLogin.Text != "") { lblLoginCheck.Visible = true; } else { if (tbPassword.Text != tbPasswordConfirm.Text) { lblPasswordConfirm.Visible = true; } else { lblLoginCheck.Visible = false; lblPasswordConfirm.Visible = false; DBProcedures procedures = new DBProcedures(); procedures.UsersRegistration(tbLogin.Text.ToString(), tbPassword.Text.ToString(), tbName.Text.ToString(), tbSurname.Text.ToString(), tbMiddleName.Text.ToString(), tbEmail.Text.ToString(), tbPhone.Text.ToString()); Response.Redirect("Authorization.aspx"); } } }
//Регистрация protected void btEnter_Click(object sender, EventArgs e) { DBConnection connection = new DBConnection(); if (connection.UnqLogin(tbLogin.Text) != 0) { lblLogin.Visible = true; } else { lblLogin.Visible = true; if (tbPassword.Text != tbPasswordConfirm.Text) { tbPassword.BackColor = System.Drawing.Color.Red; tbPasswordConfirm.BackColor = System.Drawing.Color.Red; } else { tbPassword.BackColor = System.Drawing.Color.White; tbPasswordConfirm.BackColor = System.Drawing.Color.White; DBProcedures dBProcedures = new DBProcedures(); dBProcedures.RegistrationUsers(tbSurname.Text.ToString(), tbName.Text.ToString(), tbMiddleName.Text.ToString(), tbLogin.Text.ToString(), tbPassword.Text.ToString(), 1); Response.Redirect("AuthorizationPage.aspx"); } } }
protected void btDelete_Click(object sender, EventArgs e) { DBProcedures dBProcedures = new DBProcedures(); dBProcedures.Type_Delete(DBConnection.selectedRow); tbName.Text = ""; gvFill(QR); }
private void btTypeOfContract_Click(object sender, RoutedEventArgs e) { DBProcedures procedures = new DBProcedures(); FormTypeOfContract FormTypeOfContract = new FormTypeOfContract(); FormTypeOfContract.Show(); Close(); }
private void btStaff_Click(object sender, RoutedEventArgs e) { DBProcedures procedures = new DBProcedures(); FormStaff FormStaff = new FormStaff(); FormStaff.Show(); Close(); }
private void btService_Click(object sender, RoutedEventArgs e) { DBProcedures procedures = new DBProcedures(); FormService FormService = new FormService(); FormService.Show(); Close(); }
private void btPosition_Click(object sender, RoutedEventArgs e) { DBProcedures procedures = new DBProcedures(); FormPosition FormPosition = new FormPosition(); FormPosition.Show(); Close(); }
private void btCustomer_Click(object sender, RoutedEventArgs e) { DBProcedures procedures = new DBProcedures(); FormCustomers FormCustomers = new FormCustomers(); FormCustomers.Show(); Close(); }
private void btBase_Click(object sender, RoutedEventArgs e) { DBProcedures procedures = new DBProcedures(); FormBase FormBase = new FormBase(); FormBase.Show(); Close(); }
protected void btInsert_Click(object sender, EventArgs e) { DBProcedures dBProcedures = new DBProcedures(); dBProcedures.Type_Insert(tbName.Text); tbName.Text = ""; gvFill(QR); }
//Оформление заказа protected void btCheckout_Click(object sender, EventArgs e) { DBProcedures procedures = new DBProcedures(); procedures.RabotaKuhni_Insert(DBConnection.idRecord); Cleaner(); gvFill(QR); }
private void BtBack_Click(object sender, RoutedEventArgs e) { DBProcedures procedures = new DBProcedures(); Menu Menu = new Menu(); Menu.Show(); Close(); }
protected void btDelete_Click(object sender, EventArgs e) { DBProcedures procedures = new DBProcedures(); procedures.ObslujivanieKlientaDelete(DBConnection.idRecord); gvFill(QR); Cleaner(); }
protected void btInsert_Click(object sender, EventArgs e) { int checkID, unqCheckID; //Проверка доставерности номера чека SqlCommand command = new SqlCommand("", DBConnection.connection); command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT [ID_Check] FROM [Check] where [Check_Number] like '%" + tbNumber.Text + "%'"; DBConnection.connection.Open(); try { checkID = Convert.ToInt32(command.ExecuteScalar().ToString()); } catch { checkID = 0; } command.ExecuteNonQuery(); DBConnection.connection.Close(); if (checkID == 0) { lblError.Visible = true; lblUqnError.Visible = false; } else { //Проверка, были уже добавлен чек в таблицу возврата command.CommandType = System.Data.CommandType.Text; command.CommandText = "select [Check_ID] from [Return_List] inner join [Check] on [ID_Check] = [Check_ID] where [Check_Number] like '%" + tbNumber.Text + "%'"; DBConnection.connection.Open(); command.ExecuteNonQuery(); try { unqCheckID = Convert.ToInt32(command.ExecuteScalar().ToString()); } catch { unqCheckID = 0; } DBConnection.connection.Close(); if (unqCheckID != 0) { lblError.Visible = false; lblUqnError.Visible = true; } else { lblError.Visible = false; lblUqnError.Visible = false; string date = DateTime.Now.ToString("dd.MM.yyyy"); DBProcedures dBProcedures = new DBProcedures(); dBProcedures.Return_List_Insert(date, checkID, tbReason.Text); gvFill(QR); DeleteData(); } } }
protected void Page_Load(object sender, EventArgs e) { conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MySchoolCommunityConnectionString"].ConnectionString); proc = new DBProcedures(); creator = Convert.ToInt32(Page.Request.QueryString["creator"]); rname = Page.Request.QueryString["rname"]; uid = Page.Request.QueryString["uid"]; LoggedinLiteral.Text = Login.currentlyLoggedIn; }
protected void btDelete_Click(object sender, EventArgs e) { DBProcedures procedures = new DBProcedures(); procedures.KlientBronirovanieDelete(DBConnection.idRecord); procedures.InformationOBronirovanieDelete(DBConnection.idRecord); Cleaner(); gvFill(QR); }
protected void btInsert_Click(object sender, EventArgs e) { DBProcedures dBProcedures = new DBProcedures(); dBProcedures.Product_Insert(tbName.Text.ToString(), Convert.ToInt32(tbQuantity.Text.ToString()), Convert.ToDecimal(tbPrice.Text.ToString()), Convert.ToInt32(ddlType.SelectedValue)); gvFill(QR); DeleteDate(); }
protected void btDelete_Click(object sender, EventArgs e) { DBProcedures dBProcedures = new DBProcedures(); dBProcedures.Product_Delete(DBConnection.selectedRow); DBConnection.selectedRow = 0; gvFill(QR); DeleteDate(); }
protected void Page_Load(object sender, EventArgs e) { connection = new SqlConnection(@"Data Source=OMAR-PC\SQLEXPRESS;Initial Catalog=MySchoolCommunity;Integrated Security=True"); procedures = new DBProcedures(); if (Page.Request.QueryString["redirect"] != null) { redirect = true; } }
protected void btUpdate_Click(object sender, EventArgs e) { DateTime theDate = DateTime.ParseExact(tbDate.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string date = theDate.ToString("dd.MM.yyyy"); DBProcedures dBProcedures = new DBProcedures(); dBProcedures.Fired_Order_Update(DBConnection.selectedRow, tbReason.Text, Convert.ToInt32(ddlEmployee.SelectedValue.ToString()), date); gvFill(QR); DeleteDate(); }
protected void btUpdate_Click(object sender, EventArgs e) { DBProcedures dBProcedures = new DBProcedures(); dBProcedures.Product_Update(DBConnection.selectedRow, tbName.Text.ToString(), Convert.ToInt32(tbQuantity.Text.ToString()), Convert.ToDecimal(tbPrice.Text.ToString()), Convert.ToInt32(ddlType.SelectedValue)); gvFill(QR); DeleteDate(); DBConnection.selectedRow = 0; }