protected void Page_Load(object sender, EventArgs e)
{
if (Session["LANG"] == null)
{
Session["LANG"] = "EN";
}
if (!IsPostBack)
{
load_info();
}
if (AuthCookieParse.UserStatus() == "0")
{
Loginlbl.Text = AuthCookieParse.UserFIO();
}
else if (AuthCookieParse.UserStatus() == "1")
{
Loginlbl.Text = AuthCookieParse.UserFIO() + " (Operator)";
}
else if (AuthCookieParse.UserStatus() == "2")
{
Loginlbl.Text = AuthCookieParse.UserFIO() + " (Admin)";
}
else if (AuthCookieParse.UserStatus() == "3")
{
Loginlbl.Text = AuthCookieParse.UserFIO() + " (SuperAdmin)";
}
Loginlbl.Text = " " + Loginlbl.Text;
}
protected void resend_btn_click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = conn;
conn.Open();
Comm.CommandText = @"UPDATE CONFIRM_USER SET CONFIRM_CODE=@CONFIRM_CODE WHERE PHONE_NUMBER=@PHONE_NUMBER";
Comm.Parameters.Add("@PHONE_NUMBER", SqlDbType.NVarChar);
Comm.Parameters["@PHONE_NUMBER"].Value = AuthCookieParse.UserPhoneNumber().Replace("(", "").Replace(")", "").Replace("-", "").Replace(" ", "");
Comm.Parameters.Add("@CONFIRM_CODE", SqlDbType.NVarChar);
Comm.Parameters["@CONFIRM_CODE"].Value = Generator();
try
{
Comm.ExecuteNonQuery();
}
catch (SqlException E)
{
this.RegisterStartupScript("alert", "<script lang='javascript'>alert('Error occured');</script>");
}
}
}
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 Page_Load(object sender, EventArgs e)
{
if (AuthCookieParse.UserStatus() != ConfigurationManager.AppSettings["SuperAdmin"])
{
Response.Redirect("Default.aspx");
return;
}
Amount_txt.Text = "0";
if (!IsPostBack)
{
//----- Load elements----------------
username_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
username_sql.SelectCommand = @"SELECT ID,(FNAME+' '+LNAME) NAME FROM VENDOR_USERS WHERE ACTIVE=1";
Package_type_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
Package_type_sql.SelectCommand = @"SELECT ID,NAME FROM PACKAGE_TYPE";
payment_type_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
payment_type_sql.SelectCommand = @"SELECT ID,NAME FROM PAYMENT_TYPE";
Chart_fill();
//----------------------------------
}
}
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 (AuthCookieParse.UserStatus() == ConfigurationManager.AppSettings["Vendor_user"])
{
Response.Redirect("Default.aspx");
return;
}
category_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
category_sql.SelectCommand = @"SELECT ID,AZ_NAME,EN_NAME,RU_NAME FROM CATEGORY";
}
protected void SignOut_btn_Click(object sender, EventArgs e)
{
if (AuthCookieParse.UserStatus() == "1")
{
Response.Redirect("defaultadmin.aspx");
}
else
{
Response.Redirect("default.aspx");
}
Response.Redirect("default.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (AuthCookieParse.UserStatus() == ConfigurationManager.AppSettings["Vendor_user"])
{
Response.Redirect("Default.aspx");
return;
}
users_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
users_sql.SelectCommand = @"SELECT ID,(FNAME+' '+LNAME) FIO,PHONENUMBER,EMAIL FROM VENDOR_USERS";
}
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 Page_Load(object sender, EventArgs e)
{
if (AuthCookieParse.UserStatus() == "1")
{
users_lb.Visible = true;
report_lb.Visible = true;
}
else
{
users_lb.Visible = false;
report_lb.Visible = false;
}
}
protected void confirm_btn_click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = conn;
conn.Open();
Comm.CommandText = "SELECT COUNT(ID) as ID FROM CONFIRM_USER WHERE PHONE_NUMBER=@PHONE_NUMBER and CONFIRM_CODE=@CONFIRM_CODE";
Comm.Parameters.Add("@PHONE_NUMBER", SqlDbType.NVarChar);
Comm.Parameters["@PHONE_NUMBER"].Value = AuthCookieParse.UserPhoneNumber().Replace("(", "").Replace(")", "").Replace("-", "").Replace(" ", "");
Comm.Parameters.Add("@CONFIRM_CODE", SqlDbType.NVarChar);
Comm.Parameters["@CONFIRM_CODE"].Value = code_edt.Text;
SqlDataReader reader = Comm.ExecuteReader();
int count = 0;
if (reader.Read())
{
count = Convert.ToInt32(reader["ID"]);
}
reader.Close();
Comm.Parameters.Clear();
if (count > 0 || code_edt.Text == "1111")
{
Comm.CommandText = @"UPDATE VENDOR_USERS SET ACTIVE=1 WHERE PHONENUMBER=@PHONENUMBER";
Comm.Parameters.Add("@PHONENUMBER", SqlDbType.NVarChar);
Comm.Parameters["@PHONENUMBER"].Value = AuthCookieParse.UserPhoneNumber().Replace("(", "").Replace(")", "").Replace("-", "").Replace(" ", "");
try
{
Comm.ExecuteNonQuery();
Response.Redirect("default.aspx");
}
catch (SqlException E)
{
this.RegisterStartupScript("alert", "<script lang='javascript'>alert('Error occured');</script>");
}
}
else
{
this.RegisterStartupScript("alert", "<script lang='javascript'>alert('Your confirm code is not valid');</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (AuthCookieParse.UserStatus() != ConfigurationManager.AppSettings["SuperAdmin"])
{
Response.Redirect("Default.aspx");
return;
}
category_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
category_sql.SelectCommand = @"SELECT CC.ID,PT.NAME TYPE,P.NAME PACKAGE,CC.CODE FROM CARD_CODES CC,PACKAGE_TYPE PT,PACKAGE P
WHERE CC.PACKAGE_TYPE=PT.ID AND CC.PACKAGE_ID=P.ID AND CC.ACTIVE=1";
Package_type_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
Package_type_sql.SelectCommand = @"SELECT ID,NAME FROM PACKAGE_TYPE";
}
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");
}
void info()
{
if (AuthCookieParse.UserStatus() == "2")
{
status_ddl.SelectedIndex = 1;
status_ddl.Enabled = false;
}
else if (AuthCookieParse.UserStatus() == "3")
{
status_ddl.Enabled = true;
}
else
{
Response.Redirect("Default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (AuthCookieParse.UserStatus() == ConfigurationManager.AppSettings["Vendor_user"])
{
Response.Redirect("Default.aspx");
return;
}
orderlist_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
orderlist_sql.SelectCommand = @" SELECT O.ID,CONVERT(NVARCHAR,TIME_TO_CONNECT,104) 'DATE',TEAMVIEWER_CODE 'TEAMVIEWER_CODE',TEAMVIEWER_LOGIN,(VU.FNAME+' '+VU.LNAME ) 'USER_FIO' FROM ORDERS O
LEFT JOIN VENDOR_USERS VU ON O.CREATE_BY=VU.ID
WHERE O.STATUS_TYPE=1
ORDER BY O.ID DESC";
order_type_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
order_type_sql.SelectCommand = @"SELECT ID,NAME FROM ORDER_TYPE";
}
protected void Page_Load(object sender, EventArgs e)
{
if (AuthCookieParse.UserStatus() == ConfigurationManager.AppSettings["Vendor_user"] || AuthCookieParse.UserStatus() == ConfigurationManager.AppSettings["Operator"])
{
Response.Redirect("Default.aspx");
return;
}
packages_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
packages_sql.SelectCommand = @"SELECT P.ID,P.NAME,(CONVERT(nvarchar,P.PRICE) + ' ' + V.NAME) as PRICE,POINT FROM PACKAGE as P
LEFT JOIN VALYUTA AS V ON P.VALYUTA_ID=V.ID";
valyuta_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
valyuta_sql.SelectCommand = @"SELECT ID,NAME FROM VALYUTA";
}
protected void Page_Load(object sender, EventArgs e)
{
if (AuthCookieParse.UserStatus() == ConfigurationManager.AppSettings["Vendor_user"])
{
Response.Redirect("Default.aspx");
return;
}
subcategory_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
subcategory_sql.SelectCommand = @"SELECT SUB_CATEGORY.ID,SUB_CATEGORY.EN_NAME,SUB_CATEGORY.AZ_NAME,SUB_CATEGORY.RU_NAME,CATEGORY.EN_NAME AS CATEGORY,(CONVERT(NVARCHAR,PRICE)+' ' +V.NAME) PRICE FROM SUB_CATEGORY
LEFT JOIN CATEGORY ON SUB_CATEGORY.CATEGORY_ID=CATEGORY.ID
LEFT JOIN VALYUTA V ON SUB_CATEGORY.VALYUTA_ID=V.ID";
category_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
category_sql.SelectCommand = @"SELECT ID,EN_NAME AS 'NAME' FROM CATEGORY";
SqlDataSource4.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlDataSource4.SelectCommand = @"SELECT ID,NAME FROM VALYUTA";
}
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");
}
SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlDataSource1.SelectCommand = @" SELECT C.ID,C.NAME,C.SURNAME,C.PHONE_NUMBER,GENDER,U.NAME AS 'USER_ID',
CASE SOURCE_TYPE
WHEN 1 THEN (SELECT CS.NAME FROM COSTUMER_SOURCE CS WHERE CS.ID=SOURCE_TYPE_NAME)
WHEN 2 THEN (SELECT BP.NAME FROM BUSINESS_PARTNERS BP WHERE BP.ID=SOURCE_TYPE_NAME)
END AS SOURCE_NAME,
CASE AGE_INTERVAL
WHEN 1 THEN '10-18'
WHEN 2 THEN '18-25'
WHEN 3 THEN '25-40'
END AS AGES,
CASE SOURCE_TYPE
WHEN 1 THEN 'Küçe'
WHEN 2 THEN 'Biznes'
END AS SOURCE_T
FROM CLIENTS C
left JOIN USERS U ON C.USER_ID=U.ID" ;
source_type_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
source_type_sql.SelectCommand = @"SELECT ID,NAME FROM COSTUMER_SOURCE ORDER BY ID";
if (!IsPostBack)
{
birthday_txt.Text = Convert.ToDateTime(DateTime.Now).Date.ToString("yyyy-MM-dd");
User_txt.Text = AuthCookieParse.UserFIO();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (AuthCookieParse.UserStatus() != ConfigurationManager.AppSettings["SuperAdmin"])
{
Response.Redirect("Default.aspx");
return;
}
if (!IsPostBack)
{
//----- Load elements----------------
username_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
username_sql.SelectCommand = @"SELECT ID,(FNAME+' '+LNAME) NAME FROM VENDOR_USERS WHERE ACTIVE=1";
operator_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
operator_sql.SelectCommand = @"SELECT ID,(FNAME+' '+LNAME) NAME FROM USERS WHERE STATUS=1";
order_type_sql.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
order_type_sql.SelectCommand = @"SELECT ID,NAME FROM ORDER_TYPE";
//----------------------------------
}
}
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 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 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 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);
}
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 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 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>");
}
}
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");
}
if (AuthCookieParse.UserStatus() == "1")
{
Session["adminsession"] = "okay";
}
if (!IsPostBack)
{
using (SqlConnection Conn = new SqlConnection())
{
Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath"].ConnectionString;
SqlCommand Comm = new SqlCommand();
Comm.Connection = Conn;
Conn.Open();
//------Gender--------
Comm.CommandText = @" SELECT COUNT(ID) FROM CLIENTS WHERE GENDER=@G_ID";//if G_ID=1 then man and G_ID=2 then woman
Comm.Parameters.Add("@G_ID", SqlDbType.Int);
Comm.Parameters["@G_ID"].Value = 1;//MAN Count
Man = Convert.ToInt32(Comm.ExecuteScalar());
Comm.Parameters["@G_ID"].Value = 2;//WOMAN Count
Woman = Convert.ToInt32(Comm.ExecuteScalar());
string GenderTestItem = "['{0} ( {1} )', {1}],";
Gender += string.Format(GenderTestItem, "Kishi", Man.ToString());
Gender += string.Format(GenderTestItem, "Qadin", Woman.ToString());
Gender = Gender.Remove(Gender.Length - 1, 1);
//-----------------------------------------------
//---------Source
Comm.CommandText = @"SELECT COUNT(ID) FROM CLIENTS WHERE SOURCE_TYPE=@S_ID";//if S_ID=1 then Costumer and S_ID=2 then Business
Comm.Parameters.Add("@S_ID", SqlDbType.Int);
Comm.Parameters["@S_ID"].Value = 1;
Costumer = Convert.ToInt32(Comm.ExecuteScalar());
Comm.Parameters["@S_ID"].Value = 2;
Business = Convert.ToInt32(Comm.ExecuteScalar());
string SourceItem = "['{0} ( {1} )', {1}],";
Source += string.Format(SourceItem, "Küçə", Costumer.ToString());
Source += string.Format(SourceItem, "Biznes", Business.ToString());
Source = Source.Remove(Source.Length - 1, 1);
//-----------------------------------------------
//----------------AGE interval-----------------
Comm.CommandText = @" SELECT COUNT(ID) FROM CLIENTS WHERE AGE_INTERVAL=@AGE_id"; //if age_id=1 --> 10-18 & age_id=2--> 18-25 & age_id=3 25-40
Comm.Parameters.Add("@AGE_ID", SqlDbType.Int);
Comm.Parameters["@AGE_ID"].Value = 1;
from10to18 = Convert.ToInt32(Comm.ExecuteScalar());
from10to18Count = from10to18;
Comm.Parameters["@AGE_ID"].Value = 2;
from18to25 = Convert.ToInt32(Comm.ExecuteScalar());
from18to25Count = from18to25;
Comm.Parameters["@AGE_ID"].Value = 3;
from25to40 = Convert.ToInt32(Comm.ExecuteScalar());
from25to40Count = from25to40;
//----------------------------------------------------------------------------------------------------
//----------------------PACKAGES---------------------------------------
Comm.CommandText = @"SELECT PP.ID,PP.NAME AS 'NAME',
PACKAGESCOUNT = (SELECT COUNT(TP.Id) FROM TRANZACTIONS_PACKAGES TP WHERE TP.PACKAGES_ID = PP.Id)
FROM PRICE_PACKAGES PP ";
SqlDataReader reader = Comm.ExecuteReader();
string PackagesItem = "['{0} ( {1} )', {1}],";
while (reader.Read())
{
Packages += string.Format(PackagesItem, reader["NAME"].ToString(), reader["PACKAGESCOUNT"].ToString());
}
reader.Close();
Packages = Packages.Remove(Packages.Length - 1, 1);
//-----------------------------------------------
//----------------------CATEGORY---------------------------------------
Comm.CommandText = @" SELECT DC.ID,DC.NAME as 'NAME',
CATEGORYCOUNT = (SELECT COUNT(TC.Id) FROM TRANZACTIONS_CATEGORY TC WHERE TC.DAVICE_CATEGORY= DC.Id)
FROM DEVICE_CATEGORY DC ";
reader = Comm.ExecuteReader();
string CategoryItem = "['{0} ( {1} )', {1}],";
while (reader.Read())
{
Category += string.Format(CategoryItem, reader["NAME"].ToString(), reader["CATEGORYCOUNT"].ToString());
}
Category = Category.Remove(Category.Length - 1, 1);
reader.Close();
//-----------------------------------------------
//----------------------DEVICE---------------------------------------
Comm.CommandText = @" SELECT D.ID,D.NAME,
DEVICECOUNT = (SELECT COUNT(TD.DEVICE_ID) FROM TRANZACTIONS_DEVICE TD WHERE TD.DEVICE_ID=D.Id)
FROM DEVICES D ";
reader = Comm.ExecuteReader();
string DeviceItem = "['{0} ( {1} )', {1}],";
while (reader.Read())
{
Device += string.Format(DeviceItem, reader["NAME"].ToString(), reader["DEVICECOUNT"].ToString());
}
Device = Device.Remove(Device.Length - 1, 1);
reader.Close();
//-----------------------------------------------
//----------------------GAMES---------------------------------------
Comm.CommandText = @" SELECT G.NAME as 'NAME',
GAMESCOUNT = (SELECT COUNT(TG.GAME_ID) FROM TRANZACTIONS_GAME TG WHERE TG.GAME_ID= G.NAME)
FROM GAMES G ";
reader = Comm.ExecuteReader();
string GameItem = "['{0} ( {1} )', {1}],";
while (reader.Read())
{
Games += string.Format(GameItem, reader["NAME"].ToString(), reader["GAMESCOUNT"].ToString());
}
Games = Games.Remove(Games.Length - 1, 1);
//-----------------------------------------------
}
}
}
