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