public async Task <MessageReport> Delete(string id)
{
var result = new MessageReport(false, "Có lỗi xảy ra");
var obj = await GetById(id);
if (obj != null)
{
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'_id': { '$eq': '" + id + "' }");
query.AppendLine("}");
return(await _SY_ReminderSystemRepository.Remove(MongoHelper.ConvertQueryStringToDocument(query.ToString())));
}
else
{
result = new MessageReport(false, "Bản ghi không tồn tại");
}
return(await Task.FromResult(result));
}
public async Task <MessageReport> CheckEmailExisted(UserForgotModel model)
{
var result = new MessageReport(false, "Có lỗi xảy ra");
try
{
//
var existed = await GetByUsername(model.Email);
if (existed == null)
{
result = new MessageReport(false, "Email này không tồn tại trong hệ thống");
return(await Task.FromResult(result));
}
existed.CodeReset = FunctionHelper.GetRandomNumericCharacters(6);
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'_id': { '$eq': '" + existed.Id + "' }");
query.AppendLine("}");
result = await _SY_UserRepository.Update(MongoHelper.ConvertQueryStringToDocument(query.ToString()), existed);
if (result.isSuccess)
{
result.Message = "Gửi mã xác nhận vào email";
sendEmail(existed.Username, existed.CodeReset);
}
}
catch (Exception ex)
{
result = new MessageReport(false, ex.Message);
}
return(await Task.FromResult(result));
}
private async Task <List <string> > GetUserInvolved(string componentid)
{
var list = new List <string>();
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'ComponentId': { '$eq': '" + componentid + "' }");
query.AppendLine("}");
var k = await _PM_WorkRepository.GetManyToList(MongoHelper.ConvertQueryStringToDocument(query.ToString()));
var users = k.Select(n => n.UserId).Distinct().ToList();
foreach (var item in users)
{
list.Add(item);
}
return(list);
}
public async Task <MessageReport> Delete(string ids)
{
//
var arr = ids.Split(';', StringSplitOptions.RemoveEmptyEntries);
//query
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'_id': { '$in': [");
var count = 0;
foreach (var item in arr)
{
count++;
query.AppendLine(string.Format("'{0}'{1}", item, count == arr.Length ? "" : ","));
}
query.AppendLine("]}");
query.AppendLine("}");
return(await _SY_MenuFunctionRepository.Remove_Multi(MongoHelper.ConvertQueryStringToDocument(query.ToString())));
}
public async Task <List <PM_Component> > GetAllByIds(List <string> ids, int status = 0)
{
var count = 0;
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'Status': {'$eq': " + status + "}");
query.AppendLine(", '_id': { '$in': [");
foreach (var item in ids)
{
count++;
query.AppendLine(string.Format("'{0}'{1}", item, count == ids.Count ? "" : ","));
}
query.AppendLine("]}");
query.AppendLine("}");
return(await _PM_ComponentRepository.GetManyToList(MongoHelper.ConvertQueryStringToDocument(query.ToString())));
}
public async Task <GridModel <SY_User> > GetPaging(string key, int pageNumber, int pageSize)
{
var query = new StringBuilder();
query.AppendLine("{");
if (!string.IsNullOrWhiteSpace(key))
{
query.AppendLine("'$or': [");
query.AppendLine("{ 'Name': { '$in': [/" + key + "/i] } }");
query.AppendLine(", { 'Username': { '$in': [/" + key + "/i] } }");
query.AppendLine("]");
}
query.AppendLine("}");
var sort = new StringBuilder();
sort.AppendLine("{");
sort.AppendLine("'Username': 1");
sort.AppendLine("}");
return(await _SY_UserRepository.GetPaging(MongoHelper.ConvertQueryStringToDocument(query.ToString()), MongoHelper.ConvertQueryStringToDocument(sort.ToString()), pageNumber, pageSize));
}
public async Task <GridModel <MN_KeyCard> > GetPaging(string key, string keysecurityid, string fromdate, string todate, int pageNumber, int pageSize)
{
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'KeySecurityId': {'$eq': '" + keysecurityid + "'}");
if (!string.IsNullOrWhiteSpace(key))
{
query.AppendLine(", '$or': [");
query.AppendLine("{ 'CardNo': { '$in': [/" + key + "/i] } }");
query.AppendLine(", { 'CardNumber': { '$in': [/" + key + "/i] } }");
query.AppendLine("]");
}
if (!string.IsNullOrWhiteSpace(fromdate) && !string.IsNullOrWhiteSpace(todate))
{
fromdate = Convert.ToDateTime(fromdate).ToString("yyyy-MM-dd");
todate = Convert.ToDateTime(todate).AddDays(1).ToString("yyyy-MM-dd");
query.Append(", 'DateCreated' : { '$gte': ISODate('" + fromdate + "'), '$lt': ISODate('" + todate + "') }");
}
query.AppendLine("}");
var sort = new StringBuilder();
sort.AppendLine("{");
sort.AppendLine("'CardNo': 1");
sort.AppendLine("}");
return(await _MN_KeyCardRepository.GetPaging(MongoHelper.ConvertQueryStringToDocument(query.ToString()), MongoHelper.ConvertQueryStringToDocument(sort.ToString()), pageNumber, pageSize));
}
public async Task <GridModel <WM_Schedule> > GetPaging(string key, int pageNumber, int pageSize)
{
var query = new StringBuilder();
query.AppendLine("{");
if (!string.IsNullOrWhiteSpace(key))
{
query.AppendLine("'$or': [");
query.AppendLine("{ 'Title': { '$in': [/" + key + "/i] } }");
query.AppendLine(", { 'Description': { '$in': [/" + key + "/i] } }");
query.AppendLine("]");
}
query.AppendLine("}");
var sort = new StringBuilder();
sort.AppendLine("{");
sort.AppendLine("'DateCreated': -1");
sort.AppendLine("}");
return(await _WM_ScheduleRepository.GetPaging(MongoHelper.ConvertQueryStringToDocument(query.ToString()), MongoHelper.ConvertQueryStringToDocument(sort.ToString()), pageNumber, pageSize));
}
private async Task <GridModel <MN_Customer> > GetPaging(string key, string customergroupid, int pageNumber, int pageSize)
{
var query = new StringBuilder();
query.AppendLine("{");
if (!string.IsNullOrWhiteSpace(key))
{
query.AppendLine("'$or': [");
query.AppendLine("{ 'Name': { '$in': [/" + key + "/i] } }");
query.AppendLine(", { 'Description': { '$in': [/" + key + "/i] } }");
query.AppendLine("]");
}
if (!string.IsNullOrWhiteSpace(customergroupid))
{
query.AppendLine(", 'CustomerGroupId': { '$eq': '" + customergroupid + "' }");
}
query.AppendLine("}");
var sort = new StringBuilder();
sort.AppendLine("{");
sort.AppendLine("'CustomerGroupId': 1");
sort.AppendLine(", 'Name': 1");
sort.AppendLine("}");
return(await _MN_CustomerRepository.GetPaging(MongoHelper.ConvertQueryStringToDocument(query.ToString()), MongoHelper.ConvertQueryStringToDocument(sort.ToString()), pageNumber, pageSize));
}
public async Task <GridModel <MN_License> > GetPaging(string key, string fromdate, string todate, int pageNumber, int pageSize)
{
//if (!string.IsNullOrWhiteSpace(fromdate))
//{
// fromdate = Convert.ToDateTime(fromdate).ToString("yyyy/MM/dd HH:mm:ss");
//}
//if (!string.IsNullOrEmpty(todate))
//{
// todate = Convert.ToDateTime(todate).ToString("yyyy/MM/dd HH:mm:ss");
//}
var query = new StringBuilder();
query.AppendLine("{");
if (!string.IsNullOrWhiteSpace(key))
{
query.AppendLine("'$or': [");
query.AppendLine("{ 'Name': { '$in': [/" + key + "/i] } }");
query.AppendLine(", { 'ProjectName': { '$in': [/" + key + "/i] } }");
query.AppendLine("]");
}
query.AppendLine("}");
var sort = new StringBuilder();
sort.AppendLine("{");
sort.AppendLine("'ProjectName': 1");
sort.AppendLine("}");
return(await _MN_LicenseRepository.GetPaging(MongoHelper.ConvertQueryStringToDocument(query.ToString()), MongoHelper.ConvertQueryStringToDocument(sort.ToString()), pageNumber, pageSize));
}
public async Task <GridModel <SY_NotificationCustomView> > GetPagingByFirst(int pageNumber, int pageSize)
{
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("}");
var sort = new StringBuilder();
sort.AppendLine("{");
sort.AppendLine("'DateCreated': -1");
sort.AppendLine("}");
var data = await _SY_NotificationRepository.GetPaging(MongoHelper.ConvertQueryStringToDocument(query.ToString()), MongoHelper.ConvertQueryStringToDocument(sort.ToString()), pageNumber, pageSize);
var cus = new List <SY_NotificationCustomView>();
foreach (var item in data.Data)
{
cus.Add(new SY_NotificationCustomView()
{
dateCreated = item.DateCreated.ToString("dd/MM/yyyy HH:mm"),
description = item.Description,
id = item.Id,
title = item.Title
});
}
var k = new GridModel <SY_NotificationCustomView>()
{
Data = cus,
PageIndex = pageNumber,
PageSize = pageSize,
TotalIem = data.TotalIem,
TotalPage = data.TotalPage
};
return(k);
}
public async Task <MessageReport> CompleteComponent(PM_ComponentComplete model)
{
var result = new MessageReport(false, "Có lỗi xảy ra");
try
{
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'ProjectId': { '$eq': '" + model.ProjectId + "' }");
query.AppendLine(", 'ComponentId': { '$eq': '" + model.ComponentId + "' }");
query.AppendLine(", 'UserId': { '$eq': '" + model.UserId + "' }");
query.AppendLine("}");
var k = await _PM_WorkRepository.GetManyToList(MongoHelper.ConvertQueryStringToDocument(query.ToString()));
var obj = k.FirstOrDefault();
//
if (obj == null)
{
result = new MessageReport(false, "Không tồn tại component với bạn");
return(await Task.FromResult(result));
}
//Cập nhật
obj.IsCompleted = true;
obj.DateCompleted = DateTime.Now;
obj.IsOnScheduled = true;
//Lấy dự án
var objProject = await GetProjectById(model.ProjectId);
if (objProject == null)
{
result = new MessageReport(false, "Component không tồn tại");
return(await Task.FromResult(result));
}
//Kiểm tra có đúng hạn
var objComponent = await GetComponentById(model.ComponentId);
if (objComponent == null)
{
result = new MessageReport(false, "Component không tồn tại");
return(await Task.FromResult(result));
}
//Kiểm tra đúng hạn
if (obj.DateCompleted > objComponent.DateEnd)
{
obj.IsOnScheduled = false;
}
result = await UpdateWork(obj);
//Gửi thông báo tới những người liên quan (user create, user do)
SendMessage(objProject, objComponent, model.UserId);
}
catch (Exception ex)
{
result = new MessageReport(false, ex.Message);
}
return(await Task.FromResult(result));
}