public string insertProdCategory(ProdCategory orduser)
{
TransactionManager transaction = null;
try
{
transaction = DataRepository.Provider.CreateTransaction();
transaction.BeginTransaction();
orduser.IsActive = true;
if (DataRepository.ProdCategoryProvider.Insert(orduser))
{
// 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.";
}
}
private void BindRepeater()
{
objprodctg = ObjprodClass.GetProdcategoryByID(Convert.ToInt32(Session["CTGID"]));
if (objprodctg != null)
{
prodCtgName.Text = objprodctg.Name;
IEnumerable<int> objprodsubCtg;
objprodsubCtg = ObjprodClass.GetAllProdmapBymainCtgID(objprodctg.Id);
if (objprodsubCtg != null)
{
objenumprodtable = objctgprodclass.GetproductsByCtgID(objprodsubCtg);
if (objenumprodtable != null)
{
rptProdByctg.DataSource = objenumprodtable;
rptProdByctg.DataBind();
TtlProds.Text = objenumprodtable.Count() + " Products";
}
}
List<Product> objp = new List<Product>();
objp = Product.AddValuesToDataList();
MnuDtlst.DataSource = objp;
MnuDtlst.DataBind();
}
else
{
Response.Redirect("~/Home.aspx", false);
}
}
protected void grdprodsubctg_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow && e.Row.DataItem != null)
{
try
{
GridViewRow gr = e.Row;
Label lblCategoryname = (Label)gr.FindControl("lblCategoryname");
Label lblProdparentctg = (Label)gr.FindControl("lblProdparentctg");
HiddenField HDFID = (HiddenField)gr.FindControl("HDFProdsubctgID");
ImageButton IMGBTNProdsubCTGisActive = (ImageButton)gr.FindControl("IMGBTNProdsubCTGisActive");
ProdSubcategory u = e.Row.DataItem as ProdSubcategory;
objprodctgmappinglist = ObjprodClass.GetAllProdCategoriesmapping(u.Id);
string name = null;
if (objprodctgmappinglist != null)
{
name = null;
foreach (var r in objprodctgmappinglist)
{
objprodmainctg = ObjprodClass.GetProdcategoryByID( Convert.ToInt32(r.CategoryId));
if (name != null)
{
name = name + "," + objprodmainctg.Name;
}
else
{
name = objprodmainctg.Name;
}
}
}
lblCategoryname.Text = u.SubCategoryName.Trim().ToString();
HDFID.Value = u.Id.ToString();
lblProdparentctg.Text = name.ToString();
if (u.IsActive == true)
{
IMGBTNProdsubCTGisActive.ImageUrl = "~/images/tick.png";
}
else
IMGBTNProdsubCTGisActive.ImageUrl = "~/images/close.jpg";
}
catch
{
}
}
}
protected void IMGBTNcategoryisActive_Click(object sender, ImageClickEventArgs e)
{
ImageButton lnk = (ImageButton)sender;
int userid = Convert.ToInt32(lnk.CommandArgument);
objprodctg = null;
objprodctg = ObjprodClass.GetProdcategoryByID(userid);
if (objprodctg != null)
{
if (objprodctg.IsActive == true)
ChkIsActive.Checked = true;
TXTcategory.Text = objprodctg.Name;
errorpopupStatus.Style.Add("display", "none");
DIVIsActive.Style.Add("display", "block");
btnSubmit.Text = "Update";
ViewState["popupID"] = userid.ToString();
ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPUpdate('true');});", true);
}
}
protected void btnSubmit_Click1(object sender, EventArgs e)
{
string categoryname = TXTcategory.Text;
if (categoryname != null)
{
objprodctg.Name = categoryname.ToString();
objprodctg.CreatedDate = DateTime.Now;
switch (btnSubmit.Text.Trim())
{
case "Submit":
ViewState["popupID"] = null;
Status = ObjprodClass.insertProdCategory(objprodctg);
if (Status == "Information Insert successfully.")
{
errorpopupStatus.Visible = true;
errorpopupStatus.Style.Add("display", "block");
errorpopupStatus.Attributes.Add("class", "fk-msg-success");
errorpopupStatus.InnerHtml = "Productcategory Inserted successfully";
BindProdCategoryGrid();
ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUP('true');});", true);
}
else
{
errorpopupStatus.Visible = true;
errorpopupStatus.Style.Add("display", "block");
errorpopupStatus.Attributes.Add("class", "fk-err-all");
errorpopupStatus.InnerHtml = Status;
ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUP('true');});", true);
}
break;
case "Update":
if (ViewState["popupID"] != null && ViewState["popupID"] != "")
{
objprodctg = null;
objprodctg = ObjprodClass.GetProdcategoryByID(Convert.ToInt32(ViewState["popupID"]));
objprodctg.Name = categoryname.ToString();
if (ChkIsActive.Checked)
objprodctg.IsActive = true;
else
objprodctg.IsActive = false;
Status = ObjprodClass.UpdateProdCategory(objprodctg);
if (Status == "Information Update successfully.")
{
errorpopupStatus.Visible = true;
errorpopupStatus.Style.Add("display", "block");
errorpopupStatus.Attributes.Add("class", "fk-msg-success");
errorpopupStatus.InnerHtml = "Productcategory Updated successfully";
BindProdCategoryGrid();
ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPUpdate('true');});", true);
}
else
{
errorpopupStatus.Visible = true;
errorpopupStatus.Style.Add("display", "block");
errorpopupStatus.Attributes.Add("class", "fk-err-all");
errorpopupStatus.InnerHtml = Status;
ScriptManager.RegisterStartupScript(this, typeof(Page), "aa", "jQuery(document).ready(function(){ShowPOPUPUpdate('true');});", true);
}
}
break;
}
}
}
public ProdCategory GetProdcategoryByID(int id)
{
Objprodcategory = null;
Objprodcategory = DataRepository.ProdCategoryProvider.GetById(id);
return Objprodcategory;
}