public ActionResult Create(FIN_ApproverECLAIMModel model)
{
var service = new RestServiceClient<FIN_ApproverECLAIMModel>(UserLogin);
service.SetCookies(this.Request.Cookies, _Hrm_Hr_Service);
var result = service.Post(_Hrm_Hr_Service, "api/FIN_ApproverECLAIM/", model);
ViewBag.MsgInsert = "Insert success";
return Json(result, JsonRequestBehavior.AllowGet);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public FIN_ApproverECLAIMModel GetById(Guid id)
{
string status = string.Empty;
var model = new FIN_ApproverECLAIMModel();
ActionService service = new ActionService(UserLogin);
var entity = service.GetByIdUseStore<FIN_ApproverECLAIMEntity>(id, ConstantSql.hrm_eva_sp_get_ApproverECLAIMById, ref status);
if (entity != null)
{
model = entity.CopyData<FIN_ApproverECLAIMModel>();
}
model.ActionStatus = status;
return model;
}
public ActionResult GetApproverList([DataSourceRequest] DataSourceRequest request, FIN_ApproverECLAIMSearchModel model)
{
if (model != null)
{
model.ProfileID = Common.DotNetToOracle(model.ProfileID);
}
//#region lay ds approver hiển thị trên 1 dòng ứng với profile
var actionService = new ActionService(UserLogin);
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = 1,
PageSize = int.MaxValue - 1,//request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var status = string.Empty;
var listEntity = actionService.GetData<FIN_ApproverECLAIMEntity>(lstModel, ConstantSql.hrm_fin_sp_get_ApproverECLAIM, ref status).ToList();
if (model.OrderNo.HasValue)
{
listEntity = listEntity.Where(s => s.OrderNo != null && s.OrderNo.Value == model.OrderNo.Value).ToList();
}
if (listEntity != null)
{
// request.Page = 1;
//var listModel = listEntity.Translate<FIN_ApproverECLAIMModel>();
var listModel = listEntity;
var profileIds = listModel.GroupBy(p => new { p.ProfileID, p.ApprovedType }).ToList();
var approverReturn = new List<FIN_ApproverECLAIMModel>();
var approverNames = string.Empty;
foreach (var profileId in profileIds)
{
var approvers = listModel.Where(p => p.ProfileID == profileId.Key.ProfileID && p.ApprovedType == profileId.Key.ApprovedType).OrderBy(p => p.OrderNo).ToList();
var approver = approvers.FirstOrDefault();
approverNames = string.Empty;
foreach (var finApproverModel in approvers)
{
approverNames += finApproverModel.OrderNo + " - " + finApproverModel.ApprovedName + " , ";
}
var fin = new FIN_ApproverECLAIMModel();
if (approver != null)
{
fin.ID = approver.ID;
fin.ProfileName = approver.ProfileName;
fin.ApprovedType = approver.ApprovedType;
fin.ApprovedTypeView = approver.ApprovedTypeView;
fin.ProfileID = profileId.Key.ProfileID;
}
fin.ApprovedName = approverNames.Substring(0, approverNames.Length - 2);
approverReturn.Add(fin);
}
var dataSourceResult = approverReturn.ToDataSourceResult(request);
dataSourceResult.Total = approverReturn.Count();
return Json(dataSourceResult, JsonRequestBehavior.AllowGet);
}
var listModelNull = new List<FIN_ApproverECLAIMModel>();
ModelState.AddModelError("Id", status);
return Json(listModelNull.ToDataSourceResult(request, ModelState));
}
