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 Package_pay(object sender, EventArgs e) { 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("@USER_ID", SqlDbType.Int); Comm.Parameters["@USER_ID"].Value = AuthCookieParse.UserID(); Comm.CommandText = @"SELECT ACTIVE FROM VENDOR_USERS WHERE ID=@USER_ID"; SqlDataReader Reader = Comm.ExecuteReader(); Reader.Close(); bool active = false; if (Reader.Read()) { active = Convert.ToBoolean(Reader["ACTIVE"]); } if (!active) { ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {$.Notification.notify('error','top left', '" + "Packages for active account" + " ', ''); $(\"#close_btn\").click();} );</script>", false); } else { SqlCommand cmd_sp = new SqlCommand("SP_PAY_PACKAGE", Conn); cmd_sp.CommandType = CommandType.StoredProcedure; cmd_sp.Parameters.Add(new SqlParameter("@USER_ID", 22)); cmd_sp.Parameters.Add(new SqlParameter("@PACKAGE_ID", 6)); cmd_sp.ExecuteNonQuery(); Comm.CommandText = @"INSERT INTO USER_PACKAGE (USER_ID,PACKAGE_ID,USING_CHECK,PAY_DATE) VALUES(@USER_ID,@PACKAGE_ID,0,GETDATE())"; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { orders_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString; orders_sql.SelectCommand = @"SELECT O.ID 'ID',SUBJECT,CONVERT(NVARCHAR,TIME_TO_CONNECT,104) 'DATE',OT.NAME 'STATUS',O.POINT FROM ORDERS O LEFT JOIN ORDER_TYPE OT ON O.STATUS_TYPE=OT.ID WHERE O.CREATE_BY=@USER_ID ORDER BY O.ID DESC"; orders_sql.SelectParameters.Add("USER_ID", AuthCookieParse.UserID().ToString()); } }
protected void Subcategory() { int package_id = 0; using (SqlConnection Conn = new SqlConnection()) { Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString; SqlCommand Comm = new SqlCommand(); Comm.Connection = Conn; Comm.CommandText = @"SELECT ID,PACKAGE_ID,POINT FROM USER_PACKAGE WHERE USING_CHECK=1 AND USER_ID=@USER_ID "; Comm.Parameters.Add("@USER_ID", SqlDbType.Int); Comm.Parameters["@USER_ID"].Value = AuthCookieParse.UserID(); Conn.Open(); SqlDataReader Reader = Comm.ExecuteReader(); if (Reader.Read()) { if (Reader["PACKAGE_ID"] != DBNull.Value) { package_id = Convert.ToInt32(Reader["PACKAGE_ID"]); Max_point.Text = Reader["POINT"].ToString(); User_Package_id_txt.Text = Reader["ID"].ToString(); } } Conn.Close(); Reader.Close(); } subcategory_sql.SelectParameters.Clear(); subcategory_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString; subcategory_sql.SelectCommand = string.Format(@"SELECT SB.ID,SB.{0}_NAME AS NAME,SB.PRICE,'VALUE'='',POINT FROM PACKAGE_SUBCATEGORY PS LEFT JOIN SUB_CATEGORY SB ON PS.SUBCATEGORY_ID=SB.ID WHERE PS.PACKAGE_ID=@PACKAGE_ID" , Session["LANG"].ToString()); subcategory_sql.SelectParameters.Add("PACKAGE_ID", "9"); }
protected void LoadInfo_btn_Click(object sender, EventArgs e) { try { problem_txt.Text = null; if (ObjectID_hf.Value.Length != 0 && ObjectID_hf.Value != "-1") { name_lbl.Text = ""; //services------------------------------------- services_sql.SelectParameters.Clear(); services_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString; services_sql.SelectParameters.Add("ORDER_ID", ObjectID_hf.Value); if (Session["LANG"] == "AZ") { services_sql.SelectCommand = @"SELECT SC.AZ_NAME 'NAME' FROM SERVICES S LEFT JOIN SUB_CATEGORY SC ON S.SUBCATEGORY_ID=SC.ID WHERE S.ORDER_ID=@ORDER_ID" ; } else if (Session["LANG"] == "EN") { services_sql.SelectCommand = @"SELECT SC.EN_NAME 'NAME' FROM SERVICES S LEFT JOIN SUB_CATEGORY SC ON S.SUBCATEGORY_ID=SC.ID WHERE S.ORDER_ID=@ORDER_ID" ; } else { services_sql.SelectCommand = @"SELECT SC.RU_NAME 'NAME' FROM SERVICES S LEFT JOIN SUB_CATEGORY SC ON S.SUBCATEGORY_ID=SC.ID WHERE S.ORDER_ID=@ORDER_ID" ; } services_rpt.DataBind(); //services------------------------------------- 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; Conn.Open(); Comm.CommandText = @"SELECT COUNT(*) FROM ORDER_EDITING WHERE USER_ID=@USER_ID AND ORDER_ID=@ORDER_ID"; Comm.Parameters.Add("@USER_ID", SqlDbType.Int); Comm.Parameters["@USER_ID"].Value = AuthCookieParse.UserID(); Comm.Parameters.Add("@ORDER_ID", SqlDbType.Int); Comm.Parameters["@ORDER_ID"].Value = ObjectID_hf.Value; int count = Convert.ToInt32(Comm.ExecuteScalar()); Comm.Parameters.Clear(); if (count < 1) { Comm.CommandText = @"INSERT INTO ORDER_EDITING (USER_ID,ORDER_ID,EDIT_DATE,TEXT) VALUES (@USER_ID,@ORDER_ID, CONVERT(NVARCHAR, DATEADD(HOUR,11,GETDATE()),20),'SEEN')" ; Comm.Parameters.Add("@USER_ID", SqlDbType.Int); Comm.Parameters["@USER_ID"].Value = AuthCookieParse.UserID(); Comm.Parameters.Add("@ORDER_ID", SqlDbType.Int); Comm.Parameters["@ORDER_ID"].Value = ObjectID_hf.Value; Comm.ExecuteNonQuery(); Comm.Parameters.Clear(); } Comm.Parameters.Add("@ID", SqlDbType.Int); Comm.Parameters["@ID"].Value = ObjectID_hf.Value; Comm2.Parameters.Add("@ID", SqlDbType.Int); Comm2.Parameters["@ID"].Value = ObjectID_hf.Value; Comm.CommandText = @"SELECT O.ID,O.PROBLEM_DESC,(CONVERT(NVARCHAR,TIME_TO_CONNECT,104)) 'DATE',TEAMVIEWER_CODE,TEAMVIEWER_LOGIN,(VU.FNAME+' '+VU.LNAME ) 'USER_FIO',O.SUBJECT,O.DESCRIPTION,O.STATUS_TYPE FROM ORDERS O LEFT JOIN VENDOR_USERS VU ON O.CREATE_BY=VU.ID LEFT JOIN ORDER_TYPE OT ON O.STATUS_TYPE=OT.ID WHERE O.ID=@ID" ; Comm2.CommandText = @"SELECT USER_ID,ORDER_ID,EDIT_DATE,TEXT,(U.FNAME + ' ' + U.LNAME) AS FIO,US.STATUS AS STATUS FROM ORDER_EDITING OE LEFT JOIN ORDERS O ON OE.ORDER_ID=O.ID LEFT JOIN USERS U ON OE.USER_ID=U.ID LEFT JOIN USER_STATUS US ON U.STATUS =US.ID WHERE OE.ORDER_ID=@ID"; SqlDataReader reader = Comm.ExecuteReader(); if (reader.Read()) { Username_edt.Text = reader["USER_FIO"].ToString(); Date_edt.Text = reader["DATE"].ToString(); Teamviewer_edt.Text = reader["TEAMVIEWER_CODE"].ToString(); Subject_edt.Text = reader["SUBJECT"].ToString(); Description_edt.Text = reader["DESCRIPTION"].ToString(); order_status_ddl.SelectedValue = reader["STATUS_TYPE"].ToString(); team_log_edt.Text = reader["TEAMVIEWER_LOGIN"].ToString(); } reader.Close(); DataTable Table = new DataTable(); Table.Load(Comm2.ExecuteReader()); for (int i = 0; i < Table.Rows.Count; i++) { name_lbl.Text = name_lbl.Text + Table.Rows[i]["FIO"].ToString() + " " + Table.Rows[i]["EDIT_DATE"].ToString() + " " + Table.Rows[i]["Text"].ToString() + "</br>"; } } } } 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; } ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();} );</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); } } }
void load_info() { if (AuthCookieParse.UserID().ToString() == "-1") { Response.Redirect("default.aspx"); } else if (AuthCookieParse.UserStatus() == "1") { category_li.Visible = true; subcategory_li.Visible = true; users_li.Visible = false; vendorusers_li.Visible = true; orderlist_li.Visible = true; Problem_list.Visible = true; card_generator.Visible = false; Tranzactions_list.Visible = false; Report_list.Visible = false; Doneorders_li.Visible = true; createorder_li.Visible = false; myorders_li.Visible = false; } else if (AuthCookieParse.UserStatus() == "0") { category_li.Visible = false; subcategory_li.Visible = false; users_li.Visible = false; card_generator.Visible = false; Tranzactions_list.Visible = false; Report_list.Visible = false; vendorusers_li.Visible = false; orderlist_li.Visible = false; Doneorders_li.Visible = false; createorder_li.Visible = true; myorders_li.Visible = true; pricing_li.Visible = true; } else if (AuthCookieParse.UserStatus() == "3") { category_li.Visible = true; subcategory_li.Visible = true; users_li.Visible = true; vendorusers_li.Visible = true; orderlist_li.Visible = true; Problem_list.Visible = true; card_generator.Visible = true; Tranzactions_list.Visible = true; Report_list.Visible = true; Doneorders_li.Visible = true; } else if (AuthCookieParse.UserStatus() == "2") { category_li.Visible = true; subcategory_li.Visible = true; users_li.Visible = true; vendorusers_li.Visible = true; orderlist_li.Visible = true; Problem_list.Visible = true; card_generator.Visible = false; Tranzactions_list.Visible = true; Report_list.Visible = true; Doneorders_li.Visible = true; } string point = ""; string package = ""; string info = ""; string time = ""; using (SqlConnection Conn = new SqlConnection()) { Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString; SqlCommand Comm = new SqlCommand(); Comm.Connection = Conn; Conn.Open(); Comm.CommandText = @" SELECT AP.POINT,PAY_DATE,P.NAME AS PACKAGE,PT.NAME AS TYPE,PACKAGE_ID FROM USER_PACKAGE AS AP LEFT JOIN PACKAGE AS P ON AP.PACKAGE_ID=P.ID LEFT JOIN PACKAGE_TYPE AS PT ON P.TYPE_ID=PT.ID WHERE AP.USER_ID=@ID AND USING_CHECK=1" ; Comm.Parameters.Add("@ID", SqlDbType.Int); Comm.Parameters["@ID"].Value = AuthCookieParse.UserID(); SqlDataReader reader = Comm.ExecuteReader(); if (reader.Read()) { info = reader["TYPE"] + ": " + reader["PACKAGE"]; point = reader["POINT"].ToString(); package = reader["PACKAGE_ID"].ToString(); time = reader["PAY_DATE"].ToString(); } reader.Close(); } package_info.InnerText = info; point_info.InnerText += point; if (package == "4" || package == "7") { time_info.InnerText += Convert.ToDateTime(time).AddHours(24).ToString(); } else if (package == "5" || package == "8") { time_info.InnerText += Convert.ToDateTime(time).AddDays(7); } else if (package == "6" || package == "9") { time_info.InnerText += Convert.ToDateTime(time).AddMonths(1); } }
protected void Package_pay(object sender, EventArgs e) { 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("@USER_ID", SqlDbType.Int); Comm.Parameters["@USER_ID"].Value = AuthCookieParse.UserID(); Comm.CommandText = @"SELECT ACTIVE FROM VENDOR_USERS WHERE ID=@USER_ID"; SqlDataReader Reader = Comm.ExecuteReader(); bool active = false; if (Reader.Read()) { active = Convert.ToBoolean(Reader["ACTIVE"]); } if (!active) { ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {$.Notification.notify('error','top left', '" + "Packages for active account" + " ', ''); $(\"#close_btn\").click();} );</script>", false); } else { Reader.Close(); SqlCommand cmd_sp = new SqlCommand("CARD_CODE_PAY", Conn); cmd_sp.CommandType = CommandType.StoredProcedure; cmd_sp.Parameters.Add(new SqlParameter("@USER_ID", AuthCookieParse.UserID())); cmd_sp.Parameters.Add(new SqlParameter("@CODE", Card_code_edt.Text)); cmd_sp.Parameters.Add(new SqlParameter("@PACKAGE_IDD", ObjectID_hf.Value)); int res = cmd_sp.ExecuteNonQuery(); if (res < 1) { error_lbl.Visible = true; } else { error_lbl.Visible = false; Response.Redirect("Myorders.aspx"); } } } } }
protected void Pay_btn_click(object sender, EventArgs e) { if (Selected_lbx.Items.Count < 1) { ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left', '" + "Choose Services" + " ', ''); $(\"#close_btn\").click();} );</script>", false); return; } else if (subject_txt.Value.Length < 1) { ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left', '" + "Enter Subject" + " ', ''); $(\"#close_btn\").click();} );</script>", false); return; } else if (Deadline_edt.Text.Length < 1) { ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left', '" + "Enter Date" + " ', ''); $(\"#close_btn\").click();} );</script>", false); return; } else if (DateTime.ParseExact(Deadline_edt.Text, "dd.MM.yyyy", CultureInfo.InvariantCulture) < DateTime.Now.Date) { ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left', '" + "Choose correct Date" + " ', ''); $(\"#close_btn\").click();} );</script>", false); return; } else if (Convert.ToInt32(total_lbl.Text) > Convert.ToInt32(Max_point.Text)) { ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('error','top left', '" + "Max Point:" + Max_point.Text + " ', ''); $(\"#close_btn\").click();} );</script>", false); return; } using (SqlConnection Conn = new SqlConnection()) { Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString; SqlCommand Comm = new SqlCommand(); Comm.Connection = Conn; Conn.Open(); // Comm.CommandText = @"INSERT INTO PAYMENT_TRANZACTION(USER_ID,CREATE_DATE) // VALUES(@USER_ID,GETDATE());SELECT SCOPE_IDENTITY()"; // Comm.Parameters.Add("@USER_ID", SqlDbType.Int); // Comm.Parameters["@USER_ID"].Value = AuthCookieParse.UserID(); // int TranzactionId = 0; // TranzactionId = Convert.ToInt32(Comm.ExecuteScalar()); // //--------------------------------------------------------------------------------------------------------------------------------------- // string address = "https://www.e-pul.az/epay/pay_via_epul/register_transaction?username=frazexHP&password=aFYGL6nG&amount={amount}&description=partner%20payment&transactionId={transaction_id}&backUrl=http://ithelpdesk.albuket.az/createorder.aspx&errorUrl=http://ithelpdesk.albuket.az/createorder.aspx".Replace("{amount}", Math.Ceiling(0.12 * 100).ToString()).Replace("{transaction_id}", TranzactionId.ToString()); // System.Net.WebRequest req = System.Net.WebRequest.Create(address); // System.Net.WebResponse resp = req.GetResponse(); // System.IO.StreamReader sr = new System.IO.StreamReader(resp.GetResponseStream()); // string result = sr.ReadToEnd().Trim(); // pay_result_struct pay_result = JsonConvert.DeserializeObject<pay_result_struct>(result); // //--------------------------------------------------------------------------------------------------------------------------------------- // if (pay_result.success == "true") // { Comm.Parameters.Clear(); //Запись данных о ордере в базу //--------------------------------------------------------------------------------------------------------------------------------------- Comm.CommandText = @"INSERT INTO ORDERS(SUBJECT,TIME_TO_CONNECT,DESCRIPTION,POINT,VALYUTA_ID,CREATE_BY,STATUS_TYPE,TEAMVIEWER_CODE,TEAMVIEWER_LOGIN) VALUES(@SUBJECT,convert(date, convert(varchar(30), @TIME_TO_CONNECT), 104),@DESCRIPTION,@POINT_TOTAL,1,@CREATE_BY,1,@TEAMVIEWER_CODE,@TEAMVIEWER_LOGIN); UPDATE USER_PACKAGE SET POINT=@POINT WHERE ID=@UP_ID;SELECT SCOPE_IDENTITY()"; Comm.Parameters.Add("@SUBJECT", SqlDbType.NVarChar); Comm.Parameters["@SUBJECT"].Value = subject_txt.Value; Comm.Parameters.Add("@TIME_TO_CONNECT", SqlDbType.VarChar); Comm.Parameters["@TIME_TO_CONNECT"].Value = Deadline_edt.Text; Comm.Parameters.Add("@DESCRIPTION", SqlDbType.NVarChar); Comm.Parameters["@DESCRIPTION"].Value = Description_txt.Text; Comm.Parameters.Add("@POINT_TOTAL", SqlDbType.Int); Comm.Parameters["@POINT_TOTAL"].Value = total_lbl.Text; Comm.Parameters.Add("@POINT", SqlDbType.Int); Comm.Parameters["@POINT"].Value = Convert.ToInt32(Max_point.Text) - Convert.ToInt32(total_lbl.Text); Comm.Parameters.Add("@CREATE_BY", SqlDbType.Int); Comm.Parameters["@CREATE_BY"].Value = AuthCookieParse.UserID(); Comm.Parameters.Add("@UP_ID", SqlDbType.Int); Comm.Parameters["@UP_ID"].Value = User_Package_id_txt.Text; Comm.Parameters.Add("@TEAMVIEWER_CODE", SqlDbType.NVarChar); Comm.Parameters["@TEAMVIEWER_CODE"].Value = Teamviwer_txt.Text; Comm.Parameters.Add("@TEAMVIEWER_LOGIN", SqlDbType.NVarChar); Comm.Parameters["@TEAMVIEWER_LOGIN"].Value = Login_teamviewer_txt.Text; int order_id = 0; try { order_id = Convert.ToInt32(Comm.ExecuteScalar()); } catch (SqlException E) { subject_txt.Value = e.ToString(); return; } Comm.Parameters.Clear(); Comm.CommandText = @"INSERT INTO SERVICES(ORDER_ID,SUBCATEGORY_ID) VALUES(@ORDER_ID,@SUBCATEGORY_ID)"; Comm.Parameters.Add("@ORDER_ID", SqlDbType.Int); Comm.Parameters["@ORDER_ID"].Value = order_id; Comm.Parameters.Add("@SUBCATEGORY_ID", SqlDbType.Int); ListBox lb = (ListBox)Session["SERVICES"]; for (int i = 0; i < lb.Items.Count; i++) { Comm.Parameters["@SUBCATEGORY_ID"].Value = lb.Items[i].Value; Comm.ExecuteNonQuery(); } Comm.Parameters.Clear(); //Comm.CommandText = @"UPDATE PAYMENT_TRANZACTION SET ORDER_ID=@ORDER_ID,PAY_RESULT=@PAY_RESULT WHERE ID=@ID"; //Comm.Parameters.Add("@PAY_RESULT", SqlDbType.NVarChar); //Comm.Parameters["@PAY_RESULT"].Value ="Payed"; //Comm.Parameters.Add("@ORDER_ID", SqlDbType.NVarChar); //Comm.Parameters["@ORDER_ID"].Value = pay_result.orderId.ToString(); //Comm.Parameters.Add("@ID", SqlDbType.Int); //Comm.Parameters["@ID"].Value = TranzactionId; //Comm.ExecuteNonQuery(); ////--------------------------------------------------------------------------------------------------------------------------------------- //Response.Redirect(pay_result.forwardUrl); // } } ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script type=\"text/javascript\">$(document).ready(function() {init();$.Notification.notify('success','top left','Təsdiq edildi', '');});</script>", false); Response.Redirect("myorders.aspx"); }
protected void Login_btn_Click(object sender, EventArgs e) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = @"SELECT ID,(FNAME + ' ' + LNAME) AS FIO,PHONENUMBER,EMAIL,PASSWORD,CURRENT_LANG,STATUS FROM VENDOR_USERS WHERE EMAIL=@EMAIL AND PASSWORD=@PASSWORD"; cmd.Parameters.Add("@EMAIL", SqlDbType.NVarChar); cmd.Parameters["@EMAIL"].Value = Login_edt.Text; cmd.Parameters.Add("@PASSWORD", SqlDbType.NVarChar); cmd.Parameters["@PASSWORD"].Value = Password_edt.Text; conn.Open(); SqlDataReader reader; reader = cmd.ExecuteReader(); string CookiesString = ""; if (reader.Read()) { CookiesString = reader["ID"].ToString() + "|" + reader["FIO"].ToString() + "|" + reader["EMAIL"].ToString() + "|" + reader["STATUS"] + "|" + reader["PHONENUMBER"] + "|" + reader["CURRENT_LANG"] + "|"; FormsAuthentication.SetAuthCookie(CookiesString, true); reader.Close(); } else { this.RegisterStartupScript("alert", "<script lang='javascript'>alert('User not found');</script>"); return; } reader.Close(); cmd.CommandText = @"SELECT POINT FROM USER_PACKAGE WHERE USING_CHECK=1 AND USER_ID=@USER_ID"; cmd.Parameters.Add("@USER_ID", SqlDbType.Int); cmd.Parameters["@USER_ID"].Value = AuthCookieParse.UserID(); reader = cmd.ExecuteReader(); int point = 0; if (reader.Read()) { if (reader["POINT"] != DBNull.Value) { point = Convert.ToInt32(reader["POINT"]); } } if (point > 0) { Response.Redirect("Myorders.aspx"); } else { Response.Redirect("Pricing.aspx"); } reader.Close(); this.RegisterStartupScript("alert", "<script lang='javascript'>alert('User not found');</script>"); } }