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)); }