protected void btnAdd_Click(object sender, EventArgs e)
{
using (var db = new bigshopeEntities())
{
if (Request.QueryString["prod_id"] != null)
{
int prod_id = Convert.ToInt32(Request.QueryString["prod_id"]);
tblProduct p = db.tblProducts.FirstOrDefault(v => v.prod_id == prod_id);
p.prod_name = tbName.Text;
p.prod_desc = tbDesc.Text;
p.prod_price = Convert.ToInt32(tbPrice.Text);
p.prod_qnty = Convert.ToInt32(tbQty.Text);
p.prod_ram = tbRAM.Text;
db.SaveChanges();
Response.Redirect("productrecord.aspx");
}
else
{
//Forign Keys
int brnd_key = Convert.ToInt32(slctBrand.SelectedValue);
int proc_key = Convert.ToInt32(slctProc.SelectedValue);
int gen_key = Convert.ToInt32(slctGen.SelectedValue);
String img = fileImage.FileName.ToString();
int prod_qnty = Convert.ToInt32(tbQty.Text);
string folderPath = Server.MapPath("Files/");
//Check whether Directory (Folder) exists.
if (Directory.Exists(folderPath) != true)
{
//If Directory (Folder) does not exists Create it.
Directory.CreateDirectory(folderPath + fileImage.FileName);
}
//Save the File to the Directory (Folder).
fileImage.SaveAs(folderPath + Path.GetFileName(fileImage.FileName));
db.addProducts(tbName.Text, tbDesc.Text, tbPrice.Text, img, prod_qnty, tbRAM.Text, brnd_key, proc_key, gen_key);
lblStatus.Text = "Product added successfully!";
tbName.Text = "";
tbDesc.Text = "";
tbPrice.Text = "";
tbQty.Text = "";
tbRAM.Text = "";
db.SaveChanges();
}
}
}
