public bool InsertItem(bookinterface item)
{
using (objMyLq = new alamaatDBDataContext())
{
try
{
alamaat_product newitem = new alamaat_product();
newitem.id = Guid.NewGuid();
newitem.productname = item.Name;
newitem.category = item.Category;
newitem.originalprice = item.OriginalPrice;
newitem.details = item.Details;
newitem.rating = item.Rating;
newitem.created = DateTime.Now;
newitem.lastmodified = DateTime.Now;
newitem.fileid = item.Imageid;
newitem.discount = item.Discount;
newitem.price = item.Price;
objMyLq.alamaat_products.InsertOnSubmit(newitem);
objMyLq.SubmitChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool UpdateItem(bookinterface item)
{
using (objMyLq = new alamaatDBDataContext())
{
try
{
var objcontent = objMyLq.alamaat_products.Where(p => p.id == item.ID).FirstOrDefault();
if (null != objcontent)
{
objcontent.productname = item.Name;
objcontent.category = item.Category;
objcontent.originalprice = item.OriginalPrice;
objcontent.discount = item.Discount;
objcontent.price = item.Price;
objcontent.details = item.Details;
objcontent.rating = item.Rating;
objcontent.lastmodified = DateTime.Now;
objcontent.fileid = item.Imageid;
objMyLq.SubmitChanges();
return(true);
}
return(false);
}
catch (Exception e)
{
return(false);
}
}
}
protected void Saved_Product(object sender, EventArgs e)
{
books bookcontent = new books();
if (ProductId.Value != null && ProductId.Value != string.Empty)
{
alamaat_product item = bookcontent.GetproductById(new Guid(ProductId.Value.ToString()));
if (null != item)
{
bookinterface newitem = new bookinterface();
newitem.ID = item.id;
newitem.Name = tbname.Text;
newitem.Category = new Guid(ComboCategory.SelectedValue.ToString());
newitem.OriginalPrice = Convert.ToDecimal(tbprice.Text);
newitem.Discount = Convert.ToInt16(tbdiscount.Text);
newitem.Price = Convert.ToDecimal(tbSaleprice.Text);
newitem.Details = tbdetails.Text;
newitem.Imageid = new Guid(ImgId.Value.ToString());
if (bookcontent.UpdateItem(newitem))
{
lbloutput.Text = "Item Updated Successfully.";
clear();
}
}
}
else
{
bookinterface newitem = new bookinterface();
newitem.Name = tbname.Text;
newitem.Category = new Guid(ComboCategory.SelectedValue.ToString());
newitem.OriginalPrice = Convert.ToDecimal(tbprice.Text);
newitem.Discount = Convert.ToInt16(tbdiscount.Text);
newitem.Price = Convert.ToDecimal(tbSaleprice.Text);
newitem.Details = tbdetails.Text;
newitem.Imageid = new Guid(ImgId.Value.ToString());
if (bookcontent.InsertItem(newitem))
{
lbloutput.Text = "Item Saved Successfully.";
clear();
}
}
}
