protected void rptmnctg_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
ProdCategory objproddtabound = e.Item.DataItem as ProdCategory;
LinkButton lnkmainCTG = (LinkButton)e.Item.FindControl("lnkmainCTG");
Repeater rptsubctg = (Repeater)e.Item.FindControl("rptsubctg");
TList<ProdSubcategory> objprodsubctglist1 = new TList<ProdSubcategory>();
List<int> objsubctgID = new List<int>();
objsubctgID = ObjprodClass.GetAllProdmapBymainCtgID(objproddtabound.Id);
if (objsubctgID != null)
{
foreach (int a in objsubctgID)
{
objprodctg = null;
objprodctg = ObjprodClass.GetProdSubcategoryByID(a);
objprodsubctglist1.Add(objprodctg);
}
}
rptsubctg.DataSource = objprodsubctglist1;
rptsubctg.DataBind();
lnkmainCTG.Text = objproddtabound.Name;
}
}
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());
}
}
}
public ProdSubcategory GetProdSubcategoryByID(int id)
{
ObjprodSubcategory = null;
ObjprodSubcategory = DataRepository.ProdSubcategoryProvider.GetById(id);
return ObjprodSubcategory;
}
public string UpdateProdSubCategory(ProdSubcategory orduser, List<int> prodID)
{
TransactionManager transaction = null;
try
{
ProdCategoryMapping objprodctgmapping = new ProdCategoryMapping();
ProdCategoryMapping objprodctgmapping1 = new ProdCategoryMapping();
TList<ProdCategoryMapping> objprodctgmappinglist = new TList<ProdCategoryMapping>();
TList<ProdCategoryMapping> objprodctgmappinglist1 = new TList<ProdCategoryMapping>();
objprodctgmappinglist1 = GetAllProdCategoriesmapping(orduser.Id);
transaction = DataRepository.Provider.CreateTransaction();
transaction.BeginTransaction();
if (DataRepository.ProdSubcategoryProvider.Update(orduser))
{
foreach (var q in objprodctgmappinglist1)
{
objprodctgmapping1 = null;
objprodctgmapping1 = GetProdmappcategoryByID(Convert.ToInt32(q.Id));
if (DataRepository.ProdCategoryMappingProvider.Delete(objprodctgmapping1))
{
// Show proper message
}
else
{
return "Information could not be Delete.";
}
}
foreach (int id in prodID)
{
objprodctgmapping.IsActive = true;
objprodctgmapping.CategoryId = id;
objprodctgmapping.SubCategoryId = orduser.Id;
objprodctgmapping.CreatedDate = DateTime.Now;
if (DataRepository.ProdCategoryMappingProvider.Insert(objprodctgmapping))
{
// Show proper message
}
else
{
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.";
}
}
public string insertProdSubCategory(ProdSubcategory orduser, List<int> prodID)
{
TransactionManager transaction = null;
try
{
ProdCategoryMapping objprodctgmapping = new ProdCategoryMapping();
transaction = DataRepository.Provider.CreateTransaction();
transaction.BeginTransaction();
orduser.IsActive = true;
if (DataRepository.ProdSubcategoryProvider.Insert(orduser))
{
foreach (int id in prodID)
{
objprodctgmapping.IsActive = true;
objprodctgmapping.CategoryId = id;
objprodctgmapping.SubCategoryId = orduser.Id;
objprodctgmapping.CreatedDate = DateTime.Now;
if (DataRepository.ProdCategoryMappingProvider.Insert(objprodctgmapping))
{
// Show proper message
}
else
{
return "Information could not be saved.";
}
}
}
transaction.Commit();
return "Information Insert successfully.";
}
catch (Exception e)
{
transaction.Rollback();
return "Information could not be saved.Please contact Administrator.";
}
}
protected void IMGBTNProdsubCTGisActive_Click(object sender, ImageClickEventArgs e)
{
bindlistitems();
ImageButton lnk = (ImageButton)sender;
int userid = Convert.ToInt32(lnk.CommandArgument);
objprodctg = null;
objprodctg = ObjprodClass.GetProdSubcategoryByID(userid);
objprodctgmappinglist = ObjprodClass.GetAllProdCategoriesmapping(userid);
foreach (var r in objprodctgmappinglist)
{
lstprntctg.SelectionMode = ListSelectionMode.Multiple;
for (int i = 0; i < lstprntctg.Items.Count; i++)
{
if (lstprntctg.Items[i].Value==r.CategoryId.ToString())
{
int j = i;
lstprntctg.Items[j].Selected = true;
}
}
}
if (objprodctg != null)
{
TXTprodsubctg.Text = objprodctg.SubCategoryName;
errorpopheaderprodsubctg.Style.Add("display", "none");
btnSubmitprodsubctg.Text = "Update";
ViewState["popupID"] = userid.ToString();
ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPupdateprodsubctg('true');});", true);
}
}
protected void btnSubmit_Click1(object sender, EventArgs e)
{
string categoryname = TXTprodsubctg.Text;
if (categoryname != null)
{
objprodctg.SubCategoryName = categoryname.ToString();
objprodctg.CreatedDate = DateTime.Now;
List<int> objID = new List<int>();
switch (btnSubmitprodsubctg.Text.Trim())
{
case "Submit":
ViewState["popupID"] = null;
foreach (ListItem item in lstprntctg.Items)
{
if (item.Selected)
{
try
{
objID.Add(Convert.ToInt32(item.Value));
}
catch
{
}
}
}
Status = ObjprodClass.insertProdSubCategory(objprodctg, objID);
if (Status == "Information Insert successfully.")
{
errorpopheaderprodsubctg.Visible = true;
errorpopheaderprodsubctg.Style.Add("display", "block");
errorpopheaderprodsubctg.Attributes.Add("class", "fk-msg-success");
errorpopheaderprodsubctg.InnerHtml = "ProductSubcategory Inserted successfully";
bindGrid();
ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPprodsubctg('false');});", true);
}
else
{
errorpopheaderprodsubctg.Visible = true;
errorpopheaderprodsubctg.Style.Add("display", "block");
errorpopheaderprodsubctg.Attributes.Add("class", "fk-err-all");
errorpopheaderprodsubctg.InnerHtml = Status;
ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPprodsubctg('false');});", true);
}
break;
case "Update":
if (ViewState["popupID"] != null && ViewState["popupID"] != "")
{
List<int> objID1 = new List<int>();
objprodctg = null;
objprodctg = ObjprodClass.GetProdSubcategoryByID(Convert.ToInt32(ViewState["popupID"]));
foreach (ListItem item in lstprntctg.Items)
{
if (item.Selected)
{
try
{
objID1.Add(Convert.ToInt32(item.Value));
}
catch
{
}
}
}
objprodctg.SubCategoryName = categoryname.ToString();
Status = ObjprodClass.UpdateProdSubCategory(objprodctg, objID1);
if (Status == "Information Update successfully.")
{
errorpopheaderprodsubctg.Visible = true;
errorpopheaderprodsubctg.Style.Add("display", "block");
errorpopheaderprodsubctg.Attributes.Add("class", "fk-msg-success");
errorpopheaderprodsubctg.InnerHtml = "ProductSubcategory Updated successfully";
bindGrid();
ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPupdateprodsubctg('true');});", true);
}
else
{
errorpopheaderprodsubctg.Visible = true;
errorpopheaderprodsubctg.Style.Add("display", "block");
errorpopheaderprodsubctg.Attributes.Add("class", "fk-err-all");
errorpopheaderprodsubctg.InnerHtml = Status;
ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPupdateprodsubctg('true');});", true);
}
}
break;
}
}
}
