public List <dynamic> GetAllMasterandMappedDataByRegion(string companyCode, MasterDataParamModel _objParamData)
{
List <dynamic> lstMasterData = new List <dynamic>();
try
{
using (IDbConnection conn = IDbOpenConnection())
{
var p = new DynamicParameters();
p.Add("@CompanyCode", _objParamData.Company_Code);
p.Add("@RegionCode", _objParamData.Region_Code);
p.Add("@BeatCode", _objParamData.Beat_Code);
p.Add("@CustomerEntityType", _objParamData.Customer_Entity_Type);
p.Add("@DataLoadType", _objParamData.Data_Load_Type);
p.Add("@DataMappedorNot", _objParamData.Data_Mapped_Or_Not);
p.Add("@OnceOrMultiple", _objParamData.OnceOrMultiple);
lstMasterData = conn.Query <dynamic>(SP_HD_BPP_GETALLMASTERDATA, p, commandType: CommandType.StoredProcedure).ToList();
conn.Close();
}
}
catch (Exception ex)
{
throw;
}
return(lstMasterData);
}
/// <summary>
///
/// </summary>
/// <param name="companyCode"></param>
/// <param name="_ObjParamData"></param>
/// <returns></returns>
public JsonResult GetAllMasterandMappedDataByRegion(string companyCode, string _ObjParamData)
{
MasterDataParamModel _ObjMasterData = null;
List <dynamic> lstMasterData = new List <dynamic>();
_ObjMasterData = (MasterDataParamModel)JsonConvert.DeserializeObject(_ObjParamData, typeof(MasterDataParamModel));
lstMasterData = _ObjBeat.GetAllMasterandMappedDataByRegion(companyCode, _ObjMasterData);
//Newtonsoft.Json.JsonConvert.SerializeObject(lstMasterData);
return(Json(Newtonsoft.Json.JsonConvert.SerializeObject(lstMasterData), JsonRequestBehavior.AllowGet));
}
public List <dynamic> GetAllMasterandMappedDataByRegion(string companyCode, MasterDataParamModel _objParamData)
{
List <dynamic> lstMasterData = new List <dynamic>();
try
{
lstMasterData = _objBeat.GetAllMasterandMappedDataByRegion(companyCode, _objParamData);
}
catch (Exception ex)
{
throw;
}
return(lstMasterData);
}
