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