public List <UserCustomerList_VM> GetCustomerData(UserCustomerList_VM Model)
{
var query = new List <UserCustomerList_VM>();
try
{
using (var db = new DBConnection())
{
var ds = new DataSet();
var par = new SqlParameter[] {
new SqlParameter("@p_LocationID", GetDBNULL(Model.LocationID, true)),
new SqlParameter("@p_LanguageCode", GetDBNULLString(Model.CurrentLanguageCode)),
new SqlParameter("@p_EndUserID", GetDBNULL(Model.EndUserID, true)),
new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID, true)),
new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID, true)),
new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint))
};
ds = db.ExecuteDataSet("GetOrganizationAndCustomer", par);
query = ConvertToList <UserCustomerList_VM>(ds.Tables[0]);
}
}
catch (Exception ex)
{
logger.Error("EndUserRepository_GetCustomerData Error: ", ex);
throw;
}
return(query);
}
public JsonResult GetCustomerData(UserCustomerList_VM Model)
{
List <UserCustomerList_VM> vm = new List <UserCustomerList_VM>();
try
{
GetUserInfo(Model);
vm = _UserRepo.GetCustomerData(Model);
return(Json(new JsonResponse("Success", "Success", vm), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new JsonResponse("Error", "Error occured while processing request: " + ex.Message.ToString(), null), JsonRequestBehavior.AllowGet));
}
}
