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 alamaat_product Getproductbyid(string id)
{
//
alamaat_product item = objMyLq.alamaat_products.FirstOrDefault(ku => ku.id.ToString().Equals(id));
return(item);
}
public alamaat_product GetproductById(Guid id)
{
alamaat_product item = objMyLq.alamaat_products.Where(ku => ku.id.Equals(id)).FirstOrDefault();
if (item != null)
{
return(item);
}
else
{
return(null);
}
}
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();
}
}
}
protected void EditClick(object sender, CommandEventArgs e)
{
lbloutput.Text = "";
Guid id = new Guid((e.CommandArgument).ToString());
books bookcontent = new books();
alamaat_product item = bookcontent.GetproductById(id);
if (null != item)
{
ProductId.Value = id.ToString();
tbname.Text = item.productname;
if (item.originalprice != null)
{
tbprice.Text = item.originalprice.ToString();
}
else
{
tbprice.Text = item.price.ToString();
}
ComboCategory.SelectedValue = item.category.ToString();
tbdetails.Text = item.details;
if (item.fileid != null)
{
ImgId.Value = item.fileid.ToString();
Img.ImageUrl = "~/ShowImage2.ashx?id=" + item.fileid;
Thumb ImageThumb = new Thumb();
List <ProductThumb> list = ImageThumb.GetListbyid(ImgId.Value);
DataList1.DataSource = list;
DataList1.DataBind();
}
if (item.discount != null)
{
tbdiscount.Text = item.discount.ToString();
}
else
{
tbdiscount.Text = "0";
}
tbSaleprice.Text = item.price.ToString();
tbname.Focus();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["id"];
string page = Request.QueryString["page"];
btnback.HRef = "../" + page + ".aspx";
if (id != null)
{
lblid.Value = id;
Thumb imgthumb = new Thumb();
alamaat_product item = imgthumb.Getproductbyid(id);
if (null != item)
{
btncart.CommandArgument = item.id.ToString();
lblName.Text = item.productname;
lblprice.Text = "<b>Price Rs. </b>" + item.price.ToString();
thumbimage.ImageUrl = "~/ShowImage2.ashx?id=" + item.fileid;
imglink.HRef = "~/ShowImage2.ashx?id=" + item.fileid;
lblDesc.Text = item.details;
List <ProductThumb> list = imgthumb.GetListbyid(item.fileid.ToString());
if (list.Count > 0)
{
//thumbimage.ImageUrl = "~/ShowThumb.ashx?id=" + list[0].id;
// imglink.HRef = "~/ShowThumb.ashx?id=" + list[0].id;
List <ProductThumb> newlist = new List <ProductThumb>();
for (int i = 0; i < list.Count; i++)
{
if (i != 0)
{
newlist.Add(list[i]);
}
}
DataList1.DataSource = newlist;
DataList1.DataBind();
}
}
}
}
}
public alamaat_product Getbyname(string name)
{
alamaat_product item = objMyLq.alamaat_products.Where(ku => ku.productname.Equals(name)).FirstOrDefault();
return(item);
}
