public bool ProfileUpdate(Query_DB cdbe) { string query = string.Format("update UserData set [Name]='{0}',[Email]='{1}',[Mobile]='{2}',[Address]='{3}' where [id]={4}", cdbe.NAME, cdbe.USER_EMAIL, cdbe.MOBILE, cdbe.ADDRESS, cdbe.ID); if (b1.NonQuery(query) == 1) { return(true); } return(false); }
public bool CartAdd(Query_DB cdb, String token, int cid) { bool temp = false; String query = String.Format("insert into Cart values({0}+1,{1},'{2}',{3},'{4}','{5}')", GetMaxID("Cart"), cdb.ID, DateTime.Now.ToString(), cid, "0", token); if (b1.NonQuery(query) == 1) { temp = true; } return(temp); }
public bool TestDriveAdd(Query_DB cdb, int cid) { bool temp = false; String query = String.Format("insert into TestDrive values({0}+1,{1},{2},'{3}','{4}')", GetMaxID("TestDrive"), cdb.ID, cid, "0", DateTime.Now.ToString()); if (b1.NonQuery(query) == 1) { temp = true; } return(temp); }
public bool CreateUser(Query_DB cdb) { bool temp = false; String query = String.Format("insert into UserData values('{0}','{1}','{2}','{3}','{4}',{5},{6}+1)", cdb.NAME, cdb.USER_EMAIL, cdb.MOBILE, cdb.PASSWORD, cdb.ADDRESS, cdb.USER_TYPE, GetMaxID("UserData")); if (b1.NonQuery(query) == 1) { temp = true; } return(temp); }
public bool FeedbackAdd(Query_DB cdb, String msg) { bool temp = false; String query = String.Format("insert into Feedback values({0}+1,{1},'{2}')", GetMaxID("Feedback"), cdb.ID, msg); if (b1.NonQuery(query) == 1) { temp = true; } return(temp); }
public bool VerifyAddUser(Query_DB cdb) { string query = string.Format("select count(*) from UserData where Email='{0}' and Password = '******' and UserType = 1", cdb.USER_EMAIL, cdb.PASSWORD); OleDbDataReader rec = b1.SelectQuery(query); while (rec.Read()) { if (rec[0].ToString().Equals("1")) { return(true); } } return(false); }
public bool CheckUser(Query_DB cdb) { bool temp = false; String query = String.Format("select count(*) from UserData where Email='{0}'", cdb.USER_EMAIL); OleDbDataReader rec = b1.SelectQuery(query); while (rec.Read()) { if (Convert.ToInt32(rec[0].ToString()) >= 1) { temp = true; } } return(temp); }
public Query_DB GetUserDetails(Query_DB cdb) { string query = string.Format("select id,Name,Email,Mobile,Password,Address,UserType from UserData where Email='{0}' and Password = '******'", cdb.USER_EMAIL, cdb.PASSWORD); OleDbDataReader rec = b1.SelectQuery(query); while (rec.Read()) { if (!rec[0].ToString().Equals(" ") && Convert.ToInt32(rec[0].ToString()) >= 1) { Query_DB utb = new Query_DB(); utb.ID = Convert.ToInt32(rec[0].ToString()); utb.NAME = rec[1].ToString(); utb.USER_EMAIL = rec[2].ToString(); utb.MOBILE = rec[3].ToString(); utb.PASSWORD = rec[4].ToString(); utb.ADDRESS = rec[5].ToString(); utb.USER_TYPE = Convert.ToInt32(rec[6].ToString()); return(utb); } } return(null); }
public CarView(Code.Query_DB cdbe, String a, String b, String c, String d, String f, String g, String h, String i, String j) { InitializeComponent(); utb = cdbe; pb = a; model = i; try { main.Image = Image.FromFile(System.IO.Directory.GetCurrentDirectory().Replace("\\bin\\Debug", "") + "\\image\\" + a + "\\1.jpg"); P1.Image = Image.FromFile(System.IO.Directory.GetCurrentDirectory().Replace("\\bin\\Debug", "") + "\\image\\" + a + "\\1.jpg"); P2.Image = Image.FromFile(System.IO.Directory.GetCurrentDirectory().Replace("\\bin\\Debug", "") + "\\image\\" + a + "\\2.jpg"); P3.Image = Image.FromFile(System.IO.Directory.GetCurrentDirectory().Replace("\\bin\\Debug", "") + "\\image\\" + a + "\\3.jpg"); P4.Image = Image.FromFile(System.IO.Directory.GetCurrentDirectory().Replace("\\bin\\Debug", "") + "\\image\\" + a + "\\4.jpg"); Mile.Text = b; Fuel.Text = c; Tank.Text = d; Engine.Text = f; Capacity.Text = g; Speed.Text = h; CName.Text = i; CPrice.Text = j; } catch (Exception e) { erro.Text = e.Message; } }
public ChangeProfile(Code.Query_DB cdbe) { InitializeComponent(); utb = cdbe; }
public TestDrive(Code.Query_DB cdbe, int car) { InitializeComponent(); utb = cdbe; carid = car; }
public MyOrder(Code.Query_DB cdbe) { InitializeComponent(); utb = cdbe; }
public Admin(Code.Query_DB cdbe) { InitializeComponent(); utb = cdbe; }
public Home(Code.Query_DB cdbe) { cdb = cdbe; InitializeComponent(); }
public MyTestDrive(Code.Query_DB cdbe) { InitializeComponent(); cdb = cdbe; }
public ChangePassword(Code.Query_DB cdbe) { InitializeComponent(); utb = cdbe; }
public SendFeedback(Code.Query_DB cd) { InitializeComponent(); cdb = cd; }