//Регистрация
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(tbFamiliya.Text.ToString(), tbName.Text.ToString(), tbOtchestvo.Text.ToString(),
tbLogin.Text.ToString(), tbPassword.Text.ToString(), 1);
Response.Redirect("Authorization.aspx");
}
}
}
protected void btInsert_Click(object sender, EventArgs e)
{
int ArendaID;
SqlCommand command = new SqlCommand("", DBConnection.connection);
if (DBConnection.userID == 0)
{
Response.Redirect("Authorization.aspx");
}
else
{
decimal Cost;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "SELECT (Cena) FROM [Tovari] where [ID_Tovara] = " + Convert.ToInt32(ddlTovari.SelectedValue) + "";
DBConnection.connection.Open();
Cost = Convert.ToDecimal(command.ExecuteScalar().ToString());
command.ExecuteNonQuery();
DBConnection.connection.Close();
int Sum = Convert.ToInt32(tbKolichestvo.Text) * Convert.ToInt32(Cost);
string time = DateTime.Now.ToString("h:mm");
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.Arenda_Insert(Convert.ToInt32(ddlTovari.SelectedValue), Convert.ToInt32(tbKolichestvo.Text), Convert.ToInt32(ddlKlienti.SelectedValue), Convert.ToDecimal(Sum));
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "SELECT MAX(ID_Order) FROM [Order]";
DBConnection.connection.Open();
ArendaID = Convert.ToInt32(command.ExecuteScalar().ToString());
command.ExecuteNonQuery();
DBConnection.connection.Close();
gvFill(QR);
}
}
protected void btUpdate_Click(object sender, EventArgs e)
{
DBProcedures dBProcedures = new DBProcedures();
dBProcedures.Kategorii_Update(DBConnection.selectedRow, tbName.Text);
tbName.Text = "";
gvFill(QR);
}
protected void btInsert_Click(object sender, EventArgs e)
{
DBProcedures dBProcedures = new DBProcedures();
dBProcedures.Kategorii_Insert(tbName.Text);
tbName.Text = "";
gvFill(QR);
}
protected void btDelete_Click(object sender, EventArgs e)
{
DBProcedures dBProcedures = new DBProcedures();
dBProcedures.Tovari_Delete(DBConnection.selectedRow);
DBConnection.selectedRow = 0;
gvFill(QR);
DeleteDate();
}
protected void btInsert_Click(object sender, EventArgs e)
{
DBProcedures dBProcedures = new DBProcedures();
dBProcedures.Tovari_Insert(tbNazvanie.Text.ToString(), Convert.ToInt32(tbKolichestvo.Text.ToString()),
Convert.ToDecimal(tbCena.Text.ToString()), Convert.ToInt32(ddlKategorii.SelectedValue));
gvFill(QR);
DeleteDate();
}
protected void btUpdate_Click(object sender, EventArgs e)
{
DateTime theDate = DateTime.ParseExact(tbData_Yvolneniya.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
string date = theDate.ToString("dd.MM.yyyy");
DBProcedures dBProcedures = new DBProcedures();
dBProcedures.Yvolnenie_Update(DBConnection.selectedRow, tbPrichina_yvolneniya.Text, Convert.ToInt32(ddlSotrydniki.SelectedValue.ToString()), date);
gvFill(QR);
DeleteDate();
}
protected void btUpdate_Click(object sender, EventArgs e)
{
DBProcedures dBProcedures = new DBProcedures();
dBProcedures.Sotrydniki_Update(DBConnection.selectedRow, tbFamiliya.Text, tbName.Text, tbOtchestvo.Text, tbLogin.Text, DBConnection.contractID, tbPassword.Text, false,
Convert.ToInt32(ddlRole.SelectedValue.ToString()));
gvFill(QR);
DeleteDate();
DBConnection.contractID = 0;
DBConnection.selectedRow = 0;
}
protected void btDelete_Click(object sender, EventArgs e)
{
SqlCommand command = new SqlCommand("", DBConnection.connection);
if (DBConnection.selectedRow != 0)
{
DBProcedures dBProcedures = new DBProcedures();
dBProcedures.Arenda_Delete(DBConnection.selectedRow);
DeleteData();
}
gvFill(QR);
}
protected void btUpdate_Click(object sender, EventArgs e)
{
DBProcedures dBProcedures = new DBProcedures();
SqlCommand command = new SqlCommand("", DBConnection.connection);
string time = DateTime.Now.ToString("h:mm");
DateTime theDate = DateTime.ParseExact(tbDate.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
string date = theDate.ToString("dd.MM.yyyy");
dBProcedures.Arenda_Update(DBConnection.selectedRow, Convert.ToInt32(ddlTovari.SelectedValue), Convert.ToInt32(tbKolichestvo.Text), Convert.ToInt32(ddlKlienti.SelectedValue));
command.CommandType = System.Data.CommandType.Text;
DBConnection.connection.Open();
gvFill(QR);
DeleteData();
}
protected void btInsert_Click(object sender, EventArgs e)
{
DBConnection connection = new DBConnection();
if (connection.UnqLogin(tbLogin.Text) != 0)
{
lblError.Visible = true;
}
else
{
lblError.Visible = false;
DBProcedures dBProcedures = new DBProcedures();
dBProcedures.Sotrydniki_Insert(tbFamiliya.Text, tbName.Text, tbOtchestvo.Text, tbLogin.Text, tbPassword.Text, Convert.ToInt32(ddlRole.SelectedValue.ToString()));
gvFill(QR);
DeleteDate();
}
}
protected void btInsert_Click(object sender, EventArgs e)
{
SqlCommand command = new SqlCommand("", DBConnection.connection);
int orderID;
DateTime theDate = DateTime.ParseExact(tbData_Yvolneniya.Text, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
string date = theDate.ToString("dd.MM.yyyy");
DBProcedures dBProcedures = new DBProcedures();
dBProcedures.Yvolnenie_Insert(tbPrichina_yvolneniya.Text, Convert.ToInt32(ddlSotrydniki.SelectedValue.ToString()), date);
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "SELECT MAX(ID_Fired_Order) FROM [Fired_Order]";
DBConnection.connection.Open();
orderID = Convert.ToInt32(command.ExecuteScalar().ToString());
command.ExecuteNonQuery();
DBConnection.connection.Close();
gvFill(QR);
DeleteDate();
}
protected void gvTovari_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
decimal Cymma;
GridViewRow rows = gvTovari.SelectedRow;
DBConnection.selectedRow = Convert.ToInt32(rows.Cells[1].Text);
Cymma = Convert.ToDecimal(rows.Cells[4].Text);
DBProcedures dBProcedures = new DBProcedures();
dBProcedures.Arenda_Insert(DBConnection.selectedRow, 1, DBConnection.userID, Cymma);
}
catch
{
}
finally
{
gvFill(QR);
DBConnection.selectedRow = 0;
}
}
