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