public IList <EntityCargoPaginacion> SelectPagging(ref EntityCargoPaginacion oEntityCargoPaginacion) { DataProcedure run = new DataProcedure(); run.CollectionParams.AddInputParameter("NombreCargo", oEntityCargoPaginacion.NombreCargo); run.CollectionParams.AddInputParameter("Estado", oEntityCargoPaginacion.Estado); run.CollectionParams.AddInputParameter("PageIndex", oEntityCargoPaginacion.EntityPaginacion.PageIndex); run.CollectionParams.AddInputParameter("PageSize", oEntityCargoPaginacion.EntityPaginacion.RowsPerPage); run.CollectionParams.AddOutputParameter("TotalRows"); IList <EntityCargoPaginacion> oListCargo = new List <EntityCargoPaginacion>(); using (IDataReader reader = run.ExecuteReader(CTransaction.Empty, Procedimientos.Cargo_Select_Paginado)) { while (reader.Read()) { oListCargo.Add(EntityCargoPaginacion.CreatePag(reader)); } } run.AssignReturnParameters(); oEntityCargoPaginacion.EntityPaginacion.RowCount = DataCreator.CreateInt32(run.CollectionParams.GetParameter("TotalRows").Value); return(oListCargo); }
//Добавление записи protected void btInsert_Click(object sender, EventArgs e) { if (Convert.ToInt32(DBConnection.idUser) == 0) { Response.Redirect("../AuthorizationPage.aspx"); } else { if (AmountCheck(ddlBooks.SelectedValue.ToString()) == "0") { lbBookAmount.Visible = true; } else { DataProcedure procedure = new DataProcedure(); DateTime theDate = DateTime.ParseExact(tbIssuance_Date.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string dateToInsert = theDate.ToString("dd.MM.yyyy"); DateTime theDate2 = DateTime.ParseExact(tbReturn_Date.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string dateToInsert2 = theDate2.ToString("dd.MM.yyyy"); procedure.OrderInsert(Convert.ToInt32(ddlBooks.SelectedValue.ToString()), dateToInsert, dateToInsert2, Convert.ToInt32(ddlStatus.SelectedValue.ToString()), Convert.ToInt32(ddlReaders.SelectedValue.ToString()), DBConnection.idUser); Cleaner(); ddlBooksFill(); lbBookAmount.Visible = false; gvFill(QR); } } }
//Регистрация для клиента protected void btRegistration_Click(object sender, EventArgs e) { DBConnection connection = new DBConnection(); //Проверка уникальности логина if (connection.LoginCheck(tbLogin.Text) > 0) { lblLoginCheck.Visible = true; } else { if (tbPasswordConfirm.Text.ToString() != tbPassword.Text.ToString()) { lbPasswordConfirm.Visible = true; } else { lblLoginCheck.Visible = false; lbPasswordConfirm.Visible = false; DataProcedure procedure = new DataProcedure(); procedure.UsersInsert(tbLogin.Text.ToString(), tbPassword.Text.ToString(), Convert.ToInt32(1), tbSurname.Text.ToString(), tbName.Text.ToString(), tbPhone.Text.ToString(), tbPassportNumber.Text.ToString(), tbPassportSeries.Text.ToString(), false); Response.Redirect("AuthorizationPage.aspx"); } } }
//Добавление записи protected void btInsert_Click(object sender, EventArgs e) { DBConnection connection = new DBConnection(); //Проверка уникальности логина if (connection.LoginCheck(tbLogin.Text) > 0) { lblLoginCheck.Visible = true; } else { lblLoginCheck.Visible = false; bool banState; if (cbBan.Checked) { banState = true; } else { banState = false; } DataProcedure procedure = new DataProcedure(); procedure.UsersInsert(tbLogin.Text.ToString(), tbPassword.ToString(), Convert.ToInt32(ddlRole.SelectedValue), tbSurname.Text.ToString(), tbName.Text.ToString(), tbPhone.Text.ToString(), tbPassportNumber.Text.ToString(), tbPassportSeries.Text.ToString(), banState); Cleaner(); gvFill(QR); } }
//Добавление записей protected void btInsert_Click(object sender, EventArgs e) { DataProcedure procedure = new DataProcedure(); if (Convert.ToInt32(tbAge.Text) < 18) { lblAgeCheck.Visible = true; } else { lblAgeCheck.Visible = false; bool educationCheck; if (cbEducation.Checked) { educationCheck = true; } else { educationCheck = false; } procedure.ProfileInsert(tbSurname.Text.ToString(), tbName.Text.ToString(), tbAge.Text.ToString(), tbPhone.Text.ToString(), educationCheck, Convert.ToInt32(ddlPosition.SelectedValue)); Cleaner(); gvFill(QR); } }
//Добавление записей protected void btInsert_Click(object sender, EventArgs e) { DataProcedure procedure = new DataProcedure(); procedure.PositionInsert(tbPositionName.Text.ToString(), Convert.ToDecimal(tbPay.Text.ToString())); Cleaner(); gvFill(QR); }
//Добавление записей protected void btInsert_Click(object sender, EventArgs e) { DataProcedure procedure = new DataProcedure(); procedure.GenreInsert(tbGenreName.Text.ToString()); Cleaner(); gvFill(QR); }
protected void gvOrders_RowDeleting(object sender, GridViewDeleteEventArgs e) { int Index = Convert.ToInt32(e.RowIndex); DataProcedure procedure = new DataProcedure(); DBConnection.idRecord = Convert.ToInt32(gvOrders.Rows[Index].Cells[1].Text.ToString()); procedure.OrderDelete(DBConnection.idRecord); gvFill(QR); }
//Удаление записи protected void gvEmployee_RowDeleting(object sender, GridViewDeleteEventArgs e) { int Index = Convert.ToInt32(e.RowIndex); DataProcedure procedure = new DataProcedure(); GridViewRow rows = gvEmployee.SelectedRow; DBConnection.idRecord = Convert.ToInt32(gvEmployee.Rows[Index].Cells[1].Text.ToString()); procedure.EmployeeListDelete(DBConnection.idRecord); gvFill(QR); }
protected void btInsert_Click(object sender, EventArgs e) { DateTime theDate = DateTime.ParseExact(tbData.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string dateToInsert = theDate.ToString("dd.MM.yyyy"); DataProcedure procedure = new DataProcedure(); procedure.TerminationContractInsert(dateToInsert, tbReason.Text.ToString(), Convert.ToInt32(ddlContract.SelectedValue.ToString())); Cleaner(); gvFill(QR); }
//Обновление записей protected void btUpdate_Click(object sender, EventArgs e) { DataProcedure procedure = new DataProcedure(); procedure.PositionUpdate(DBConnection.idRecord, tbPositionName.Text.ToString(), Convert.ToDecimal(tbPay.Text.ToString())); Cleaner(); gvFill(QR); btUpdate.Visible = false; SelectedMessage.Visible = false; DBConnection.idRecord = 0; }
//Обновление записей protected void btUpdate_Click(object sender, EventArgs e) { DataProcedure procedure = new DataProcedure(); procedure.GenreUpdate(DBConnection.idRecord, tbGenreName.Text.ToString()); Cleaner(); gvFill(QR); btUpdate.Visible = false; SelectedMessage.Visible = false; DBConnection.idRecord = 0; }
public Boolean Autenticar(EntityUsuario oEntityUsuario) { DataProcedure run = new DataProcedure(); run.CollectionParams.AddInputParameter("Usuario", oEntityUsuario.Usuario); run.CollectionParams.AddInputParameter("Clave", oEntityUsuario.Clave); CTransaction oCTransaction = CTransaction.Empty; Boolean result = false; result = Convert.ToBoolean(run.ExecuteScalar(oCTransaction, Procedimientos.Usuario_Autenticar)); return result; }
protected void btInsert_Click(object sender, EventArgs e) { if (flBookImage.PostedFile != null) { string imgfile = Path.GetFileName(flBookImage.PostedFile.FileName); flBookImage.SaveAs(Server.MapPath("../../Content/BooksImage/") + imgfile); DataProcedure procedure = new DataProcedure(); procedure.BookInsert(tbBookName.Text.ToString(), tbYear.Text.ToString(), Convert.ToInt32(tbAmount.Text.ToString()), "../../Content/BooksImage/" + imgfile, Convert.ToInt32(ddlGenre.SelectedValue), Convert.ToInt32(ddlAuthor.SelectedValue)); Cleaner(); gvFill(QR); } }
//Сохранить изменения protected void btSave_Click(object sender, EventArgs e) { lblLoginCheck.Visible = false; DataProcedure procedure = new DataProcedure(); procedure.UsersUpdate(DBConnection.idUser, tbLogin.Text.ToString(), 1, tbSurname.Text.ToString(), tbName.Text.ToString(), tbPhone.Text.ToString(), tbPassportNumber.Text.ToString(), tbPassportSeries.Text.ToString(), false); procedure.UsersUpdatePassword(DBConnection.idUser, tbPassword.Text.ToString()); tbPassword.Text = string.Empty; tbDisabled(); btEdit.Visible = true; btSave.Visible = false; btCansel.Visible = false; }
public EntityTienda SelectByKey(KeyTienda okey, CTransaction oCTransaction) { DataProcedure run = new DataProcedure(); run.CollectionParams.AddInputParameter("CodTienda", okey.CodTienda); using (IDataReader reader = run.ExecuteReader(oCTransaction, Procedimientos.Tienda_Select)) { if (reader.Read()) { return(EntityTienda.Create(reader)); } } return(EntityTienda.Empty); }
public EntityEmpresa SelectByKey(KeyEmpresa oKeyEmpresa, CTransaction oCTransaction) { DataProcedure run = new DataProcedure(); run.CollectionParams.AddInputParameter("IDEmpresa", oKeyEmpresa.IDEmpresa); using (IDataReader reader = run.ExecuteReader(oCTransaction, Procedimientos.Empresa_Select)) { if (reader.Read()) { return(EntityEmpresa.Create(reader)); } } return(EntityEmpresa.Empty); }
public EntityCargo SelectByKey(KeyCargo okey, CTransaction oCTransaction) { DataProcedure run = new DataProcedure(); run.CollectionParams.AddInputParameter("IDCargo", okey.IDCargo); using (IDataReader reader = run.ExecuteReader(oCTransaction, Procedimientos.Cargo_Select)) { if (reader.Read()) { return(EntityCargo.Create(reader)); } } return(EntityCargo.Empty); }
public EntityDetallePedido SelectByKey(KeyDetallePedido okey, CTransaction oCTransaction) { DataProcedure run = new DataProcedure(); run.CollectionParams.AddInputParameter("IDPedido", Entity.Key.IDPedido); run.CollectionParams.AddInputParameter("IDProducto", Entity.Key.IDProducto); using (IDataReader reader = run.ExecuteReader(oCTransaction, Procedimientos.DetallePedido_Select)) { if (reader.Read()) { return(EntityDetallePedido.Create(reader)); } } return(EntityDetallePedido.Empty); }
//Добавить книгу к заказу protected void btInsertOrder_Click(object sender, EventArgs e) { if (DBConnection.idUser == 0) { Response.Redirect("../AuthorizationPage.aspx"); } else { var btn = (Button)sender; //Get the repeater selected row var item = (RepeaterItem)btn.NamingContainer; //FInd the control from row var IdValue = ((Label)item.FindControl("lblID")).Text; DataProcedure procedure = new DataProcedure(); procedure.UserOrderInsert(Convert.ToInt32(IdValue), 3, DBConnection.idUser); } }
public EntityUsuario SelectByKey(Domain.Entities.Keys.KeyUsuario okey, CTransaction oCTransaction) { DataProcedure run = new DataProcedure(); run.CollectionParams.AddInputParameter("IDUsuario", okey.IDUsuario); using (IDataReader reader = run.ExecuteReader(oCTransaction, Procedimientos.Usuario_Select)) { if (reader.Read()) { return EntityUsuario.Create(reader); } } return EntityUsuario.Empty; }
//Добавление записей protected void btInsert_Click(object sender, EventArgs e) { string middleName; if (tbMiddleName.Text == "") { middleName = "Нет данных"; } else { middleName = tbMiddleName.Text.ToString(); } DataProcedure procedure = new DataProcedure(); procedure.AuthorInsert(tbSurname.Text.ToString(), tbName.Text.ToString(), middleName); Cleaner(); gvFill(QR); }
//Обновление записей protected void btUpdate_Click(object sender, EventArgs e) { string middleName; if (tbMiddleName.Text == "") { middleName = "Нет данных"; } else { middleName = tbMiddleName.Text.ToString(); } DataProcedure procedure = new DataProcedure(); procedure.AuthorUpdate(DBConnection.idRecord, tbSurname.Text.ToString(), tbName.Text.ToString(), middleName); Cleaner(); gvFill(QR); btUpdate.Visible = false; SelectedMessage.Visible = false; DBConnection.idRecord = 0; }
//Обновление записи protected void btUpdate_Click(object sender, EventArgs e) { bool educationCheck; if (cbEducation.Checked) { educationCheck = true; } else { educationCheck = false; } DataProcedure procedure = new DataProcedure(); procedure.ProfileUpdate(DBConnection.idRecord, tbSurname.Text.ToString(), tbName.Text.ToString(), tbAge.Text.ToString(), tbPhone.Text.ToString(), educationCheck, Convert.ToInt32(ddlPosition.SelectedValue)); Cleaner(); gvFill(QR); btUpdate.Visible = false; SelectedMessage.Visible = false; DBConnection.idRecord = 0; }
private void btDelete_Click(object sender, RoutedEventArgs e) { DataRowView ID = (DataRowView)dgLichnieDannieKlienta.SelectedItems[0]; switch (MessageBox.Show("Хотите удалить запись?", "Удаление!", MessageBoxButton.OKCancel, MessageBoxImage.Question)) { case MessageBoxResult.OK: DataProcedure procedure = new DataProcedure(); procedure.LichnieDannieKlientaDelete(Convert.ToInt32(ID["ID_InformationOKliente"])); procedure.spAuthorization_delete(Convert.ToInt32(ID["ID_Authorization"])); dgFill(QR); tbSurname.Text = ""; tbName.Text = ""; tbMiddleName.Text = ""; tbEmail.Text = ""; tbPhoneNumber.Text = ""; tbLogin.Text = ""; tbPassword.Text = ""; tbPasswordConfirm.Text = ""; break; } }
//Обновление записи protected void btUpdate_Click(object sender, EventArgs e) { GridViewRow rows = gvEmployee.SelectedRow; bool banCheck; if (cbDelete.Checked) { banCheck = true; } else { banCheck = false; } DateTime theDate = DateTime.ParseExact(tbContractDate.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string dateToInsert = theDate.ToString("dd.MM.yyyy"); DataProcedure procedure = new DataProcedure(); switch (cbPasswordChange.Checked) { case (true): procedure.EmployeeListUpdate(DBConnection.idRecord, tbLogin.Text.ToString(), Convert.ToInt32(ddlRole.SelectedValue), tbSurname.Text.ToString(), tbName.Text.ToString(), tbMiddleName.Text.ToString(), banCheck, dateToInsert, tbPassportNumber.Text.ToString(), tbPassportSeries.Text.ToString(), Convert.ToInt32(ddlPosition.SelectedValue.ToString())); procedure.EmployeeListPasswordUpdate(DBConnection.idRecord, tbPassword.Text.ToString()); break; case (false): procedure.EmployeeListUpdate(DBConnection.idRecord, tbLogin.Text.ToString(), Convert.ToInt32(ddlRole.SelectedValue), tbSurname.Text.ToString(), tbName.Text.ToString(), tbMiddleName.Text.ToString(), banCheck, dateToInsert, tbPassportNumber.Text.ToString(), tbPassportSeries.Text.ToString(), Convert.ToInt32(ddlPosition.SelectedValue.ToString())); break; } Cleaner(); gvFill(QR); btUpdate.Visible = false; SelectedMessage.Visible = false; cbPasswordChange.Visible = false; DBConnection.idRecord = 0; }
//Добавление записи protected void btInsert_Click(object sender, EventArgs e) { DBConnection connection = new DBConnection(); if (connection.LoginCheck(tbLogin.Text) > 0) { lblLoginCheck.Visible = true; } else { lblLoginCheck.Visible = false; bool banState; if (cbDelete.Checked) { banState = true; } else { banState = false; } string middleName; if (tbMiddleName.Text == "") { middleName = Convert.ToString(DBNull.Value); } else { middleName = tbMiddleName.Text.ToString(); } DateTime theDate = DateTime.ParseExact(tbContractDate.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string dateToInsert = theDate.ToString("dd.MM.yyyy"); DataProcedure procedure = new DataProcedure(); procedure.EmployeeListInsert(tbLogin.Text.ToString(), tbPassword.Text.ToString(), Convert.ToInt32(ddlRole.SelectedValue.ToString()), tbSurname.Text.ToString(), tbName.Text.ToString(), middleName, banState, dateToInsert, tbPassportNumber.Text.ToString(), tbPassportSeries.Text.ToString(), Convert.ToInt32(ddlPosition.SelectedValue.ToString())); Cleaner(); gvFill(QR); } }
//Обновление записи protected void btUpdate_Click(object sender, EventArgs e) { if (AmountCheck(ddlBooks.SelectedValue.ToString()) == "0" && ddlStatus.SelectedValue.ToString() != "2") { lbBookAmount.Visible = true; } else { DataProcedure procedure = new DataProcedure(); DateTime theDate = DateTime.ParseExact(tbIssuance_Date.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string dateToInsert = theDate.ToString("dd.MM.yyyy"); DateTime theDate2 = DateTime.ParseExact(tbReturn_Date.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string dateToInsert2 = theDate2.ToString("dd.MM.yyyy"); procedure.OrderUpdate(DBConnection.idRecord, Convert.ToInt32(ddlBooks.SelectedValue.ToString()), tbIssuance_Date.Text.ToString(), tbReturn_Date.Text.ToString(), Convert.ToInt32(ddlStatus.SelectedValue.ToString()), Convert.ToInt32(ddlReaders.SelectedValue.ToString())); Cleaner(); SelectedMessage.Visible = false; lbBookAmount.Visible = false; DBConnection.idRecord = 0; ddlBooksFill(); gvFill(QR); } }
//Обновить данные protected void btUpdate_Click(object sender, EventArgs e) { bool banCheck; if (cbBan.Checked) { banCheck = true; } else { banCheck = false; } DataProcedure procedure = new DataProcedure(); switch (cbPasswordChange.Checked) { case (true): RequiredFieldValidator7.Enabled = true; procedure.UsersUpdate(DBConnection.idRecord, tbLogin.Text.ToString(), Convert.ToInt32(ddlRole.SelectedValue), tbSurname.Text.ToString(), tbName.Text.ToString(), tbPhone.Text.ToString(), tbPassportNumber.Text.ToString(), tbPassportSeries.Text.ToString(), banCheck); procedure.UsersUpdatePassword(DBConnection.idRecord, tbPassword.Text.ToString()); break; case (false): RequiredFieldValidator7.Enabled = false; procedure.UsersUpdate(DBConnection.idRecord, tbLogin.Text.ToString(), Convert.ToInt32(ddlRole.SelectedValue), tbSurname.Text.ToString(), tbName.Text.ToString(), tbPhone.Text.ToString(), tbPassportNumber.Text.ToString(), tbPassportSeries.Text.ToString(), banCheck); break; } Cleaner(); gvFill(QR); btUpdate.Visible = false; SelectedMessage.Visible = false; cbPasswordChange.Visible = false; DBConnection.idRecord = 0; }
private void btUpdate_Click(object sender, RoutedEventArgs e) { switch (tbSurname.Text == "") { case (true): MessageBox.Show("Поле не может быть пустым!! " + "\n Заполните все поля и попробуйте снова!", "KitchenBase", MessageBoxButton.OK, MessageBoxImage.Warning); tbSurname.Background = Brushes.Red; break; case (false): tbSurname.Background = Brushes.White; switch (tbName.Text == "") { case (true): MessageBox.Show("Поле не может быть пустым!! " + "\n Заполните все поля и попробуйте снова!", "KitchenBase", MessageBoxButton.OK, MessageBoxImage.Warning); tbName.Background = Brushes.Red; break; case (false): tbName.Background = Brushes.White; switch (tbMiddleName.Text == "") { case (true): MessageBox.Show("Поле не может быть пустым!! " + "\n Заполните все поля и попробуйте снова!", "KitchenBase", MessageBoxButton.OK, MessageBoxImage.Warning); tbMiddleName.Background = Brushes.Red; break; case (false): tbMiddleName.Background = Brushes.White; switch (tbEmail.Text == "") { case (true): MessageBox.Show("Поле не может быть пустым!! " + "\n Заполните все поля и попробуйте снова!", "KitchenBase", MessageBoxButton.OK, MessageBoxImage.Warning); tbEmail.Background = Brushes.Red; break; case (false): tbEmail.Background = Brushes.White; switch (tbPhoneNumber.Text == "") { case (true): MessageBox.Show("Поле не может быть пустым!! " + "\n Заполните все поля и попробуйте снова!", "KitchenBase", MessageBoxButton.OK, MessageBoxImage.Warning); tbPhoneNumber.Background = Brushes.Red; break; case (false): tbPhoneNumber.Background = Brushes.White; switch (tbLogin.Text == "") { case (true): MessageBox.Show("Поле не может быть пустым!! " + "\n Заполните все поля и попробуйте снова!", "KitchenBase", MessageBoxButton.OK, MessageBoxImage.Warning); tbLogin.Background = Brushes.Red; break; case (false): tbLogin.Background = Brushes.White; switch (tbPassword.Text == "") { case (true): MessageBox.Show("Поле не может быть пустым!! " + "\n Заполните все поля и попробуйте снова!", "KitchenBase", MessageBoxButton.OK, MessageBoxImage.Warning); tbPassword.Background = Brushes.Red; break; case (false): tbPassword.Background = Brushes.White; switch (tbPasswordConfirm.Text == "") { case (true): MessageBox.Show("Поле не может быть пустым!! " + "\n Заполните все поля и попробуйте снова!", "KitchenBase", MessageBoxButton.OK, MessageBoxImage.Warning); tbPasswordConfirm.Background = Brushes.Red; break; case (false): DBConnection connection = new DBConnection(); //Проверка уникальности логина tbPasswordConfirm.Background = Brushes.White; DataRowView ID = (DataRowView)dgLichnieDannieKlienta.SelectedItems[0]; DataProcedure procedures = new DataProcedure(); procedures.UsersRegistrationUpdate(Convert.ToInt32(ID["ID_InformationOKliente"]), tbLogin.Text.ToString(), tbPassword.Text.ToString(), tbName.Text.ToString(), tbSurname.Text.ToString(), tbMiddleName.Text.ToString(), tbEmail.Text.ToString(), tbPhoneNumber.Text.ToString()); dgFill(QR); tbSurname.Text = ""; tbName.Text = ""; tbMiddleName.Text = ""; tbEmail.Text = ""; tbPhoneNumber.Text = ""; tbLogin.Text = ""; tbPassword.Text = ""; tbPasswordConfirm.Text = ""; break; } break; } break; } break; } break; } break; } break; } break; } }