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;
}
}
