public object GetFlights(DataTablesAjaxRequestModel tableModel)
{
int total = 0;
int totalFiltered = 0;
var records = _flightService.GetFlights(
tableModel.PageIndex,
tableModel.PageSize,
tableModel.SearchText,
out total,
out totalFiltered);
return(new
{
recordsTotal = total,
recordsFiltered = totalFiltered,
data = (from record in records
select new string[]
{
record.FlightId.ToString(),
record.FlightCode,
record.FlightName,
record.Source,
record.Destination,
record.AirportName,
record.TakeOfDate,
record.Time,
record.Price.ToString(),
record.Description,
record.FlightId.ToString()
}
).ToArray()
});
}
public object GetProjects(DataTablesAjaxRequestModel tableModel, int companyId)
{
int total = 0;
int totalFiltered = 0;
var records = _projectManagementService.GetProjects(
companyId,
tableModel.PageIndex,
tableModel.PageSize,
tableModel.SearchText,
out total,
out totalFiltered);
return(new
{
recordsTotal = total,
recordsFiltered = totalFiltered,
data = (from record in records
select new string[]
{
record.Id.ToString(),
record.Name,
record.Description,
record.Id.ToString()
}
).ToArray()
});
}
public JsonResult GridDataForStockPrices(DataTablesAjaxRequestModel dataTablesModel)
{
StockPriceViewModel model = new StockPriceViewModel();
var jsonData = model.GetPricesJson(dataTablesModel);
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public object GetDataDetails(DataTablesAjaxRequestModel tableModel)
{
int total = 0;
int totalFiltered = 0;
var records = _dataDetailsService.GetDataDetails(
tableModel.PageIndex,
tableModel.PageSize,
tableModel.SearchText,
out total,
out totalFiltered);
return(new
{
recordsTotal = total,
recordsFiltered = totalFiltered,
data = (from record in records
select new string[]
{
record.Id.ToString(),
record.FileName,
record.CreateDate.ToString(),
record.Status,
record.Id.ToString()
}
).ToArray()
});
}
public object GetBillInfo(DataTablesAjaxRequestModel tableModel)
{
int total = 0;
int totalFiltered = 0;
var records = _billService.GetBills(
tableModel.PageIndex,
tableModel.PageSize,
tableModel.SearchText,
tableModel.GetSortText(new string[] { "Month", "TotalUnitLocal", "DescoBillOfThisMonth", "UnitPriceForNextMonth" }),
out total,
out totalFiltered);
return(new
{
recordsTotal = total,
recordsFiltered = totalFiltered,
data = (from record in records
select new string[]
{
record.Month.ToString() + " - " + record.Year.ToString(),
record.TotalUnitLocal.ToString(),
record.DescoBillOfThisMonth.ToString(),
record.UnitPriceForNextMonth.ToString(),
record.Id.ToString()
}
).ToArray()
});
}
public object GetRoles(DataTablesAjaxRequestModel tableModel)
{
int total = 0;
int totalFiltered = 0;
var start = (tableModel.PageIndex - 1) * tableModel.PageSize;
IEnumerable <IdentityRole> records = null;
if (string.IsNullOrWhiteSpace(tableModel.SearchText))
{
records = _roleManager.Roles.Skip(start).Take(tableModel.PageSize);
}
else
{
records = _roleManager.Roles.Where(x => x.Name.Contains(tableModel.SearchText));
}
return(new
{
recordsTotal = total,
recordsFiltered = totalFiltered,
data = (from record in records
select new string[]
{
record.Id.ToString(),
record.Name,
record.Id.ToString()
}
).ToArray()
});
}
public object GetStocks(DataTablesAjaxRequestModel tableModel)
{
int total = 0;
int totalFiltered = 0;
var records = _stockService.GetStocks(
tableModel.PageIndex,
tableModel.PageSize,
tableModel.SearchText,
out total,
out totalFiltered);
return(new
{
recordsTotal = total,
recordsFiltered = totalFiltered,
data = (from record in records
select new string[]
{
record.Id.ToString(),
record.Product.Name,
record.TotalProductCount.ToString(),
record.TotalProductSale.ToString(),
record.TotalAmount.ToString(),
record.Id.ToString()
}
).ToArray()
});
}
internal object GetBooks(DataTablesAjaxRequestModel tableModel)
{
var data = _bookService.GetBooks(
tableModel.PageIndex,
tableModel.PageSize,
tableModel.SearchText,
tableModel.GetSortText(new string[] { "Title", "ImageName", "Description", "Edition", "PublicationDate", "Id" }));
return(new
{
recordsTotal = data.total,
recordsFiltered = data.totalDisplay,
data = (from record in data.records
select new string[]
{
record.Title,
record.ImageName,
//record.imageFile.ToString(),
record.Description,
record.Edition,
record.PublicationDate.ToString(),
record.Id.ToString()
}
).ToArray()
});
}
public object GetMedicines(DataTablesAjaxRequestModel tableModel)
{
var data = _medicineService.GetMedicines(
tableModel.PageIndex,
tableModel.PageSize,
tableModel.SearchText,
tableModel.GetSortText(new string[] { "Name", "Image", "Description", "Categories", "Price", "PriceDiscount.Amount", "Action" }));
return(new
{
recordsTotal = data.total,
recordsFiltered = data.totalDisplay,
data = (from record in data.records
select new string[]
{
record.Name,
record.Image.Url,
record.Description,
_medicineService.GetCategoryListAsStringForAMedicine(record.Categories),
record.Price.ToString(),
_medicineService.GetDiscountAsString(record.PriceDiscount),
//record.PriceDiscount.GetType().Name,
//record.PriceDiscount.Amount.ToString(),
record.Id.ToString()
}
).ToList()
});
}
public object GetReadings(DataTablesAjaxRequestModel tableModel)
{
int total = 0;
int totalFiltered = 0;
var records = _readingService.GetReadings(
TemporaryTenantid,
tableModel.PageIndex,
tableModel.PageSize,
tableModel.SearchText,
tableModel.GetSortText(new string[] { "TenantId", "MonthYear", "PreviousReading", "PresentReading", "DayOffset", "NetUnit", "PerUnitPrice", "TotalBillofThisMonth" }),
out total,
out totalFiltered);
return(new
{
recordsTotal = total,
recordsFiltered = totalFiltered,
data = (from record in records
select new string[]
{
_tenantService.GetTenant(record.TenantId).Name,
record.ReadingTakenDate.AddMonths(-1).ToString("MMMM,yyyy"),
record.PreviousReading.ToString(),
record.PresentReading.ToString(),
// record.DayOffset.ToString(),
record.NetUnit.ToString(),
record.PerUnitPrice.ToString(),
record.TotalBillofThisMonth.ToString(),
record.Id.ToString()
}
).ToArray()
});
}
internal object GetStock(DataTablesAjaxRequestModel tableModel)
{
var data = _stockMarketService.GetStock(
tableModel.PageIndex,
tableModel.PageSize,
tableModel.SearchText,
tableModel.GetSortText(new string[] { "date", "trade_code", "high", "low", "open", "close", "volumn" }));
return(new
{
recordsTotal = data.total,
recordsFiltered = data.totalDisplay,
data = (from record in data.records
select new string[]
{
record.date.ToString("dd/MM/yyyy"),
record.TradeCode.trade_code,
record.high.ToString(),
record.low.ToString(),
record.open.ToString(),
record.close.ToString(),
record.volumn.ToString(),
record.Id.ToString()
}
).ToArray()
});
}
public async Task <object> GetCommentsByIdAsync(DataTablesAjaxRequestModel tableModel, int id)
{
var result = await _commentService.GetCommentsByIdAsync(
id,
tableModel.SearchText,
tableModel.GetSortText(new string[] { "Title" }),
tableModel.PageIndex, tableModel.PageSize);
return(new
{
recordsTotal = result.Total,
recordsFiltered = result.TotalFilter,
data = (from item in result.Items
select new string[]
{
item.Name,
item.Email,
(item.Description.Substring(0, item.Description.Length - 1 > 30?30:item.Description.Length - 1) + "...").ToString(),
item.CommentTime.ToString(),
item.IsAuthorized == true?$"<span class=\"badge badge-pill badge-success\">Approved</span>":$"<span class=\"badge badge-pill badge-danger\">Pending</span>",
item.IsAuthorized == false?$"<button type=\"submit\" class=\"btn btn-success btn-sm show-bs-modal2\" href=\"#\" data-id='{item.Id}' value='${item.Id}'><i class=\"fas fa-check\"> </i>Approve</button>"
:$"<button type=\"submit\" class=\"btn btn-danger btn-sm show-bs-modal3\" href=\"#\" data-id='{item.Id}' value='${item.Id}'><i class=\"fas fa-times-circle\"> </i>Disapprove</button>",
item.Id.ToString()
}).ToArray()
});
}
public JsonResult GetInvoiceJsonData(DataTablesAjaxRequestModel model)
{
Guid id = (Guid)TempData["invoiceData"];
var jsonData = new OrderListModel().GetInvoiceJsonData(model, id);
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
internal object GetCampaign(DataTablesAjaxRequestModel tableModel)
{
var data = _campaignService.GetCampaign(
tableModel.PageIndex,
tableModel.PageSize,
tableModel.SearchText,
tableModel.GetSortText(new string[] { "Name", "Subject", "Body", "Datetime", "GroupId", "Status" }));
return(new
{
recordsTotal = data.total,
recordsFiltered = data.totalDisplay,
data = (from record in data.records
select new string[]
{
record.Name,
record.Subject,
record.Body,
record.Datetime.ToString("dd/mm/yyyy"),
record.GroupId.ToString(),
record.Status.ToString(),
record.Id.ToString()
}
).ToArray()
});
}
internal object GetBlog(DataTablesAjaxRequestModel tableModel)
{
var data = _blogService.GetBlog(
tableModel.PageIndex,
tableModel.PageSize,
tableModel.SearchText,
tableModel.GetSortText(new string[] { "Title", "Text", "datetime", "Image", "Category" }));
return(new
{
recordsTotal = data.total,
recordsFiltered = data.totalDisplay,
data = (from record in data.records
select new string[]
{
record.Title,
record.Text,
record.datetime.ToString("dd/mm/yyyy"),
record.Image,
record.Category.Name,
record.Id.ToString()
}
).ToArray()
});
}
internal object GetPricesJson(DataTablesAjaxRequestModel dataTablesModel)
{
try
{
Guid currentUserID = Guid.Parse(HttpContext.Current.User.Identity.GetUserId());
int pageIndex = dataTablesModel.GetPageIndex();
int pageSize = dataTablesModel.GetPageSize();
string sortOrder = dataTablesModel.GetSortElements(new string[] { "ID",
"Ticker", "Price", "ID" });
string searchText = dataTablesModel.GetSearchText();
int totalRecords = 0;
int totalDisplayableRecords = 0;
ICollection <StockSymbol> stockSymbols = new List <StockSymbol>();
if (!string.IsNullOrWhiteSpace(searchText))
{
stockSymbols = _unitOfWork.StockSymbolRepository.GetDynamic(out totalRecords, out totalDisplayableRecords,
x => x.UserID == currentUserID && x.Ticker.Contains(searchText), sortOrder).ToList();
}
else
{
stockSymbols = _unitOfWork.StockSymbolRepository.GetDynamic(out totalRecords, out totalDisplayableRecords,
x => x.UserID == currentUserID, sortOrder).ToList();
}
totalRecords = _unitOfWork.StockSymbolRepository.GetCount(x => x.UserID == currentUserID);
if (stockSymbols == null || stockSymbols.Count == 0)
{
return(DataTablesAjaxRequestModel.EmptyResult);
}
ICollection <StockPrice> records = GetPriceFromAPI(stockSymbols);
var jsonData = new
{
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalDisplayableRecords,
aaData = (
from record in records
select new string[]
{
record.Symbol,
record.Price.ToString()
}
).ToArray()
};
return(jsonData);
}
catch (Exception ex)
{
_log.Create().WriteLog(LogType.HandledLog, this.GetType().Name, "SaveStockSymbol", ex, "Failed to add stock symbol");
UserSession.ActionResponseMessage = new ActionResponse("Failed to get symbol list", ActionResponseMessageType.Error);
}
return(DataTablesAjaxRequestModel.EmptyResult);
}
public async Task <IActionResult> GetCommentsById(int id)
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = Startup.AutofacContainer.Resolve <CommentModel>();
var data = await model.GetCommentsByIdAsync(tableModel, id);
return(Json(data));
}
public ActionResult GetArticles()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = new ArticleViewModel();
var data = model.GetArticles(tableModel);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public IActionResult GetAllFiles()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = new FileViewModel();
var data = model.GetFile(tableModel);
return(Json(data));
}
public IActionResult GetBooks()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = new BookModel(_configuration);
var data = model.GetBooks(tableModel);
return(Json(data));
}
public IActionResult GetBills()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = new BillViewModel();
var data = model.GetBillInfo(tableModel);
return(Json(data));
}
public IActionResult GetDataDetails()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = new DataDetailsViewModel();
var data = model.GetDataDetails(tableModel);
return(Json(data));
}
public IActionResult GetTenants()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = new TenantViewModel();
var data = model.GetTenantAndContactPerson(tableModel);
return(Json(data));
}
public IActionResult GetCategories()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = new CategoryViewModel();
var data = model.GetCategories(tableModel);
return(Json(data));
}
public IActionResult GetComment()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = Startup.AutofacContainer.Resolve <CommentModel>();
var data = model.GetComment(tableModel);
return(Json(data));
}
public IActionResult GetRecords()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = Startup.AutofacContainer.Resolve <RegistrationModel>();
var data = model.GetRecords(tableModel);
return(Json(data));
}
public async Task <IActionResult> GetCategories()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = Startup.AutofacContainer.Resolve <CategoryModel>();
var data = await model.GetAllAsync(tableModel);
return(Json(data));
}
public IActionResult ShowSubjects()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = Startup.AutofacContainer.Resolve <GetSubjectModel>();
var data = model.GetSubjects(tableModel);
return(Json(data));
}
public IActionResult getreadings(int id)
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = new ReadingViewModel();
var data = model.GetReadings(tableModel);
return(Json(data));
}
public IActionResult GetTeams()
{
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = new TeamUpdateModel();
var data = model.GetTeams(tableModel, userId);
return(Json(data));
}
