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