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