public async Task <bool> DecliceReceive(string receiveID)
{
var receive = _repoReceive.FindSingle(x => x.ID.Trim() == receiveID.Trim());
var receiveDetail = await _repoReceiveDetail.FindAll(x => x.ReceiveID.Trim() == receiveID.Trim()).ToListAsync();
if (receive != null)
{
_repoReceive.Remove(receive);
_repoReceiveDetail.RemoveMultiple(receiveDetail);
try
{
return(await _repoReceive.SaveAll());
}
catch (Exception)
{
return(false);
}
}
else
{
return(false);
}
}
public async Task <PagedList <ReceiveInformationModel> > SearchWithPaginations(PaginationParams param, string userLogin, HistoryParam filterParam)
{
var receives = _repoReceive.FindAll(x => x.Status.Trim() != "-1");
var products = _repoProduct.FindAll();
var users = _repoUser.FindAll();
var departments = _repoDepartment.FindAll();
var userCurrent = _repoUser.FindSingle(x => x.ID.Trim() == userLogin.Trim());
if (userCurrent.RoleID == 0 || userCurrent.RoleID == 1)
{
}
else if (userCurrent.RoleID == 2)
{
receives = receives.Where(x => x.DepID.Trim() == userCurrent.DepID.Trim() &&
x.Status.Trim() != "2");
}
else if (userCurrent.RoleID == 3)
{
receives = receives.Where(x => x.UserID.Trim() == userLogin);
}
if (filterParam.UserID != null && filterParam.UserID != string.Empty)
{
receives = receives.Where(x => x.UserID.Trim() == filterParam.UserID.Trim());
}
if (filterParam.From_Date != "" && filterParam.To_Date != "")
{
receives = receives.Where(x => x.Register_Date >= Convert.ToDateTime(filterParam.From_Date + " 00:00:00.000") &&
x.Register_Date <= Convert.ToDateTime(filterParam.To_Date + " 23:59:59.997"));
}
if (filterParam.ProductID != null && filterParam.ProductID != string.Empty)
{
var receiveDetails = _repoReceiveDetail.FindAll(x => x.ProductID.Trim() == filterParam.ProductID.Trim()).
GroupBy(x => x.ReceiveID).Select(x => x.Key);
receives = receives.Where(x => receiveDetails.Contains(x.ID.Trim()));
}
if (filterParam.Status != null && filterParam.Status != string.Empty)
{
receives = receives.Where(x => x.Status.Trim() == filterParam.Status.Trim());
}
var data = await(from a in receives
join c in departments on a.DepID.Trim() equals c.ID.Trim()
join d in users on a.UserID.Trim() equals d.ID.Trim()
select new ReceiveInformationModel()
{
ID = a.ID,
UserID = a.UserID,
UserName = d.Name,
Accept_ID = a.Accept_ID,
DepID = a.DepID,
DepName = c.Name_LL,
DepName_ZW = c.Name_ZW,
Register_Date = a.Register_Date,
Accept_Date = a.Accept_Date,
Updated_By = a.Updated_By,
Status = a.Status.Trim(),
Updated_Time = a.Updated_Time
}).OrderByDescending(x => x.Register_Date).ToListAsync();
foreach (var item in data)
{
if (item.Accept_ID != null)
{
var userAccept = users.Where(x => x.ID.Trim() == item.Accept_ID.Trim()).FirstOrDefault();
if (userAccept != null)
{
item.AcceptName = userAccept.Name;
}
}
}
return(PagedList <ReceiveInformationModel> .Create(data, param.PageNumber, param.PageSize));
}
public async Task <List <Receive_Detail> > GetAllReceiveDetail(string receiveId)
{
var receiveDetails = await _repoReceiveDetail.FindAll(x => x.ReceiveID.Trim() == receiveId.Trim()).ToListAsync();
return(receiveDetails);
}