protected void BtnSave_Click(object sender, EventArgs e) { string ConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\ShopDb.mdb"; string FileName = GlobalFunc.GetRandomFileName(6); string t1 = UploadPicName.FileName; string FullPath = Server.MapPath("/img/"); string FileExt = System.IO.Path.GetExtension(UploadPicName.PostedFile.FileName); FileName += FileExt; FullPath += FileName; UploadPicName.SaveAs(FullPath); LtlMsg.Text = FullPath; string Sql = "insert into T_Product(ProdName,Price,ShortDesc,LongDesc,PicName) values ('"; Sql += TxtPname.Text + "'," + TxtPrice.Text + ",'" + TxtShortDesc.Text + "','" + TxtLongDesc.InnerHtml + "','" + FileName + "')"; OleDbConnection Conn = new OleDbConnection(ConnStr); Conn.Open(); OleDbCommand Cmd = new OleDbCommand(); Cmd.Connection = Conn; Cmd.CommandText = Sql; Cmd.ExecuteNonQuery(); Conn.Close(); GlobalFuncDbS.LoadProds(); LtlMsg.Text = "המוצר עודכן בהצלחה"; LtlMsg.Text = FullPath; }
protected void BtnLog_Click(object sender, EventArgs e) { string Name = Fname.Text; string Fmail = Email.Text; string Fpass = Pass.Text; LitLog.Text = "<br/>" + "נרשמת הבצלחה" + " " + Name + "<br/>" + "שם המשתמש שלך הוא" + " " + Fmail; GlobalFunc.AddToCustomer(Fname.Text, Lname.Text, Phone.Text, Address.Text, City.Text, Email.Text, Pass.Text); GlobalFuncDbS.LoadUser(); var ArrUser = Application["ArrU"] as List <User>; for (int i = 0; i < ArrUser.Count; i++) { if (Email.Text == ArrUser[i].EMAIL && Pass.Text == ArrUser[i].PASSWORD) { Session["email"] = ArrUser[i].EMAIL; Session["Login"] = i; Response.Redirect("Default.aspx"); } } Response.Redirect("Default.aspx"); //string ConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\ShopDb.mdb"; //string Sql = "insert into T_Customer(Fname,Lname,PhonN,Address,City,CEmail,CPaas) values ('"; //Sql += Fname.Text + "','" + Lname.Text + "','" + Phone.Text + "','" + Address.Text + "','" + City.Text + "','" + Email.Text + "','" + Pass.Text + "')"; //OleDbConnection Conn = new OleDbConnection(ConnStr); // יצירת אובייקט מסוג קונקשן- צינור התחברות לבסיס הנתונים //Conn.Open();// פתיחת החיבור לבסיס הנתונים //OleDbCommand Cmd = new OleDbCommand();// יצירת אובייקט מסוג פקודה //Cmd.Connection = Conn;// אתחול המאפיין קונקשן של אובייקט הפקודה עם הקונקשן שיצרנו //Cmd.CommandText = Sql;//הגדרת משפט הפקודה אותו יש לבצע //Cmd.ExecuteNonQuery(); //Conn.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (Request["Prodid"] == null) { Response.Redirect("Default.aspx"); } int prodid = int.Parse(Request["Prodid"]); RtpSumMonth.DataSource = GlobalFuncDbS.GetsumsaleMonth(prodid); RtpSumMonth.DataBind(); RtpSumYear.DataSource = GlobalFuncDbS.GetsumsaleYear(prodid); RtpSumYear.DataBind(); RtpD.DataSource = GlobalFunc.GetSomeProd(prodid); RtpD.DataBind(); }
public static void ProductPromotion(int pid)//עדכון פרטי מוצר { string ConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\ShopDb.mdb"; string Sql = "UPDATE T_Product SET Ns=true WHERE Pid=" + pid + ""; OleDbConnection Conn = new OleDbConnection(ConnStr); Conn.Open(); OleDbCommand Cmd = new OleDbCommand(); Cmd.Connection = Conn; Cmd.CommandText = Sql; Cmd.ExecuteNonQuery(); Conn.Close(); GlobalFuncDbS.LoadProds(); }
public static void ChangeValuesProd(int pid, string fname, string shortdec, string longdec, int price, string type)//עדכון פרטי מוצר { string ConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\ShopDb.mdb"; string Sql = "UPDATE T_Product SET ProdName='" + fname + "',Price=" + price + ",ShortDesc='" + shortdec + "',LongDesc='" + longdec + "',Type='" + type + "' WHERE Pid=" + pid + ""; OleDbConnection Conn = new OleDbConnection(ConnStr); Conn.Open(); OleDbCommand Cmd = new OleDbCommand(); Cmd.Connection = Conn; Cmd.CommandText = Sql; Cmd.ExecuteNonQuery(); Conn.Close(); GlobalFuncDbS.LoadProds(); }
public static void AddMsgToMang(int Cid, string Title, string Main)//הוספת הודעה למערכת { string ConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\ShopDb.mdb"; string Sql = "insert into T_Mail(Mcustid,Mtitle,Main) values ('"; Sql += Cid + "','" + Title + "','" + Main + "')"; OleDbConnection Conn = new OleDbConnection(ConnStr); Conn.Open(); OleDbCommand Cmd = new OleDbCommand(); Cmd.Connection = Conn; Cmd.CommandText = Sql; Cmd.ExecuteNonQuery(); Conn.Close(); GlobalFuncDbS.LoadUser(); }
public static void AddToCustomer(string Fname, string Lname, string Phone, string Address, string City, string Email, string Pass)//הוספת משתמש למערכת { string ConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\ShopDb.mdb"; string Sql = "insert into T_Customer(Fname,Lname,PhonN,Address,City,CEmail,CPaas) values ('"; Sql += Fname + "','" + Lname + "','" + Phone + "','" + Address + "','" + City + "','" + Email + "','" + Pass + "')"; OleDbConnection Conn = new OleDbConnection(ConnStr); Conn.Open(); OleDbCommand Cmd = new OleDbCommand(); Cmd.Connection = Conn; Cmd.CommandText = Sql; Cmd.ExecuteNonQuery(); Conn.Close(); GlobalFuncDbS.LoadUser(); }
protected void Page_Load(object sender, EventArgs e) { if (Request["numor"] == null) { Response.Redirect("Default.aspx"); } int numor = int.Parse(Request["numor"]); if (int.Parse(Request["op"]) == 2) { GlobalFuncDbU.CloseOrder(numor); Response.Redirect("OrderManagement.aspx"); } RtpCp.DataSource = GlobalFuncDbS.GetOrderPartiallyClosed(numor); RtpCp.DataBind(); LtrNO.Text = "<button type='button' class='btn btn-outline-dark btn-lg btn-block'>מספר הזמנה-" + numor + "</button>"; }
protected void Page_Load(object sender, EventArgs e) { var ArrOrder = Application["ArrOr"] as List <ShoppingCart>; if (Request["numor"] == null || Request["custid"] == null) { Response.Redirect("Default.aspx"); } int numor = int.Parse(Request["numor"]); int cusid = int.Parse(Request["custid"]); RtpH.DataSource = GlobalFuncDbS.GetSomeOrderDistinct(numor); RtpH.DataBind(); RtpOR.DataSource = GlobalFuncDbS.GetSomeOrder(numor); RtpOR.DataBind(); RtpSum.DataSource = GlobalFuncDbS.GetSumPriceOrder(numor); RtpSum.DataBind(); RtpUs.DataSource = GlobalFunc.GetOrderDetelFCust(cusid); RtpUs.DataBind(); int i, count = 0; var temp = ""; for (i = 0; i < ArrOrder.Count; i++) { if (ArrOrder[i].numor == numor.ToString()) { if (ArrOrder[i].recloes == "פתוח") { count++; } } } if (count != 0) { temp += "<a href='PartiallyClosed.aspx?numor=" + numor + "&op=1' class='btn btn-outline-success btn-lg btn-block'>סגירה חלקית</a>"; temp += "<a href='PartiallyClosed.aspx?numor=" + numor + "&op=2' class='btn btn-outline-success btn-lg btn-block'>סגור הזמנה</a>"; } else { temp += "<button type='button' class='btn btn-outline-dark btn-lg btn-block'>ההזמנה סגורה</button>"; } Literal1.Text = temp; }
protected void Page_Load(object sender, EventArgs e) { if (Request["SuNu"] == null) { Response.Redirect("Default.aspx"); } string SumCart = Request["SuNu"]; GlobalFunc.SendSummryCart("*****@*****.**", Session["email"].ToString(), "אישור הזמנה", SumCart); if (Session["Login"] == null) { Response.Redirect("LogIn.aspx"); } int numor = int.Parse(SumCart); var Cart = Session["Cart"] as Cart; var ArrUser = Application["ArrU"] as List <User>; int Co = int.Parse(Session["Login"].ToString()); RtpAccount.DataSource = GlobalFunc.GetCustomer(Co + 1); RtpAccount.DataBind(); RtpSum.DataSource = GlobalFuncDbS.GetSumPriceOrder(numor); RtpSum.DataBind(); Session["Cart"] = null; }
protected void Page_Load(object sender, EventArgs e) { RypT.DataSource = GlobalFuncDbS.GetAllOrders(); RypT.DataBind(); }