public tbl_ProductInfo GetProduct(int product_id)
{
try
{
using (WebshopManagementEntities db = new WebshopManagementEntities())
{
tbl_ProductInfo product = db.tbl_ProductInfo.Find(product_id);
return(product);
}
}
catch (Exception)
{
return(null);
}
}
protected void add_btn_Click(object sender, EventArgs e)
{
tbl_ProductInfo atbl_ProductInfo = new tbl_ProductInfo();
atbl_ProductInfo.Product_Id = txtProductId.Text;
atbl_ProductInfo.Product_Name = txtProductName.Text;
atbl_ProductInfo.Category_Id = Convert.ToInt16(ddlCategory.SelectedValue);
atbl_ProductInfo.Purchase_Rate = Convert.ToInt16(txtPurchase.Text);
atbl_ProductInfo.Sell_Rate = Convert.ToInt16(txtSell.Text);
atbl_ProductInfo.Brand_Id = Convert.ToInt16(ddlBrand.SelectedValue);
atbl_ProductInfo.Quantity = Convert.ToInt32(txtQuantity.Text);
atbl_ProductInfo.ReorderLebel = Convert.ToInt16(ddlReorder.Text);
atbl_ProductInfo.Product_Image = txtImage.Text;
atbl_ProductInfo.Product_Description = txtDescription.Text;
int count = (from emp in _context.tbl_ProductInfo
where emp.Product_Name == atbl_ProductInfo.Product_Name &&
emp.Category_Id == atbl_ProductInfo.Category_Id
select emp.Product_Name).Count();
if (count > 0)
{
msg_lbl.Visible = true;
msg_lbl.Text = "E-ID already exists!";
return;
}
objProductSetup_BLL.SaveProduct(atbl_ProductInfo);
msg_lbl.Visible = true;
msg_lbl.Text = "Data Save Successfully";
txtDescription.Text = "";
txtImage.Text = "";
txtPurchase.Text = "";
txtSell.Text = "";
txtProductName.Text = "";
ddlReorder.SelectedIndex = 0;
ddlCategory.SelectedIndex = -1;
}
internal int SaveProduct(tbl_ProductInfo atbl_ProductInfo)
{
return(objProductSetup_DAL.SaveProduct(atbl_ProductInfo));
}
