public async Task <IViewComponentResult> InvokeAsync(UserTrackingFilter model)
{
//Decrypt UserId
model.UserId = Convert.ToInt32(CryptoEngine.DecryptString(model.UserIdEnyc));
var userTrackingDtoList = _userTrackingAppService.GetAllUserTrackingList(model);
var user = userTrackingDtoList.FirstOrDefault()?.User;
//Scale
if (model.BodyPart == EnumUserTrackingBodyPart.Height)
{
model.MeasurementScale.ScaleHeight.Find(x => x.Value == model.MeasurementScaleLKDId.ToString()).Selected = true;
}
else if (model.BodyPart == EnumUserTrackingBodyPart.Weight)
{
model.MeasurementScale.ScaleWeight.Find(x => x.Value == model.MeasurementScaleLKDId.ToString()).Selected = true;
}
else
{
model.MeasurementScale.ScaleOther.Find(x => x.Value == model.MeasurementScaleLKDId.ToString()).Selected = true;
}
var result = new UserTrackingDetailTabViewModel()
{
User = user,
BodyPart = model.BodyPart,
MeasurementScale = model.MeasurementScale,
Chart = GetChart(userTrackingDtoList, model),
UserTrackingDetail = userTrackingDtoList.Select(p => new UserTrackingDetailVModel()
{
Status = p.Status,
UserTrackingDate = p.UserTrackingDate,
BodyPartValueAndScale = GetBodyPartValueByEnum(p, model.BodyPart),
BodyPartProgress = ""
}).ToList(),
};
if (result.Chart != null)
{
result.Chart.HtmlControlId = "divProfileChartId";
}
return(View(result));
}
public async Task <ActionResult> Get(string picEnyc)
{
var id = Convert.ToInt32(CryptoEngine.DecryptString(picEnyc));
var attachmentList = await _documentAppService.GetAllBusinessDocumentAttachments(id, null, null);
if (attachmentList.Items.Count > 0)
{
var attachment = attachmentList.Items.First();
var contentType = string.Empty;
var fileExt = attachment.FileExt.ToLower();
switch (fileExt)
{
case ".jpg":
case ".jpeg":
case ".png":
contentType = "image/png";
break;
}
return(PhysicalFile(attachment.FilePath, contentType));
}
return(null);
}
public async Task <EditPersonalDetailViewModel> LoadPersonalDetail(string userIdEnyc)
{
var userId = Convert.ToInt64(CryptoEngine.DecryptString(userIdEnyc));
var user = await _userAppService.GetAsync(new EntityDto <long>(userId));
var genderMasterId = (await _lookupAppService.GetAllLookUpMaster(null, "Gender")).Items.FirstOrDefault().Id;
var genderSelectListItems = (await _lookupAppService.GetLookDetailComboboxItems(genderMasterId)).Items
.Select(p => p.ToSelectListItem())
.ToList();
genderSelectListItems.Find(x => x.Value == user.Gender.ToString()).Selected = true;
var personalDetailLKDId = (await _lookupAppService.GetAllLookDetail(null, LookUpDetailConst.PersonalDetail)).Items.FirstOrDefault().Id;
var businessDocumentList = (await _documentAppService.GetAllBusinessDocuments(null, personalDetailLKDId, null)).Items.ToList();
foreach (var businessDoc in businessDocumentList)
{
if (businessDoc.BusinessEntityLKDId == personalDetailLKDId)
{
var photo = new List <BusinessDocumentAttachmentDto>();
photo.Add(_documentAppService.GetAllBusinessDocumentAttachments(null, businessDoc.Id, (int)userId).Result.Items.FirstOrDefault());
businessDoc.BusinessDocumentAttachmentDto = photo;
}
}
var documentModel = new DocumentUploaderViewModel()
{
BusinessEntityId = userId,
DocumentList = businessDocumentList
};
return(new EditPersonalDetailViewModel
{
User = user,
Gender = genderSelectListItems,
ProfilePhoto = documentModel
});
}
public JsonResult GetRequestsHistory([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, String RequestId)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
string _access_key = ConfigurationManager.AppSettings["Salt"];
try
{
Employer.Employer employer = new Employer.Employer();
string dRequestId = CryptoEngine.DecryptString(RequestId, _access_key);
string request_ID = dRequestId.Replace(' ', '+');
DataTable dt = employer.FetchAssignmentHistory(dRequestId, userkey, uid);
dt.TableName = "RequestsHistory";
dt.Columns.ToString();
List <RequestsHistory> requestsHistory = new List <RequestsHistory>();
int startRec = requestModel.Start;
int pageSize = requestModel.Length;
List <RequestsHistory> requestCount = (from DataRow dr in dt.Rows
select new RequestsHistory()
{
RequestID = dr["RequestID"].ToString()
}).ToList();
requestsHistory = (from DataRow dr in dt.Rows
orderby dr["AssignDate"] descending
select new RequestsHistory()
{
RequestID = dr["RequestID"].ToString(),
HistoryID = dr["HistoryID"].ToString(),
Comment = dr["Comment"].ToString(),
Assignee = dr["Assignee"].ToString(),
Assignor = dr["Assignor"].ToString(),
AssignDate = Convert.ToDateTime(dr["AssignDate"]).ToString("dd-MMM-yyyy hh:mm"),
AssignStatus = dr["AssignStatus"].ToString()
}).Skip(startRec).Take(pageSize).ToList();
var totalCount = requestCount.Count();
var filteredCount = requestsHistory.Count();
if (requestModel.Search.Value != string.Empty)
{
var value = requestModel.Search.Value.Trim();
requestCount = (from DataRow dr in dt.Rows
where dr["RequestID"].ToString().Contains(value) || dr["Assignee"].ToString().Contains(value) ||
dr["Assignor"].ToString().Contains(value) || Convert.ToDateTime(dr["AssignDate"]).ToString("dd-MMM-yyyy hh:mm").Contains(value) ||
dr["Assignee"].ToString().Contains(value) || dr["AssignStatus"].ToString().Contains(value)
select new RequestsHistory()
{
RequestID = dr["RequestID"].ToString()
}).ToList();
requestsHistory = (from DataRow dr in dt.Rows
orderby dr["AssignDate"] descending
where dr["RequestID"].ToString().Contains(value) || dr["Assignee"].ToString().Contains(value) ||
dr["Assignor"].ToString().Contains(value) || Convert.ToDateTime(dr["AssignDate"]).ToString("dd-MMM-yyyy hh:mm").Contains(value) ||
dr["Assignee"].ToString().Contains(value) || dr["AssignStatus"].ToString().Contains(value)
select new RequestsHistory()
{
RequestID = dr["RequestID"].ToString(),
HistoryID = dr["HistoryID"].ToString(),
Comment = dr["Comment"].ToString(),
Assignee = dr["Assignee"].ToString(),
Assignor = dr["Assignor"].ToString(),
AssignDate = Convert.ToDateTime(dr["AssignDate"]).ToString("dd-MMM-yyyy hh:mm"),
AssignStatus = dr["AssignStatus"].ToString()
}).Skip(startRec).Take(pageSize).ToList();
totalCount = requestCount.Count();
filteredCount = requestsHistory.Count();
}
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
var data = requestsHistory.Select(emList => new
{
RequestID = emList.RequestID,
HistoryID = emList.HistoryID,
Comment = emList.Comment,
Assignee = emList.Assignee,
Assignor = emList.Assignor,
AssignDate = emList.AssignDate,
AssignStatus = emList.AssignStatus
}).OrderBy(orderByString == string.Empty ? "ID asc" : orderByString).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0);
return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet));
}
}
public async Task <IViewComponentResult> InvokeAsync(ViewComponentVModel model)
{
if (!model.SearchModel.UserId.HasValue && !string.IsNullOrWhiteSpace(model.SearchModel.UserIdEnyc))
{
model.SearchModel.UserId = (!string.IsNullOrWhiteSpace(model.SearchModel.UserIdEnyc)) ? (int?)Convert.ToInt32(CryptoEngine.DecryptString(model.SearchModel.UserIdEnyc)) : null;
}
var photoList = _photoTrackingAppService.GetAllPhotoTrackingPagedResult(model.SearchModel, model.BusinessEntityId);
var result = new PhotoTrackingViewModel()
{
DocumentList = photoList,
DocumentType = (model.SearchModel != null) ? model.SearchModel.DocumentType : EnumDocumentType.FrontPose
};
ViewBag.IsAdminLoggedIn = _userManager.IsAdminUser(AbpSession.UserId.Value);
string view = string.IsNullOrEmpty(model.ViewName) ? "_Default" : model.ViewName;
return(await Task.FromResult((IViewComponentResult)View(view, result)));
}
public JsonResult GetBatchDetails([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, String batchId, String addressId)
{
string LoginUser = (string)Session["LoginSAPID"];
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string CompanyName = (string)Session["CompanyName"];
string WebUserID = (string)Session["WebUserID"];
string EMPLOYER_ID = (string)Session["EMPLOYER_ID"];
string _access_key = ConfigurationManager.AppSettings["Salt"];
try
{
Employer.Employer employer = new Employer.Employer();
string dBatchId = CryptoEngine.DecryptString(batchId, _access_key);
string dAddressId = CryptoEngine.DecryptString(addressId, _access_key);
DataTable dt = employer.FetchPINsBatch(CompanyName, EMPLOYER_ID, dBatchId, dAddressId, userkey, uid);
dt.TableName = "PinsBatch";
dt.Columns.ToString();
List <CompanyEmployee> pins = new List <CompanyEmployee>();
int startRec = requestModel.Start;
int pageSize = requestModel.Length;
List <CompanyEmployee> pinCount = (from DataRow dr in dt.Rows
select new CompanyEmployee()
{
PIN = dr["P_I_N"].ToString(),
}).ToList();
pins = (from DataRow dr in dt.Rows
select new CompanyEmployee()
{
PIN = dr["P_I_N"].ToString(),
FirstName = dr["First Name"].ToString(),
LastName = dr["Last Name"].ToString(),
MiddleName = dr["Middle Names"].ToString()
}).Skip(startRec).Take(pageSize).ToList();
var totalCount = pinCount.Count();
var filteredCount = pins.Count();
if (requestModel.Search.Value != string.Empty)
{
var value = requestModel.Search.Value.ToLower().Trim();
pinCount = (from DataRow dr in dt.Rows
where dr["P_I_N"].ToString().ToLower().Contains(value) || dr["First Name"].ToString().ToLower().Contains(value) || dr["Last Name"].ToString().ToLower().Contains(value) || dr["Middle Names"].ToString().ToLower().Contains(value)
select new CompanyEmployee()
{
PIN = dr["Category ID"].ToString(),
}).ToList();
pins = (from DataRow dr in dt.Rows
where dr["P_I_N"].ToString().ToLower().Contains(value) || dr["First Name"].ToString().ToLower().Contains(value) || dr["Last Name"].ToString().ToLower().Contains(value) || dr["Middle Names"].ToString().ToLower().Contains(value)
select new CompanyEmployee()
{
PIN = dr["P_I_N"].ToString(),
FirstName = dr["First Name"].ToString(),
LastName = dr["Last Name"].ToString(),
MiddleName = dr["Middle Names"].ToString()
}).Skip(startRec).Take(pageSize).ToList();
totalCount = pinCount.Count();
filteredCount = pins.Count();
}
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
var data = pins.Select(emList => new
{
PIN = emList.PIN,
FirstName = emList.FirstName,
LastName = emList.LastName,
MiddleName = emList.MiddleName
}).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "StatementOptions/GetBatchDetails", "StatementOptions", "GetBatchDetails", "FetchPINsBatch Error", ex.Message.ToString(), 0);
return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet));
}
}