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