protected void Save_btn_click(object sender, EventArgs e)
{
using (SqlConnection Conn = new SqlConnection())
{
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = Conn;
SqlCommand Comm2 = new SqlCommand();
Comm2.Connection = Conn;
if (ObjectID_hf.Value.Length != 0 && ObjectID_hf.Value != "-1")
{
Comm.CommandText = @"UPDATE ORDERS SET STATUS_TYPE=@STATUS_TYPE,
PROBLEM_DESC=@PROBLEM_DESC
WHERE
ID=@ID";
Comm.Parameters.Add("@ID", SqlDbType.Int);
Comm.Parameters["@ID"].Value = ObjectID_hf.Value;
Comm.Parameters.Add("@PROBLEM_DESC", SqlDbType.NVarChar);
Comm.Parameters["@PROBLEM_DESC"].Value = problem_txt.Text;
Comm.Parameters.Add("@STATUS_TYPE", SqlDbType.NVarChar);
Comm.Parameters["@STATUS_TYPE"].Value = order_status_ddl.SelectedValue;
Comm2.CommandText = @"UPDATE ORDER_EDITING SET
TEXT='EDITTED'
WHERE ORDER_ID=@ID AND USER_ID=@USER_ID";
Comm2.Parameters.Add("@ID", SqlDbType.Int);
Comm2.Parameters["@ID"].Value = ObjectID_hf.Value;
Comm2.Parameters.Add("@USER_ID", SqlDbType.Int);
Comm2.Parameters["@USER_ID"].Value = AuthCookieParse.UserID();
}
Conn.Open();
try
{
Comm.ExecuteNonQuery();
Comm2.ExecuteNonQuery();
}
catch (SqlException E)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Səhv aşkarlandi', ''); $(\"#close_btn\").click();} );</script>", false);
return;
}
ObjectsGrid.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Təsdiq edildi', '');$(\"#close_btn\").click();});</script>", false);
}
}
protected void ObjectsGrid_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "DELETE_Name")
{
using (SqlConnection Conn = new SqlConnection())
{
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = Conn;
Comm.Parameters.Add("@ID", SqlDbType.Int);
Comm.Parameters["@ID"].Value = e.CommandArgument;
Comm.CommandText = @"DELETE FROM PAYMENT WHERE ID = @ID";
Conn.Open();
try { Comm.ExecuteNonQuery(); }
catch (SqlException E)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Səhv aşkarlandi', ''); $(\"#close_btn\").click();} );</script>", false);
return;
}
ObjectsGrid.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Təsdiq edildi', '');$(\"#close_btn\").click();});</script>", false);
}
}
}
protected void Save_btn_click(object sender, EventArgs e)
{
using (SqlConnection Conn = new SqlConnection())
{
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = Conn;
if (ObjectID_hf.Value.Length != 0 && ObjectID_hf.Value != "-1")
{
Comm.CommandText = @"UPDATE PACKAGE SET
NAME = @NAME,
PRICE=@PRICE,
VALYUTA_ID=@VALYUTA_ID,
POINT=@POINT
WHERE
ID = @ID";
Comm.Parameters.Add("@ID", SqlDbType.Int);
Comm.Parameters["@ID"].Value = ObjectID_hf.Value;
}
else
{
Comm.CommandText = @"INSERT INTO PACKAGE(NAME,PRICE,VALYUTA_ID,POINT) VALUES(@NAME,@PRICE,@VALYUTA_ID,@POINT)";
}
Comm.Parameters.Add("@NAME", SqlDbType.NVarChar);
Comm.Parameters["@NAME"].Value = package_edt.Text;
Comm.Parameters.Add("@PRICE", SqlDbType.Int);
Comm.Parameters["@PRICE"].Value = price_edt.Text;
Comm.Parameters.Add("@VALYUTA_ID", SqlDbType.Int);
Comm.Parameters["@VALYUTA_ID"].Value = valyuta_ddl.SelectedValue;
Comm.Parameters.Add("@POINT", SqlDbType.Int);
Comm.Parameters["@POINT"].Value = point_edt.Text;
Conn.Open();
try
{
Comm.ExecuteNonQuery();
}
catch (SqlException E)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Səhv aşkarlandi', ''); $(\"#close_btn\").click();} );</script>", false);
return;
}
ObjectsGrid.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Təsdiq edildi', '');$(\"#close_btn\").click();});</script>", false);
}
}
protected void Save_btn_Click(object sender, EventArgs e)
{
using (SqlConnection Conn = new SqlConnection())
{
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = Conn;
if (ObjectID_hf.Value.Length != 0 && ObjectID_hf.Value != "-1")
{
Comm.CommandText = @"UPDATE USERS SET
NAME = @NAME,
SURNAME=@SURNAME,
LOGIN=@LOGIN,
PASSWORD=@PASSWORD,
STATUS=@STATUS
WHERE
ID = @ID";
Comm.Parameters.Add("@ID", SqlDbType.Int);
Comm.Parameters["@ID"].Value = ObjectID_hf.Value;
}
else
{
Comm.CommandText = @"INSERT INTO USERS(NAME,SURNAME,LOGIN,PASSWORD,STATUS) VALUES(@NAME,@SURNAME,@LOGIN,@PASSWORD,@STATUS)";
}
Comm.Parameters.Add("@NAME", SqlDbType.NVarChar);
Comm.Parameters.Add("@SURNAME", SqlDbType.NVarChar);
Comm.Parameters.Add("@LOGIN", SqlDbType.NVarChar);
Comm.Parameters.Add("@PASSWORD", SqlDbType.NVarChar);
Comm.Parameters.Add("@STATUS", SqlDbType.Int);
Comm.Parameters["@NAME"].Value = Name_edt.Text;
Comm.Parameters["@SURNAME"].Value = Surname_edt.Text;
Comm.Parameters["@LOGIN"].Value = Login_edt.Text;
Comm.Parameters["@PASSWORD"].Value = Password_edt.Text;
Comm.Parameters["@STATUS"].Value = status_dll.SelectedValue;
Conn.Open();
try
{
Comm.ExecuteNonQuery();
}
catch (SqlException E)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Səhv aşkarlandi', ''); $(\"#close_btn\").click();} );</script>", false);
return;
}
ObjectsGrid.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Təsdiq edildi', '');$(\"#close_btn\").click();});</script>", false);
}
}
protected void Save_btn_click(object sender, EventArgs e)
{
using (SqlConnection Conn = new SqlConnection())
{
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = Conn;
if (ObjectID_hf.Value.Length != 0 && ObjectID_hf.Value != "-1")
{
Comm.CommandText = @"UPDATE CATEGORY SET
AZ_NAME=@AZ_NAME,
EN_NAME=@EN_NAME,
RU_NAME=@RU_NAME
WHERE
ID=@ID";
Comm.Parameters.Add("@ID", SqlDbType.Int);
Comm.Parameters["@ID"].Value = ObjectID_hf.Value;
}
else
{
Comm.CommandText = @"INSERT INTO CATEGORY (AZ_NAME,EN_NAME,RU_NAME)
VALUES(@AZ_NAME,@EN_NAME,@RU_NAME)";
}
Comm.Parameters.Add("@AZ_NAME", SqlDbType.NVarChar);
Comm.Parameters["@AZ_NAME"].Value = category_az_edt.Text;
Comm.Parameters.Add("@EN_NAME", SqlDbType.NVarChar);
Comm.Parameters["@EN_NAME"].Value = category_en_edt.Text;
Comm.Parameters.Add("@RU_NAME", SqlDbType.NVarChar);
Comm.Parameters["@RU_NAME"].Value = category_ru_edt.Text;
Conn.Open();
try
{
Comm.ExecuteNonQuery();
}
catch (SqlException E)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Səhv aşkarlandi', ''); $(\"#close_btn\").click();} );</script>", false);
return;
}
ObjectsGrid.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Təsdiq edildi', '');$(\"#close_btn\").click();});</script>", false);
}
}
protected void Save_btn_Click(object sender, EventArgs e)
{
using (SqlConnection Conn = new SqlConnection())
{
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = Conn;
if (ObjectID_hf.Value.Length != 0 && ObjectID_hf.Value != "-1")
{
Comm.CommandText = @"UPDATE PRICE_PACKAGES SET
NAME = @NAME,
DEVICE_CATEGORY=@DEVICE_CATEGORY,
PRICE=@PRICE,
DURATION_IN_MINUTES=@DURATION_IN_MINUTES
WHERE
ID = @ID";
Comm.Parameters.Add("@ID", SqlDbType.Int);
Comm.Parameters["@ID"].Value = ObjectID_hf.Value;
}
else
{
Comm.CommandText = @"INSERT INTO PRICE_PACKAGES(NAME,DEVICE_CATEGORY,PRICE,DURATION_IN_MINUTES) VALUES(@NAME,@DEVICE_CATEGORY,@PRICE,@DURATION_IN_MINUTES)";
}
Comm.Parameters.Add("@NAME", SqlDbType.NVarChar);
Comm.Parameters.Add("@DEVICE_CATEGORY", SqlDbType.Int);
Comm.Parameters.Add("@PRICE", SqlDbType.Decimal);
Comm.Parameters.Add("@DURATION_IN_MINUTES", SqlDbType.NVarChar);
Comm.Parameters["@NAME"].Value = Name_edt.Text;
Comm.Parameters["@DEVICE_CATEGORY"].Value = device_dll.SelectedValue;
Comm.Parameters["@PRICE"].Value = Price_edt.Text;
Comm.Parameters["@DURATION_IN_MINUTES"].Value = Minute_edt.Text;
Conn.Open();
try
{
Comm.ExecuteNonQuery();
}
catch (SqlException E)
{
Minute_edt.Text = e.ToString();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Səhv aşkarlandi', ''); $(\"#close_btn\").click();} );</script>", false);
return;
}
ObjectsGrid.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Təsdiq edildi', '');$(\"#close_btn\").click();});</script>", false);
}
}
protected void GetReport_btn_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlDataAdapter adapter1 = new SqlDataAdapter();
DataTable dt = new DataTable();
adapter1.SelectCommand = new SqlCommand(@"SELECT T.ID, T.BEGIN_DATE as BEGIN_TIME,END_DATE as END_TIME,T.PRICE,TZ.STATUS_NAME,USERS.NAME as NAME,(SELECT U.NAME FROM USERS U WHERE T.OPERATOR_ID=U.ID) as OPNAME,
CASE T.CLIENT_ID
WHEN 0 THEN T.CUSTOMER_CLIENT
ELSE (C.NAME+ ' '+ C.SURNAME)
END as CLIENT_NAME,
CASE T.PAYMENT_DELETED
WHEN 1 THEN 'ACTIVE'
WHEN 0 THEN 'SILINIB'
END AS DELETED
FROM TRANZACTIONS AS T
left join CLIENTS as C on T.CLIENT_ID=C.ID
left join TRANZACTION_STATUS as TZ on T.STATUS_ID=TZ.ID
left join USERS on T.WORKER_ID=USERS.ID WHERE Convert(varchar(10),END_DATE,120)>=Convert(varchar(10),@time_begin,120) and Convert(varchar(10),END_DATE,120)<=Convert(varchar(10),@time_last,120)", conn);
adapter1.SelectCommand.Parameters.Add("@time_begin", SqlDbType.DateTime).Value = FromDAte.Text;
adapter1.SelectCommand.Parameters.Add("@time_last", SqlDbType.DateTime).Value = ToDate.Text;
adapter1.Fill(dt);
conn.Close();
ObjectsGrid.DataSource = dt;
ObjectsGrid.DataBind();
decimal sum_qazanc = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
decimal qazanc = 0;
try
{
qazanc = decimal.Parse(dt.Rows[i]["PRICE"].ToString());
}
catch { }
sum_qazanc += qazanc;
}
txtqazanc.Text = sum_qazanc.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["qeydiyyat12_1"].ToString() != "ok")
{
Response.Redirect("Default.aspx");
}
}
catch (Exception)
{
Response.Redirect("Default.aspx");
}
try
{
if (Session["adminsession"].ToString() != "okay")
{
Response.Redirect("Default.aspx");
}
}
catch (Exception)
{
Response.Redirect("Default.aspx");
}
if (!IsPostBack)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable dt = new DataTable();
adapter.SelectCommand = new SqlCommand(@"SELECT T.ID, T.BEGIN_DATE as BEGIN_TIME,END_DATE as END_TIME,T.PRICE,TZ.STATUS_NAME,USERS.NAME as NAME,(SELECT U.NAME FROM USERS U WHERE T.OPERATOR_ID=U.ID) as OPNAME,
CASE T.CLIENT_ID
WHEN 0 THEN T.CUSTOMER_CLIENT
ELSE (C.NAME+ ' '+ C.SURNAME)
END as CLIENT_NAME,
CASE T.PAYMENT_DELETED
WHEN 1 THEN 'ACTIVE'
WHEN 0 THEN 'SILINIB'
END AS DELETED
FROM TRANZACTIONS AS T
left join CLIENTS as C on T.CLIENT_ID=C.ID
left join TRANZACTION_STATUS as TZ on T.STATUS_ID=TZ.ID
left join USERS on T.WORKER_ID=USERS.ID WHERE Convert(varchar(10),END_DATE,120)=Convert(varchar(10),dateadd(hour,11,sysdatetime()),120)", conn);
adapter.Fill(dt);
conn.Close();
ObjectsGrid.DataSource = dt;
ObjectsGrid.DataBind();
decimal sum_qazanc = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
decimal qazanc = 0;
try
{
qazanc = decimal.Parse(dt.Rows[i]["PRICE"].ToString());
}
catch { }
sum_qazanc += qazanc;
}
txtqazanc.Text = sum_qazanc.ToString();
}
}
}
protected void Search_btn_Click(object sender, EventArgs e)
{
report_sql.SelectParameters.Clear();
report_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
report_sql.SelectCommand = "REPORT_SP";
report_sql.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
if (Username_ddl.SelectedIndex == 0)
{
report_sql.SelectParameters.Add("USER_ID", "0");
}
else
{
report_sql.SelectParameters.Add("USER_ID", Username_ddl.SelectedValue);
}
if (Subject_txt.Text.Length == 0)
{
report_sql.SelectParameters.Add("SUBJECT", "#~#");
}
else
{
report_sql.SelectParameters.Add("SUBJECT", Subject_txt.Text);
}
if (Description_txt.Text.Length == 0)
{
report_sql.SelectParameters.Add("DESCRIPTION", "#~#");
}
else
{
report_sql.SelectParameters.Add("DESCRIPTION", Description_txt.Text);
}
if (Start_edt.Text.Length == 0)
{
report_sql.SelectParameters.Add("BEGIN_DATE", "2012-12-12");
}
else
{
report_sql.SelectParameters.Add("BEGIN_DATE", DateTime.ParseExact(Start_edt.Text, "dd.MM.yyyy", CultureInfo.InvariantCulture).ToString());
}
if (Deadline_edt.Text.Length == 0)
{
report_sql.SelectParameters.Add("END_DATE", "2012-12-12");
}
else
{
report_sql.SelectParameters.Add("END_DATE", DateTime.ParseExact(Deadline_edt.Text, "dd.MM.yyyy", CultureInfo.InvariantCulture).ToString());
}
if (Operator_ddl.SelectedIndex == 0)
{
report_sql.SelectParameters.Add("OPERATOR_ID", "0");
}
else
{
report_sql.SelectParameters.Add("OPERATOR_ID", Operator_ddl.SelectedValue);
}
ObjectsGrid.DataBind();
string Result_count = ObjectsGrid.Items.Count.ToString();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Result : " + Result_count + "', '');} );</script>", false);
}
protected void Create_cards(object sender, EventArgs e)
{
if (Package_type_ddl.SelectedIndex < 1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left', '" + "Choose Package type" + " ', '');} );</script>", false);
return;
}
else if (Package_ddl.SelectedIndex < 1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left', '" + "Choose Package " + " ', '');} );</script>", false);
return;
}
else if (Convert.ToInt32(count_txt.Text) < 1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left', '" + "Choose Card count " + " ', '');} );</script>", false);
return;
}
if (AuthCookieParse.UserID() != null && Convert.ToInt32(AuthCookieParse.UserID()) < 1)
{
Response.Redirect("Default.aspx");
}
else
{
using (SqlConnection Conn = new SqlConnection())
{
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = Conn;
Conn.Open();
Comm.Parameters.Add("@CODE", SqlDbType.NVarChar);
int count = 0;
string random_text = "";
string type = Package_type_ddl.SelectedItem.Text.Substring(0, 1);
if (Package_ddl.SelectedValue == "4" || Package_ddl.SelectedValue == "7")
{
type += "H";
}
else if (Package_ddl.SelectedValue == "5" || Package_ddl.SelectedValue == "8")
{
type += "W";
}
else if (Package_ddl.SelectedValue == "6" || Package_ddl.SelectedValue == "9")
{
type += "M";
}
while (Convert.ToInt32(count_txt.Text) > count)
{
random_text = card_generator(type);
Comm.Parameters["@CODE"].Value = random_text;
Comm.CommandText = @"SELECT COUNT(*) FROM CARD_CODES WHERE CODE=@CODE";
SqlCommand cmd_sp = new SqlCommand("CARD_CREATE", Conn);
cmd_sp.CommandType = CommandType.StoredProcedure;
cmd_sp.Parameters.Add(new SqlParameter("@TYPE_ID", Package_type_ddl.SelectedValue));
cmd_sp.Parameters.Add(new SqlParameter("@PACKAGE_ID", Package_ddl.SelectedValue));
if (Convert.ToInt32(Comm.ExecuteScalar()) < 1)
{
cmd_sp.Parameters.Add(new SqlParameter("@CODE", random_text));
try
{
cmd_sp.ExecuteNonQuery();
count += 1;
}
catch (SqlException t)
{
}
}
}
}
}
ObjectsGrid.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Təsdiq edildi', '');$(\"#close_btn\").click();});</script>", false);
}
protected void Save_btn_Click(object sender, EventArgs e)
{
if (client_name_edt.Text == "" || client_surname_edt.Text == "")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Adı daxil edin', '');} );</script>", false);
}
else if (Convert.ToInt32(gender_ddl.SelectedValue) == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Cinsi daxil edin', '');} );</script>", false);
}
else if (Convert.ToInt32(age_ddl.SelectedValue) == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Yaşı daxil edin', '');} );</script>", false);
}
else if (Convert.ToInt32(source_type.SelectedValue) == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Mənbə tipini daxil edin', '');} );</script>", false);
}
else if (Convert.ToInt32(source_type_name_ddl.SelectedValue) == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Mənbəni daxil edin', '');} );</script>", false);
}
else
{
using (SqlConnection Conn = new SqlConnection())
{
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = Conn;
if (ObjectID_hf.Value.Length != 0 && ObjectID_hf.Value != "-1")
{
Comm.CommandText = @"UPDATE CLIENTS SET
NAME=@NAME,
SURNAME=@SURNAME,
PHONE_NUMBER=@PHONE_NUMBER,
GENDER = @GENDER,
AGE_INTERVAL=@AGE_INTERVAL,
BIRTHDAY=@BIRTHDAY,
SOURCE_TYPE=@SOURCE_TYPE,
SOURCE_TYPE_NAME=@SOURCE_TYPE_NAME,
USER_ID=@USER_ID
WHERE
ID = @ID";
Comm.Parameters.Add("@ID", SqlDbType.Int);
Comm.Parameters["@ID"].Value = ObjectID_hf.Value;
}
else
{
Comm.CommandText = @"INSERT INTO CLIENTS(NAME,SURNAME,PHONE_NUMBER,GENDER,AGE_INTERVAL,BIRTHDAY,SOURCE_TYPE,SOURCE_TYPE_NAME,USER_ID)
VALUES(@NAME,@SURNAME,@PHONE_NUMBER,@GENDER,@AGE_INTERVAL,@BIRTHDAY,@SOURCE_TYPE,@SOURCE_TYPE_NAME,@USER_ID)";
}
Comm.Parameters.Add("@NAME", SqlDbType.NVarChar);
Comm.Parameters["@NAME"].Value = client_name_edt.Text;
Comm.Parameters.Add("@SURNAME", SqlDbType.NVarChar);
Comm.Parameters["@SURNAME"].Value = client_surname_edt.Text;
Comm.Parameters.Add("@PHONE_NUMBER", SqlDbType.NVarChar);
Comm.Parameters["@PHONE_NUMBER"].Value = numberddl.SelectedValue.ToString() + PhoneNumber_edt.Text;
Comm.Parameters.Add("@GENDER", SqlDbType.Int);
Comm.Parameters["@GENDER"].Value = gender_ddl.SelectedValue;
Comm.Parameters.Add("@AGE_INTERVAL", SqlDbType.NVarChar);
Comm.Parameters["@AGE_INTERVAL"].Value = age_ddl.Text;
Comm.Parameters.Add("@BIRTHDAY", SqlDbType.DateTime);
try
{
Comm.Parameters["@BIRTHDAY"].Value = birthday_txt.Text;
}
catch
{
Comm.Parameters["@BIRTHDAY"].Value = null;
}
Comm.Parameters.Add("@SOURCE_TYPE", SqlDbType.Int);
Comm.Parameters["@SOURCE_TYPE"].Value = source_type.SelectedValue;
Comm.Parameters.Add("@SOURCE_TYPE_NAME", SqlDbType.Int);
Comm.Parameters["@SOURCE_TYPE_NAME"].Value = source_type_name_ddl.SelectedValue;
Comm.Parameters.Add("@USER_ID", SqlDbType.Int);
Comm.Parameters["@USER_ID"].Value = AuthCookieParse.UserID();
Conn.Open();
try
{
Comm.ExecuteNonQuery();
}
catch (SqlException E)
{
client_name_edt.Text = E.ToString();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Səhv aşkarlandi', ''); $(\"#close_btn\").click();} );</script>", false);
return;
}
ObjectsGrid.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Təsdiq edildi', '');$(\"#close_btn\").click();});</script>", false);
}
}
}
protected void Saving_btn_Click(object sender, EventArgs e)
{
if (re_user_password_edt.Visible == true && re_user_password_edt.Text != user_password_edt.Text)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','No match', ''); } );</script>", false);
return;
}
using (SqlConnection Conn = new SqlConnection())
{
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = Conn;
if (ObjectID_hf.Value.Length != 0 && ObjectID_hf.Value != "-1")
{
string command = "";
if (user_password_edt.Text == "")
{
command = @"UPDATE USERS SET
FNAME=@FNAME,
LNAME=@LNAME,
USERNAME=@USERNAME,
STATUS=@STATUS
WHERE
ID=@ID";
}
else
{
command = @"UPDATE USERS SET
FNAME=@FNAME,
LNAME=@LNAME,
USERNAME=@USERNAME,
PASSWORD=@PASSWORD,
STATUS=@STATUS
WHERE
ID=@ID";
}
Comm.CommandText = command;
Comm.Parameters.Add("@ID", SqlDbType.Int);
Comm.Parameters["@ID"].Value = ObjectID_hf.Value;
}
else
{
Comm.CommandText = @"INSERT INTO USERS (FNAME,LNAME,USERNAME,PASSWORD,STATUS)
VALUES(@FNAME,@LNAME,@USERNAME,@PASSWORD,@STATUS)";
}
Comm.Parameters.Add("@FNAME", SqlDbType.NVarChar);
Comm.Parameters["@FNAME"].Value = user_name_edt.Text;
Comm.Parameters.Add("@LNAME", SqlDbType.NVarChar);
Comm.Parameters["@LNAME"].Value = user_surname_edt.Text;
Comm.Parameters.Add("@USERNAME", SqlDbType.NVarChar);
Comm.Parameters["@USERNAME"].Value = user_login_edt.Text;
if (user_password_edt.Text != "")
{
Comm.Parameters.Add("@PASSWORD", SqlDbType.NVarChar);
Comm.Parameters["@PASSWORD"].Value = user_password_edt.Text;
}
Comm.Parameters.Add("@STATUS", SqlDbType.Int);
Comm.Parameters["@STATUS"].Value = 1;
Conn.Open();
try
{
Comm.ExecuteNonQuery();
}
catch (SqlException E)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Error occured', ''); $(\"#close_btn\").click();} );</script>", false);
return;
}
ObjectsGrid.DataBind();
re_password_div.Visible = false;
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Done', '');$(\"#close_btn\").click();});</script>", false);
}
}
protected void Save_btn_Click(object sender, EventArgs e)
{
if (Convert.ToInt32(client_ddl.SelectedValue) == 0 && client_txt.Text == "")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Ad daxil edin', '');} );</script>", false);
}
else if (Convert.ToInt32(numberddl.SelectedValue) == 0 || PhoneNumber_edt.Text == "")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Nömrəni daxil edin', '');} );</script>", false);
}
else
{
{
using (SqlConnection Conn = new SqlConnection())
{
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
SqlCommand command_device = new SqlCommand();
SqlCommand command_game = new SqlCommand();
Comm.Connection = Conn;
//=================================================================
//=====================================================================
if (ObjectID_hf.Value.Length != 0 && ObjectID_hf.Value != "-1")
{
Comm.CommandText = @"UPDATE CLIENTS_ORDER SET
CLIENTS_ID=@CLIENTS_ID,
ORDER_DATE=@ORDER_DATE,
ORDER_TYPE=@ORDER_TYPE,
REJECT_REASON_ID=@REJECT_REASON_ID,
REJECT_DESCRIPTON=@REJECT_DESCRIPTON,
CLIENTS_DESCRIPTON=@CLIENTS_DESCRIPTON,
ORDER_DATE_HOUR=@ORDER_DATE_HOUR,
ORDER_DATE_TIME=@ORDER_DATE_TIME,
CLIENT_PHONE=@CLIENT_PHONE,
PACKAGES_ID=@PACKAGES_ID,
DEVICE_CATEGORY_COUNT=@DEVICE_CATEGORY_COUNT
WHERE
ID = @ID";
Comm.Parameters.Add("@ID", SqlDbType.Int);
Comm.Parameters["@ID"].Value = ObjectID_hf.Value;
}
else
{
Comm.CommandText = @"INSERT INTO CLIENTS_ORDER(CLIENTS_ID,ORDER_DATE,ORDER_TYPE,REJECT_REASON_ID,REJECT_DESCRIPTON,CLIENTS_DESCRIPTON,ORDER_DATE_HOUR,ORDER_DATE_TIME,DEVICE_CATEGORY_COUNT,DEVICES_CATEGORY_ID,CLIENT_PHONE,PACKAGES_ID)
VALUES(@CLIENTS_ID,@ORDER_DATE,@ORDER_TYPE,@REJECT_REASON_ID,@REJECT_DESCRIPTON,@CLIENTS_DESCRIPTON,@ORDER_DATE_HOUR,@ORDER_DATE_TIME,@DEVICE_CATEGORY_COUNT,@DEVICES_CATEGORY_ID,@CLIENT_PHONE,@PACKAGES_ID)";
}
//if (client_txt.Text != "")
//{
//Comm.Parameters.Add("@CLIENTS_ID", SqlDbType.Int);
// Comm.Parameters["@CLIENTS_ID"].Value = 0;
//}
//else
//{
Comm.Parameters.Add("@CLIENTS_ID", SqlDbType.Int);
Comm.Parameters["@CLIENTS_ID"].Value = client_ddl.SelectedValue;
//}
Comm.Parameters.Add("@DEVICES_CATEGORY_ID", SqlDbType.Int);
Comm.Parameters["@DEVICES_CATEGORY_ID"].Value = device_dll.SelectedValue;
Comm.Parameters.Add("@ORDER_TYPE", SqlDbType.Int);
Comm.Parameters["@ORDER_TYPE"].Value = gender_ddl.SelectedValue;
Comm.Parameters.Add("@REJECT_REASON_ID", SqlDbType.Int);
Comm.Parameters["@REJECT_REASON_ID"].Value = reject_dll.SelectedValue;
Comm.Parameters.Add("@REJECT_DESCRIPTON", SqlDbType.NVarChar);
Comm.Parameters["@REJECT_DESCRIPTON"].Value = reject_edt.Text;
// if (Convert.ToInt32(client_ddl.SelectedValue) != 0)
// {
// Comm.Parameters.Add("@CLIENTS_DESCRIPTON", SqlDbType.NVarChar);
// Comm.Parameters["@CLIENTS_DESCRIPTON"].Value = null;
// }
// else
// {
Comm.Parameters.Add("@CLIENTS_DESCRIPTON", SqlDbType.NVarChar);
Comm.Parameters["@CLIENTS_DESCRIPTON"].Value = client_txt.Text;
// }
Comm.Parameters.Add("@ORDER_DATE", SqlDbType.DateTime);
Comm.Parameters["@ORDER_DATE"].Value = orderdate_edt.Text;
Comm.Parameters.Add("@ORDER_DATE_HOUR", SqlDbType.Int);
Comm.Parameters["@ORDER_DATE_HOUR"].Value = hour_ddl.Text;
Comm.Parameters.Add("@ORDER_DATE_TIME", SqlDbType.Int);
Comm.Parameters["@ORDER_DATE_TIME"].Value = minutes_ddl.Text;
Comm.Parameters.Add("@DEVICE_CATEGORY_COUNT", SqlDbType.Int);
Comm.Parameters["@DEVICE_CATEGORY_COUNT"].Value = Convert.ToInt32(cetegory_count.Text);
Comm.Parameters.Add("@CLIENT_PHONE", SqlDbType.NVarChar);
Comm.Parameters["@CLIENT_PHONE"].Value = numberddl.SelectedValue.ToString() + PhoneNumber_edt.Text;
Comm.Parameters.Add("@PACKAGES_ID", SqlDbType.Int);
Comm.Parameters["@PACKAGES_ID"].Value = packages_dll.SelectedValue;
//==================================================================================
Conn.Open();
try
{
Comm.ExecuteNonQuery();
}
catch (SqlException E)
{
client_txt.Text = E.ToString();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left','Səhv aşkarlandi', ''); $(\"#close_btn\").click();} );</script>", false);
return;
}
ObjectsGrid.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Təsdiq edildi', '');$(\"#close_btn\").click();});</script>", false);
}
}
}
}
