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();
}
}
