public RegInfoModel GetRegionInfo(string companyCode, string Region_Code) { RegInfoModel ObjRegInfo = null; List <RegionInfo> lstreginfo = null; List <RegionInfo> lstcurrinfo = null; try { using (IDbConnection connection = IDbOpenConnection()) { var p = new DynamicParameters(); p.Add("@Company_Code", companyCode); p.Add("@region_Code", Region_Code); using (var multiselect = connection.QueryMultiple(SP_hdGetRegionDetails, p, commandType: CommandType.StoredProcedure)) { lstcurrinfo = multiselect.Read <RegionInfo>().ToList(); lstreginfo = multiselect.Read <RegionInfo>().ToList(); } ObjRegInfo = new RegInfoModel(); ObjRegInfo.lstcurrinfo = lstcurrinfo; ObjRegInfo.lstreginfo = lstreginfo; connection.Close(); } } catch (Exception ex) { throw; } return(ObjRegInfo); }
public RegInfoModel GetRegionInfo(string companyCode, string Region_Code) { RegInfoModel lstreginfo = null; try { DAL_RegionCreation _objDal = new DAL_RegionCreation(); lstreginfo = _objDal.GetRegionInfo(companyCode, Region_Code); } catch (Exception ex) { throw; } return(lstreginfo); }
public JsonResult GetRegionInfo(string Region_Code) { string companyCode = null; RegInfoModel lstreginfo = null; try { _objCurrInfo = new CurrentInfo(); companyCode = _objCurrInfo.GetCompanyCode(); lstreginfo = _objbl.GetRegionInfo(companyCode, Region_Code); return(Json(lstreginfo, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw; } }