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