public RegionCreationModelRCW GetRegionDetails(string companyCode, string regioncode) { RegionCreationModelRCW lstregdetails = null; try { DAL_RegionCreation _objDal = new DAL_RegionCreation(); lstregdetails = _objDal.GetRegionDetails(companyCode, regioncode); } catch (Exception ex) { throw ex; } return(lstregdetails); }
public JsonResult GetRegionDetails(string regioncode) { string companyCode = null; RegionCreationModelRCW lstactreg = null; try { _objCurrInfo = new CurrentInfo(); companyCode = _objCurrInfo.GetCompanyCode(); lstactreg = _objbl.GetRegionDetails(companyCode, regioncode); return(Json(lstactreg, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
public RegionCreationModelRCW GetRegionDetails(string companyCode, string regioncode) { RegionCreationModelRCW ObjRegInfo = null; List <RegionCreationModel> lstregdetails = null; List <RegionCreationModel> lstregdivddetails = null; List <RegionCreationModel> lstActiveCount = null; List <RegionCreationModel> lstDepoDetails = null; try { using (IDbConnection connection = IDbOpenConnection()) { var p = new DynamicParameters(); p.Add("@CompanyCode", companyCode); p.Add("@regioncode", regioncode); using (var multiselect = connection.QueryMultiple(sp_GetRegionDetails, p, commandType: CommandType.StoredProcedure)) { lstregdetails = multiselect.Read <RegionCreationModel>().ToList(); lstregdivddetails = multiselect.Read <RegionCreationModel>().ToList(); lstDepoDetails = multiselect.Read <RegionCreationModel>().ToList(); lstActiveCount = multiselect.Read <RegionCreationModel>().ToList(); } ObjRegInfo = new RegionCreationModelRCW(); ObjRegInfo.lstregdetails = lstregdetails; ObjRegInfo.lstregdivddetails = lstregdivddetails; ObjRegInfo.lstDepoDetails = lstDepoDetails; ObjRegInfo.lstActiveCount = lstActiveCount; connection.Close(); } } catch (Exception ex) { throw ex; } return(ObjRegInfo); }