//Insert Update Delete operation on State Table #region [Action Performed] public int StateAction_BL(EWA_CountryStateDistrict objEWA) { DL_CountryStateDistrict objDL = new DL_CountryStateDistrict(); try { int flag = objDL.StateAction_DL(objEWA); return(flag); } catch (Exception ex) { int err = ((System.Data.SqlClient.SqlException)(ex)).Number; if (err == 547 && objEWA.Action == "DeleteState") { throw new SystemException("Record is in use !!!"); } else { throw ex; } } finally { // con.Close(); // cmd.Dispose(); objDL = null; } }
//To Check Duplicate Data #region [Check Duplicate Course] public int CheckDuplicateCountry_BL(EWA_CountryStateDistrict objEWA) { try { DL_CountryStateDistrict objDL = new DL_CountryStateDistrict(); int i = objDL.CheckDuplicateCountry_DL(objEWA); return(i); } catch (Exception) { throw; } }
//To Call District Grid Bind #region [District Grid Bind] public DataSet DistrictGridBind_BL(EWA_CountryStateDistrict objEWA) { try { DL_CountryStateDistrict objDL = new DL_CountryStateDistrict(); DataSet ds = objDL.BindDistrictGrid_DL(objEWA); return(ds); } catch (Exception) { throw; } }
//Insert Update Delete operaeion on Country Table #region [Action Performed] public int CountryAction_BL(EWA_CountryStateDistrict objEWA) { DL_CountryStateDistrict objDL = new DL_CountryStateDistrict(); try { int flag = objDL.CountryAction_DL(objEWA); return(flag); } catch (Exception) { throw; } finally { objDL = null; } }