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