//chack if the user exicte
protected void RestPassword_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
sql_class sql = new sql_class();
//sql.Where("UserName", userPassinput.Text);
sql.Where("Email", useremailinput.Text);
DataTable data = sql.Get("Garage", "Email", "FIRST_NAME", "GaragID");
if (data.Rows.Count > 0)
{
string UserID = data.Rows[0]["GaragID"].ToString();
string ID = RandomPassword(UserID);
string addressee = data.Rows[0]["Email"].ToString();
string user = data.Rows[0]["FIRST_NAME"].ToString();
SendMeilRestPassword(addressee, user, ID, UserID);
lbmessage.Text = "נשלח קישור לכתובת המייל לצורך איפוס!";
}
else
{
lbmessage.ForeColor = System.Drawing.Color.Red;
lbmessage.Text = "לא קיים חשבון כזה במערכת,אנא פנה לצוות הלקוחות!";
}
}
else
{
lbmessage.ForeColor = System.Drawing.Color.Red;
lbmessage.Text = "חובה למלא שדות חובה!";
}
}
protected void sumbit_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
string Encryptedpass = FormsAuthentication.HashPasswordForStoringInConfigFile(OldPasID.Text, "SHA1");
//var ID = Convert.ToInt32();
sql_class sql_ = new sql_class();
sql_.Where("Password", Encryptedpass);
sql_.Where("GaragID", Session["UserID"].ToString());
DataTable data = sql_.Get("Garage", "Password");
if (data.Rows.Count > 0)
{
UpdatePassword();
}
else
{
lblmessage.ForeColor = System.Drawing.Color.Red;
lblmessage.Text = "סיסמא שגויה";
}
}
catch (Exception Error)
{
lblmessage.Text = Error.ToString();
}
}
else
{
lblmessage.ForeColor = System.Drawing.Color.Red;
lblmessage.Text = "חובה למלא שדות חובה!";
}
}
public static List <KeyValuePair <string, int> > ReloadCity(string parm)
{
List <string> City = new List <string>();
List <KeyValuePair <string, int> > dataList = new List <KeyValuePair <string, int> >();
sql_class sqlQuery = new sql_class();
sqlQuery.WhereLIKE("CityName", parm);
sqlQuery.Limit(5);
DataTable data = sqlQuery.Get("City", "CityName", "CityID");
if (data.Rows.Count == 0)
{
dataList.Add(new KeyValuePair <string, int>("לא נמצאו התאמות", -1));
}
var sizedata = data.Rows.Count;
var i = 0;
while (sizedata > 0)
{
dataList.Add(new KeyValuePair <string, int>(data.Rows[i]["CityName"].ToString(), Convert.ToInt32(data.Rows[i]["CityID"])));
sizedata--;
i++;
}
return(dataList);
}
protected void SubmitID_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
sql_class sql = new sql_class();
sql.Where("codeNumber", Request.QueryString["id"]);
sql.Where("GaragID", Request.QueryString["userID"]);
sql.Where("active", true.ToString());
DataTable data = sql.Get("RestUserAdmin");
if (data.Rows.Count > 0)
{
UpdatePassword();
}
else
{
lblmessage.ForeColor = System.Drawing.Color.Red;
lblmessage.Text = "קישור זה כבר פג תוקף!";
}
}
catch
{
throw;
}
}
else
{
lblmessage.ForeColor = System.Drawing.Color.Red;
lblmessage.Text = "חובה למלא שדות חובה!";
}
}
//cheack if UserName Exsicte
protected bool CheackUserName()
{
try
{
sql_class data = new sql_class();
data.Where("IdCard", tbUser.Text);
data.Where("GaragID", Session["UserID"].ToString());
DataTable HesRow = data.Get("EmployeModel");
if (HesRow.Rows.Count > 0)
{
lblusercheck.Text = "תעודת זהות זו כבר בשימוש";
lblusercheck.ForeColor = System.Drawing.Color.Red;
tbUser.Text = "";
return(true);
}
else
{
lblusercheck.Text = "";
return(false);
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "Error!", "alert('" + ex.Message.Replace("'", @"\'") + "');", true);
return(false);
}
}
public DataTable getPart(string teratmentID)
{
sql_class sql = new sql_class();
sql.Where("teratmentID", teratmentID);
DataTable data = sql.Get("CartModel");
return(data);
}
//get history off all repairjob
public void historyRepairJob(string CustomerID)
{
sql_class sql = new sql_class();
sql.Where("CustomerID", CustomerID);
DataTable data = sql.Get("RepairJob");
shwoHistory.DataSource = data;
shwoHistory.DataBind();
}
//Func Login Admin
public static DataTable get_data(string user, [Optional] string password, [Optional] string status, params string[] User)
{
sql_class new_data = new sql_class();
new_data.Where("Email", user);
new_data.Where("Password", password);
new_data.Where("Status", status);
DataTable data = new_data.Get("Garage", User);
return(data);
}
//Checks if the account has been approved
protected void AccountVefiad()
{
sql_class sql = new sql_class();
sql.Where("Email", Request.QueryString["tb_email"]);
//sql.Where("UserName", Request.QueryString["UserName"]);
DataTable data = sql.Get("Garage", "Status");
if (data.Rows[0]["Status"].ToString().ToUpper() == "True".ToUpper())
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('חשבון זה כבר מאושר!')", true);
Response.Redirect("~/Login.aspx");
}
}
//cheack if email Exsicte
public bool CheackUserName()
{
sql_class sql_data = new sql_class();
sql_data.Where("Email", tb_email.Text);
DataTable data = sql_data.Get("Garage");
if (data.Rows.Count > 0)
{
Label1.Text = "נראה שחשבון מייל זה כבר נמצא בשימוש";
Label1.ForeColor = System.Drawing.Color.Red;
tb_email.Text = "";
return(true);
}
else
{
Label1.Text = "";
return(false);
}
}
// return customerid
protected string GetCustomerid()
{
try
{
sql_class Check = new sql_class();
Check.Where("UsarName", tbUser.Text);
DataTable data = Check.Get("Customer", "CustomerID");
if (data.Rows.Count > 0)
{
return(data.Rows[0]["CustomerID"].ToString());
}
else
{
Response.Redirect("~/error-500.html");
return(null);
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "Error!", "alert('" + ex.Message.Replace("'", @"\'") + "');", true);
return(null);
}
}
//chack if the code is right
protected void log_Click(object sender, EventArgs e)
{
sql_class sql_new = new sql_class();
sql_new.Where("Email", Request.QueryString["tb_email"].ToString());
//sql_new.Where("UserName", Request.QueryString["UserName"].ToString());
DataTable data = sql_new.Get("Garage");
if (data.Rows.Count > 0)
{
string activshncode = "";
activshncode = data.Rows[0]["Activecode"].ToString();
if (activshncode == tb_code.Value)
{
changestatus();
Response.Redirect("~/Login.aspx");
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('קוד לא נכון')", true);
}
}
//con.Close();
}
public static List <string> AutoCompilteId_card(string parm)
{
List <string> autoid = new List <string>();
sql_class sqlQuery = new sql_class();
sqlQuery.WhereLIKE("UsarName", parm);
sqlQuery.Limit(5);
DataTable data = sqlQuery.Get("Customer", "UsarName");
if (data.Rows.Count == 0)
{
autoid.Add("לא נמצאו התאמות");
}
var sizedata = data.Rows.Count;
var i = 0;
while (sizedata > 0)
{
autoid.Add(data.Rows[i]["UsarName"].ToString());
sizedata--;
i++;
}
return(autoid);
}