//Save Data
#region SaveData
protected void btnSave_Click(object sender, EventArgs e)
{
BL_Category objBL = new BL_Category();
EWA_Category objEWA = new EWA_Category();
try
{
lock (this)
{
if (txtCategoryName.Text == "")
{
msgBox.ShowMessage("Please Enter Category Name !!!", "Information", UserControls.MessageBox.MessageStyle.Information);
}
else
{
int chk = CheckData();
if (chk > 0)
{
msgBox.ShowMessage("Record Allready Exist !!!", "Information", UserControls.MessageBox.MessageStyle.Information);
}
else
{
Action("Save");
GrdCategoryBind();
LoadForm();
}
}
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Bind Item Category
#region [Bind Item Category Grid]
public DataSet BindCategoryGrid_DL(EWA_Category objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "OrgId";
prmList[3] = objEWA.OrgId.ToString();
ds = ObjHelper.FillControl(prmList, "SP_Category");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("CategoryName");
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
//return dsCode;
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Perform Action on Category Table
#region [Perform Actions On Item Category]
public int CategoryAction_DL(EWA_Category objEWA)
{
try
{
cmd = new SqlCommand("SP_Category", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", objEWA.Action);
cmd.Parameters.AddWithValue("@CategoryId", objEWA.CategoryId);
cmd.Parameters.AddWithValue("@CategoryName", objEWA.CategoryName);
cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
cmd.Parameters.AddWithValue("@UserId", objEWA.UserId);
cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive);
con.Open();
int flag = cmd.ExecuteNonQuery();
return(flag);
}
catch (Exception ex)
{
int err = ((System.Data.SqlClient.SqlException)(ex)).Number;
if (err == 547 && objEWA.Action == "Delete")
{
throw new SystemException("Record is in use !!!");
}
else
{
throw ex;
}
}
finally
{
con.Close();
cmd.Dispose();
}
}
//To Check Duplicate Item Category
#region [Check Duplicate Item Category]
public int CheckDuplicateCategory_DL(EWA_Category objEWA)
{
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "CheckData";
prmList[2] = "@CategoryName";
prmList[3] = objEWA.CategoryName;
prmList[4] = "@OrgId";
prmList[5] = objEWA.OrgId.ToString();
DataSet dsData = ObjHelper.FillControl(prmList, "SP_Category");
if (dsData.Tables[0].Rows.Count > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception exp)
{
throw exp;
}
}
//Check Duplicate Item category
#region [Check Duplicate Item Category]
public int CheckDuplicateCategory_BL(EWA_Category objEWA)
{
try
{
DL_Category objDL = new DL_Category();
int i = objDL.CheckDuplicateCategory_DL(objEWA);
return(i);
}
catch (Exception exp)
{
throw exp;
}
}
//Item Category Grid Bind
#region [Item Category Grid Bind]
public DataSet CategoryGridBind_BL(EWA_Category objEWA)
{
try
{
DL_Category objDL = new DL_Category();
DataSet ds = objDL.BindCategoryGrid_DL(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Action Performed
#region [ActionPerformed For ItemCategory]
public int CategoryAction_BL(EWA_Category objEWA)
{
try
{
DL_Category objDL = new DL_Category();
int flag = objDL.CategoryAction_DL(objEWA);
return(flag);
}
catch (Exception exp)
{
throw exp;
}
}
//Check Data
#region [Check Data]
private int CheckData()
{
int i = 0;
try
{
EWA_Category objEWA = new EWA_Category();
objEWA.OrgId = orgId;
objEWA.CategoryName = txtCategoryName.Text.Trim();
i = objBL.CheckDuplicateCategory_BL(objEWA);
return(i);
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
return(0);
}
}
