public object JTable([FromBody] JTableModelAct jTablePara)
{
int intBegin = (jTablePara.CurrentPage - 1) * jTablePara.Length;
var listCommon = _context.CommonSettings.Select(x => new { x.CodeSet, x.ValueSet });
var query = (from a in _context.AssetAtivitys
join b in listCommon on a.ActType equals b.CodeSet into b1
where (!a.IsDeleted &&
(string.IsNullOrEmpty(jTablePara.ActCode) || (a.ActCode.ToLower().Contains(jTablePara.ActCode.ToLower()))) &&
(string.IsNullOrEmpty(jTablePara.ActTitle) || (a.ActTitle.ToLower().Contains(jTablePara.ActTitle.ToLower()))) &&
(string.IsNullOrEmpty(jTablePara.ActType) || (a.ActType.Equals(jTablePara.ActType))) &&
(string.IsNullOrEmpty(jTablePara.ActNote) || (a.ActNote.ToLower().Contains(jTablePara.ActNote.ToLower()))))
select new AssetAtivitysJtableModel
{
ActivityId = a.ActivityId,
ActCode = a.ActCode,
ActTitle = a.ActTitle,
ActType = a.ActType,
ActNote = a.ActNote,
ActMember = a.ActMember
}).AsParallel();
int count = query.Count();
var data = query.AsQueryable().OrderUsingSortExpression(jTablePara.QueryOrderBy).Skip(intBegin).Take(jTablePara.Length);
var jdata = JTableHelper.JObjectTable(data.ToList(), jTablePara.Draw, count, "ActivityId", "ActCode", "ActTitle", "ActType", "ActNote", "ActMember");
return(Json(jdata));
}
public object JTableADD([FromBody] JTableModelAct jTablePara)
{
int intBegin = (jTablePara.CurrentPage - 1) * jTablePara.Length;
var query = (from a in _context.AssetTransferDetails
join b in _context.AssetTransferHeaders on a.Ticketcode equals b.Ticketcode into b1
from b2 in b1.DefaultIfEmpty()
//join c in _context.AdGroupUsers on b.Departtransf equals c.GroupUserId.ToString() into c1
//from c2 in c1.DefaultIfEmpty()
select new
{
a.AssetID,
a.Quantity,
//a.Status,
a.Note,
a.AssetName,
b2.DepartTransf,
b2.DepartReceived,
a.Ticketcode
}).AsParallel();
int count = query.Count();
var data = query.AsQueryable().OrderUsingSortExpression(jTablePara.QueryOrderBy).Skip(intBegin).Take(jTablePara.Length);
var jdata = JTableHelper.JObjectTable(data.ToList(), jTablePara.Draw, count, "AssetName", "AssetID", "Quantity", "Status", "DepartTransf", "Ticketcode", "DepartReceived");
return(Json(jdata));
}
public object JTable([FromBody] JTableModelAct jTablePara)
{
int intBegin = (jTablePara.CurrentPage - 1) * jTablePara.Length;
var listCommon = _context.CommonSettings.Select(x => new { x.CodeSet, x.ValueSet });
var query = (from a in _context.AssetTransferDetails
select new
{
a.AssetID,
a.AssetName,
a.AssetCode,
a.Quantity,
a.CostValue,
a.CreatedBy,
a.CreatedTime,
//a.StatusÁ,
a.Note,
a.ListImage,
a.UpdatedBy,
a.UpdatedTime,
}).AsParallel();
int count = query.Count();
var data = query.AsQueryable().OrderUsingSortExpression(jTablePara.QueryOrderBy).Skip(intBegin).Take(jTablePara.Length);
var jdata = JTableHelper.JObjectTable(data.ToList(), jTablePara.Draw, count, "AssetID", "AssetName", "AssetCode", "Quantity", "CostValue", "CreatedBy", "CreatedTime", "Status", "Note", "ListImage", "UpdatedBy", "UpdatedTime");
return(Json(jdata));
}
public object JTableADD([FromBody] JTableModelAct jTablePara)
{
int intBegin = (jTablePara.CurrentPage - 1) * jTablePara.Length;
var listCommon = _context.CommonSettings.Select(x => new { x.CodeSet, x.ValueSet });
var query = (from a in _context.AssetCancelDetails
select new
{
a.AssetID,
a.Title,
a.QuantityAsset,
a.Status,
a.Note
}).AsParallel();
int count = query.Count();
var data = query.AsQueryable().OrderUsingSortExpression(jTablePara.QueryOrderBy).Skip(intBegin).Take(jTablePara.Length);
var jdata = JTableHelper.JObjectTable(data.ToList(), jTablePara.Draw, count, "AssetID", "Title", "Quantity", "Status", "Note");
return(Json(jdata));
}
public object JTable([FromBody] JTableModelAct jTablePara)
{
var fromDate = !string.IsNullOrEmpty(jTablePara.FromTime) ? DateTime.ParseExact(jTablePara.FromTime, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null;
var toDate = !string.IsNullOrEmpty(jTablePara.ToTime) ? DateTime.ParseExact(jTablePara.ToTime, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null;
int intBegin = (jTablePara.CurrentPage - 1) * jTablePara.Length;
string Currency = jTablePara.Currency;
var query = from a in _context.FundAccEntrys
join b in _context.FundCatReptExpss.Where(x => x.IsDeleted == false)
on a.CatCode equals b.CatCode
where (!a.IsDeleted &&
((fromDate == null) || (a.DeadLine.HasValue && a.DeadLine.Value.Date >= fromDate)) &&
((toDate == null) || (a.DeadLine.HasValue && a.DeadLine.Value.Date <= toDate))) &&
(string.IsNullOrEmpty(jTablePara.AetType) || (a.AetType.Equals(jTablePara.AetType))) &&
(string.IsNullOrEmpty(jTablePara.Status) || (a.Status.Equals(jTablePara.Status))) &&
(string.IsNullOrEmpty(jTablePara.IsPlan) || (a.IsPlan.Equals(Convert.ToBoolean(jTablePara.IsPlan))))
orderby a.CreatedTime
select new
{
CatName = b.CatName,
Id = a.Id,
AetCode = a.AetCode,
Title = a.Title,
AetType = a.AetType,
AetRelativeType = a.AetRelativeType,
AetDescription = a.AetDescription,
Total = a.Total,
Payer = a.Payer,
Currency = a.Currency,
Status = a.Status,
Receiptter = a.Receiptter,
DeadLine = a.DeadLine
};
int count = query.Count();
var data = query.AsQueryable().OrderUsingSortExpression(jTablePara.QueryOrderBy).Skip(intBegin).Take(jTablePara.Length);
var jdata = JTableHelper.JObjectTable(data.ToList(), jTablePara.Draw, count, "Id", "AetCode", "Title", "AetType", "AetDescription", "Total", "Payer", "Receiptter", "Currency", "IsPlan", "Status", "CatName", "DeadLine");
return(Json(jdata));
}
//[HttpPost]
public async Task <object> JTable([FromBody] JTableModelAct jTablePara)
{
var urlChange = "https://api.exchangeratesapi.io/latest?base=USD";
var obj = await CommonUtil.SendAPIRequest(urlChange);
JObject jObject = JObject.Parse(obj.Object.ToString());
JToken rate = jObject["rates"];
var listChangeRate = new List <ChangeRate>();
foreach (var item in rate)
{
var key = ((Newtonsoft.Json.Linq.JProperty)item).Name;
var value = ((Newtonsoft.Json.Linq.JProperty)item).Value.ToString();
var objRate = new ChangeRate
{
Key = key,
Value = value,
};
listChangeRate.Add(objRate);
}
int intBegin = (jTablePara.CurrentPage - 1) * jTablePara.Length;
var query = from a in listChangeRate
where (string.IsNullOrEmpty(jTablePara.Currency) || a.Key.ToLower().Equals(jTablePara.Currency.ToLower()))
select new FundExchagRatesJtableModel
{
Currency = a.Key,
Rate = decimal.Parse(a.Value)
};
int count = query.Count();
var data = query.AsQueryable().OrderUsingSortExpression(jTablePara.QueryOrderBy).Skip(intBegin).Take(jTablePara.Length);
var jdata = JTableHelper.JObjectTable(data.ToList(), jTablePara.Draw, count, "Id", "Currency", "Rate");
return(Json(jdata));
}
public object JTableTicket([FromBody] JTableModelAct jTablePara)
{
int intBegin = (jTablePara.CurrentPage - 1) * jTablePara.Length;
var query = (from a in _context.AssetTransferHeaders
join b in _context.AdGroupUsers on a.DepartTransf equals b.GroupUserId.ToString() into b1
from b2 in b1.DefaultIfEmpty()
join c in _context.HREmployees on a.UserTransf equals c.Id.ToString() into c1
from c2 in c1.DefaultIfEmpty()
join d in _context.CommonSettings.Where(x => x.Group == "ASSET_TRANSFER_HEADER") on a.Status equals d.CodeSet into d1
from d2 in d1.DefaultIfEmpty()
where (!a.IsDeleted)
//join c in _context.AdGroupUsers on a.DepartReceived equals c.GroupUserId.ToString() into c1
//from c2 in c1.DefaultIfEmpty()
//join b in listCommon on a.ActType equals b.CodeSet into b1
select new
{
a.AssetID,
a.Ticketcode,
DepartTransf = b2.Title,
DepartReceived = b2.Title,
a.StartTime,
a.ReceivedTime,
a.Ticket,
a.QRcode,
a.LocationTransf,
a.ReceivedLocation,
UserTransf = c2.fullname,
UserReceived = c2.fullname,
Status = d2.ValueSet,
a.Note
}).AsParallel();
int count = query.Count();
var data = query.AsQueryable().OrderUsingSortExpression(jTablePara.QueryOrderBy).Skip(intBegin).Take(jTablePara.Length);
var jdata = JTableHelper.JObjectTable(data.ToList(), jTablePara.Draw, count, "Ticket", "AssetID", "Ticketcode", "DepartTransf", "DepartReceived", "StartTime", "ReceivedTime", "QRcode", "LocationTransf", "ReceivedLocation", "UserTransf", "UserReceived", "Status", "Note");
return(Json(jdata));
}
