protected void rptctglqd_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { ProdTable Prod = e.Item.DataItem as ProdTable; HyperLink lnkProdLqdName = (HyperLink)e.Item.FindControl("lnkProdLqdName"); Label lblLqdprodSum = (Label)e.Item.FindControl("lblLqdprodSum"); LinkButton addcartID = (LinkButton)e.Item.FindControl("addcartID"); if (Prod != null) { objitem = null; objitem = ObjprodClass.GetItemsByID(Convert.ToInt32(Prod.ItemId)); objitemsell = ObjprodClass.GetItemsellByID(Convert.ToInt32(Prod.SellId)); lnkProdLqdName.Text = objitem.ItemName; //IMGLqdProd.ImageUrl = Prod.ImageUrl; addcartID.CommandArgument = Convert.ToString(Prod.Id); lblLqdprodSum.Text = objitemsell.Cost; } } }
protected void btnSubmitprod_Click(object sender, EventArgs e) { //objitem = null; //objitempurchase = null; //objitemsell = null; //objitem = null; switch (btnSubmitprod.Text) { case "Submit": if (file_upload.HasFile) { objitem.ItemName = TXTprod.Text.ToString().Trim(); objitem.CreatedDate = DateTime.Now; objitem.IsActive = true; objitempurchase.Cost = Convert.ToInt64(txtitmpurchase.Text.Trim()); objitempurchase.IsActive = true; objitempurchase.CreatedDate = DateTime.Now; objitemsell.Cost = txtitmSell.Text.Trim(); objitemsell.Createdate = DateTime.Now; objitemsell.CostVary = Convert.ToDecimal(Convert.ToInt32(txtitmSell.Text.Trim()) - Convert.ToInt32(txtitmpurchase.Text.Trim())); //objprod.CategoryId = Convert.ToInt32(DrpCategory.SelectedItem.Value); objprod.CategoryId = 10; objprod.CompanyId = Convert.ToInt32(drpcompany.SelectedItem.Value); objprod.TypeId = Convert.ToInt32(Drptype.SelectedItem.Value); objprod.SupplementId = Convert.ToInt32(Drpsupplement.SelectedItem.Value); objprod.MedicineForId = Convert.ToInt32(DrpmedicineFor.SelectedItem.Value); if (DrpOffer.SelectedItem.Value == "0") { objprod.OfferId = 1; } else { objprod.OfferId = Convert.ToInt32(DrpOffer.SelectedItem.Value); } objprod.IsActive = true; objprod.CreatedDate = DateTime.Now; //Get Filename from fileupload control string filename = Path.GetFileName(file_upload.PostedFile.FileName); //Save images into Images folder file_upload.SaveAs(Server.MapPath("~/images/Products/" + filename)); objprod.ImageUrl = "~/images/Products/" + filename; Status = null; Status = ObjprodClass.insertProd(objitem, objitempurchase, objitemsell, objprod); if (Status == "Information Insert successfully.") { errorpopheaderprod.Visible = true; errorpopheaderprod.Style.Add("display", "block"); errorpopheaderprod.Attributes.Add("class", "fk-msg-success"); errorpopheaderprod.InnerHtml = "ProductType Inserted successfully"; binddrpdowns(); BindProdGrid(); ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPprodtable('false');});", true); } else { errorpopheaderprod.Visible = true; errorpopheaderprod.Style.Add("display", "block"); errorpopheaderprod.Attributes.Add("class", "fk-err-all"); errorpopheaderprod.InnerHtml = Status; ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPprodtable('true');});", true); } } break; case "Update": if (ViewState["popupID"] != null && ViewState["popupID"] != "") { objprod = null; objitem = null; objitempurchase = null; objitemsell = null; objprod = ObjprodClass.GetProdByID(Convert.ToInt32(ViewState["popupID"])); objitem = ObjprodClass.GetItemsByID(Convert.ToInt32(objprod.ItemId)); objitempurchase = ObjprodClass.GetItempurchaseByID(Convert.ToInt32(objprod.PurchaseId)); objitemsell = ObjprodClass.GetItemsellByID(Convert.ToInt32(objprod.SellId)); objitem.ItemName = TXTprod.Text.ToString().Trim(); objitem.Modifieddate = DateTime.Now; objitem.IsActive = true; objitempurchase.Cost = Convert.ToInt64(txtitmpurchase.Text.Trim()); objitempurchase.IsActive = true; objitempurchase.Modifieddate = DateTime.Now; objitemsell.Cost = txtitmSell.Text.Trim(); objitemsell.ModifiedDate = DateTime.Now; objitemsell.CostVary = Convert.ToDecimal(Convert.ToInt32(txtitmSell.Text.Trim()) - Convert.ToInt32(txtitmpurchase.Text.Trim())); objprod.CategoryId = Convert.ToInt32(DrpCategory.SelectedItem.Value); objprod.CompanyId = Convert.ToInt32(drpcompany.SelectedItem.Value); objprod.TypeId = Convert.ToInt32(Drptype.SelectedItem.Value); objprod.SupplementId = Convert.ToInt32(Drpsupplement.SelectedItem.Value); objprod.MedicineForId = Convert.ToInt32(DrpmedicineFor.SelectedItem.Value); if (DrpOffer.SelectedItem.Value == "0") { objprod.OfferId = 1; } else { objprod.OfferId = Convert.ToInt32(DrpOffer.SelectedItem.Value); } objprod.IsActive = true; objprod.ModifiedDate = DateTime.Now; //Get Filename from fileupload control //string filename = Path.GetFileName(file_upload.PostedFile.FileName); ////Save images into Images folder objprod.ImageUrl = "~/images/Products/" + TXTProdimg.Text; file_upload.SaveAs(Server.MapPath("~/images/Products/" + TXTProdimg.Text)); Status = null; Status = ObjprodClass.UpdateProd(objitem, objitempurchase, objitemsell, objprod); if (Status == "Information Update successfully.") { errorpopheaderprod.Visible = true; errorpopheaderprod.Style.Add("display", "block"); errorpopheaderprod.Attributes.Add("class", "fk-msg-success"); errorpopheaderprod.InnerHtml = "Product Updated successfully"; BindProdGrid(); ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPupdateprodtable('true');});", true); } else { errorpopheaderprod.Visible = true; errorpopheaderprod.Style.Add("display", "block"); errorpopheaderprod.Attributes.Add("class", "fk-err-all"); errorpopheaderprod.InnerHtml = Status; ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPupdateprodtable('true');});", true); } } break; } }
protected void grdprod_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow && e.Row.DataItem != null) { try { GridViewRow gr = e.Row; Label lblprodname = (Label)gr.FindControl("lblProdname"); Label lblProdctg = (Label)gr.FindControl("lblProdctg"); Label lblProdcomp = (Label)gr.FindControl("lblProdcomp"); Label lblProdtype = (Label)gr.FindControl("lblProdtype"); Label lblProdsupp = (Label)gr.FindControl("lblProdsupp"); Label lblProdmedicinefor = (Label)gr.FindControl("lblProdmedicinefor"); Label lblProdPcost = (Label)gr.FindControl("lblProdPcost"); Label lblProdScost = (Label)gr.FindControl("lblProdScost"); Label lblProdoffer = (Label)gr.FindControl("lblProdoffer"); HiddenField HDFID = (HiddenField)gr.FindControl("HDFProdID"); ImageButton IMGBTNcategoryisActive = (ImageButton)gr.FindControl("IMGBTNProdisActive"); Image IMGProd = (Image)gr.FindControl("IMGProd"); ProdTable u = e.Row.DataItem as ProdTable; objitem = null; objitem = ObjprodClass.GetItemsByID(Convert.ToInt32(u.ItemId)); if (objitem != null) { objitempurchase = ObjprodClass.GetItempurchaseByID(Convert.ToInt32(u.PurchaseId)); objitemsell = ObjprodClass.GetItemsellByID(Convert.ToInt32(u.SellId)); objprodctg = ObjprodClass.GetProdSubcategoryByID(Convert.ToInt32(u.CategoryId)); objprodtype = ObjprodClass.GetProdTypeByID(Convert.ToInt32(u.TypeId)); objprodsupple = ObjprodClass.GetProdsupplymentByID(Convert.ToInt32(u.SupplementId)); Objprodcomp = ObjprodClass.GetProdcompByID(Convert.ToInt32(u.CompanyId)); objmed = ObjprodClass.GetProdmedicineByID(Convert.ToInt32(u.MedicineForId)); objoffer = ObjprodClass.GetProdOfferByID(Convert.ToInt32(u.OfferId)); if (objitempurchase != null && objitemsell != null & objprodctg != null && objprodtype != null & objprodsupple != null && Objprodcomp != null & objmed != null && objoffer != null) { lblprodname.Text = objitem.ItemName.ToString().Trim(); lblProdctg.Text = objprodctg.SubCategoryName.ToString().Trim(); lblProdtype.Text = objprodtype.Name.ToString().Trim(); lblProdsupp.Text = objprodsupple.Name.ToString().Trim(); lblProdcomp.Text = Objprodcomp.CompanyName.ToString().Trim(); lblProdmedicinefor.Text = objmed.Name.ToString().Trim(); lblProdoffer.Text = objoffer.OfferPercent.ToString().Trim(); lblProdPcost.Text = objitempurchase.Cost.ToString().Trim(); lblProdScost.Text = objitemsell.Cost.ToString().Trim(); HDFID.Value = u.Id.ToString(); IMGProd.ImageUrl = u.ImageUrl; if (u.IsActive == true) { IMGBTNcategoryisActive.ImageUrl = "~/images/tick.png"; } else IMGBTNcategoryisActive.ImageUrl = "~/images/close.jpg"; } } } catch (Exception ex) { Response.Write(ex.ToString()); } } }
protected void IMGBTNProdisActive_Click(object sender, ImageClickEventArgs e) { ImageButton lnk = (ImageButton)sender; int userid = Convert.ToInt32(lnk.CommandArgument); objitem = null; objprod = null; objprod = ObjprodClass.GetProdByID(userid); objitem = ObjprodClass.GetItemsByID(Convert.ToInt32(objprod.ItemId)); objitempurchase = ObjprodClass.GetItempurchaseByID(Convert.ToInt32(objprod.PurchaseId)); objitemsell = ObjprodClass.GetItemsellByID(Convert.ToInt32(objprod.SellId)); if (objitem != null) { TXTprod.Text = objitem.ItemName; //DrpCategory.SelectedValue = objprod.CategoryId.ToString(); drpcompany.SelectedValue = objprod.CompanyId.ToString(); DrpmedicineFor.SelectedValue = objprod.MedicineForId.ToString(); DrpOffer.SelectedValue = objprod.OfferId.ToString(); Drpsupplement.SelectedValue = objprod.SupplementId.ToString(); Drptype.SelectedValue = objprod.TypeId.ToString(); txtitmpurchase.Text = objitempurchase.Cost.ToString(); txtitmSell.Text = objitemsell.Cost.ToString(); string url = objprod.ImageUrl.ToString().Trim(); string[] spliturl = url.Split('/'); TXTProdimg.Text = spliturl[2]; errorpopheaderprod.Style.Add("display", "none"); //DIVIsActive.Style.Add("display", "block"); btnSubmitprod.Text = "Update"; ViewState["popupID"] = userid.ToString(); ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPprodUpdate('true');});", true); } }
public ItemSell GetItemsellByID(int id) { ObjProditmsell = null; ObjProditmsell = DataRepository.ItemSellProvider.GetById(id); return ObjProditmsell; }
public string UpdateProd(Items obitem, ItemPurchase objitmpurchase, ItemSell ObjitmSell, ProdTable objtable) { TransactionManager transaction = null; try { transaction = DataRepository.Provider.CreateTransaction(); transaction.BeginTransaction(); if ((DataRepository.ItemsProvider.Update(transaction, obitem))) { // Show proper message //objitmpurchase.ItemId = obitem.Id; //ObjitmSell.ItemId = obitem.Id; if ((DataRepository.ItemPurchaseProvider.Update(transaction, objitmpurchase)) && ((DataRepository.ItemSellProvider.Update(transaction, ObjitmSell)))) { //objtable.ItemId = obitem.Id; //objtable.SellId = ObjitmSell.Id; //objtable.PurchaseId = objitmpurchase.Id; if (DataRepository.ProdTableProvider.Update(transaction, objtable)) { } else { transaction.Rollback(); return "Information could not be saved."; } } else { transaction.Rollback(); return "Information could not be saved."; } } else { return "Information could not be saved."; } transaction.Commit(); return "Information Update successfully."; } catch (Exception e) { transaction.Rollback(); return "Information could not be saved.Please contact Administrator."; } }
protected void dlstcartlist_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { ProdTable objprodcart = e.Item.DataItem as ProdTable; Image imgcart = (Image)e.Item.FindControl("imgcart"); Label lblitmname = (Label)e.Item.FindControl("lblitmname"); Label itmcost = (Label)e.Item.FindControl("itmcost"); Label lblttlcost = (Label)e.Item.FindControl("lblttlcost"); LinkButton imgremove = (LinkButton)e.Item.FindControl("imgremove"); objitem = null; objitem = ObjprodClass.GetItemsByID(Convert.ToInt32(objprodcart.ItemId)); { objitemsell = ObjprodClass.GetItemsellByID(Convert.ToInt32(objprodcart.SellId)); lblitmname.Text = objitem.ItemName.ToString().Trim(); imgcart.ImageUrl = objprodcart.ImageUrl; itmcost.Text = objitemsell.Cost.ToString().Trim(); lblttlcost.Text = objitemsell.Cost.ToString().Trim(); imgremove.CommandArgument = Convert.ToString(objprodcart.Id); if (itmttl == 0) { itmttl = Convert.ToInt32(lblttlcost.Text); } else { itmttl =itmttl + Convert.ToInt32(lblttlcost.Text); } lblttlamnt.Text = itmttl.ToString(); } } }
protected void rptProdByctg_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { ProdTable Prod = e.Item.DataItem as ProdTable; LinkButton lnkprodName = (LinkButton)e.Item.FindControl("lnkprodName"); Image prodImgCtg = (Image)e.Item.FindControl("prodImgCtg"); Label lblitmsell = (Label)e.Item.FindControl("lblitmsell"); Label lblitmpurchase = (Label)e.Item.FindControl("lblitmpurchase"); objitem = null; objitem = ObjprodClass.GetItemsByID(Convert.ToInt32(Prod.ItemId)); objitemsell = ObjprodClass.GetItemsellByID(Convert.ToInt32(Prod.SellId)); objitempurchase = ObjprodClass.GetItempurchaseByID(Convert.ToInt32(Prod.PurchaseId)); objbrandID.Add(Convert.ToInt32(Prod.CompanyId)); lnkprodName.Text = objitem.ItemName; prodImgCtg.ImageUrl = Prod.ImageUrl; lblitmsell.Text = objitemsell.Cost; lblitmpurchase.Text = objitempurchase.Cost.ToString(); } }