public dynamic GetCustomerAssignData(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); dynamic obj = param; string SupplierOrderID = obj.data.SupplierOrderID; int ProductID = obj.data.ProductID; DateTime Date = obj.data.Month; var MainQuery = from result in (from cu in RepositoryContext.CustomerAssign join cud in RepositoryContext.CustomerAssignDetail on cu.customerassignID equals cud.customerassignID join cod in RepositoryContext.CustomerOrder on cud.customerOrderID equals cod.customerOrderID where cu.supplierorderID == SupplierOrderID && cu.assignweek == Date && cu.productID == ProductID && cu.inactive == true select new { CustomerAssignID = cu.customerassignID, CustomerOrderID = cud.customerOrderID, CustomerName = RepositoryContext.Customer.Where(x => x.customerID == cod.customerID).Select(x => x.customername).FirstOrDefault(), OrderLiter = cud.orderliter, AssignLiter = cud.assignliter }) group result by new { result.CustomerOrderID } into t1 select new { CustomerOrderID = t1.Key.CustomerOrderID, t1.FirstOrDefault().CustomerName, t1.FirstOrDefault().CustomerAssignID, t1.FirstOrDefault().OrderLiter, AssignLiter = (t1.Sum(x => x.AssignLiter)), OrderBalance = t1.FirstOrDefault().OrderLiter - (t1.Sum(x => x.AssignLiter)) }; return(MainQuery.ToDataSourceResult(request)); }
public dynamic GetMovementTransaction(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); dynamic obj = param; string SupplierOrderID = obj.data; var MainQuery = (from main in RepositoryContext.MovementTransaction where main.inactive == true && main.supplierOrderID == SupplierOrderID select new { MovementID = main.movementID, MovementDate = main.movementDate.ToString("yyyy-MM-dd"), tankID = main.tankID, id = main.productID, Product = (from p in RepositoryContext.Product where p.productID == main.productID select new { id = p.productID, Name = p.productName, }).ToList(), isNew = true, FlowMeter = main.flowmeter, TLGStart = main.TLG_Start, TLGEnd = main.TLG_End, TLGVolume = main.TLG_Volume, OnlyDelete = main.flowmeter != null ? true : false }); return(MainQuery.ToDataSourceResult(request)); }
public dynamic GetAllProduct(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var MainQuery = (from main in RepositoryContext.Product where main.inactive == true select new { id = main.productID, Name = main.productName, }); return(MainQuery.ToDataSourceResult(request)); }
public dynamic GetAllStaffList(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var MainQuery = (from main in RepositoryContext.FuelFillingStaff where main.inactive == true select new { StaffID = main.staffID, StaffName = main.staffname, Address = main.address, Phone = main.phone, Code = main.code, Email = main.email, main.access_status }); return(MainQuery.ToDataSourceResult(request)); }
public dynamic GetAllCustomerList(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var MainQuery = (from main in RepositoryContext.Customer where main.inactive == true select new { CustomerID = main.customerID, CustomerName = main.customername, Address = main.address, Phone = main.phone, Code = main.code, Email = main.email, main.access_status }); return(MainQuery.ToDataSourceResult(request)); }
public dynamic GetLaneDataList(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); dynamic obj = param; dynamic objresponse = null; var Main = (from lane in RepositoryContext.Lane where lane.inactive == true select new { LaneID = lane.laneID, LaneName = lane.laneName, HoseNo = string.Join(",", RepositoryContext.Hose.Where(a => a.laneID == lane.laneID && a.inactive == true).Select(a => a.hoseNumber).ToArray()), }); return(objresponse = Main.ToDataSourceResult(request)); }
public dynamic GetAllBowserList(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var MainQuery = (from main in RepositoryContext.Bowser where main.inactive == true select new { BowserID = main.bowserID, BowserName = main.bowserName, Address = main.address, Phone = main.phone, CarNo = main.carNo, OwnerName = main.ownerName, Status = main.status, userType = main.user_type }); return(MainQuery.ToDataSourceResult(request)); }
/* public int CheckDuplicateAdminNRC(int adminID, string nrc) { * return FindByCondition(x => x.AdminID != adminID && x.nrc == nrc).Count(); * } */ public dynamic GetAdmins(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var mainQuery = (from main in RepositoryContext.Admin join level in RepositoryContext.Adminlevel on main.AdminLevelID equals level.AdminLevelID select new { main.AdminID, main.AdminLevelID, main.AdminName, main.LoginName, level.AdminLevel, main.Email, main.ImagePath, main.access_status }); return(mainQuery.ToDataSourceResult(request)); }
public dynamic GetAllSaleInvoiceList(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var Query = (from main in RepositoryContext.SaleInvoice join customer in RepositoryContext.Customer on main.customerID equals customer.customerID where main.inactive == true && customer.inactive == true select new { saleinvoiceID = main.saleinvoiceID, invoiceDate = main.invoiceDate.ToString("yyyy-MM-dd"), customername = customer.customername, totalamount = main.totalamount, Disamount = main.discount, paidamount = main.netamount, } ); return(Query.ToDataSourceResult(request)); }
public dynamic GetAllDriverList(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var MainQuery = (from main in RepositoryContext.Driver join ge in RepositoryContext.General on main.township equals ge.id where main.inactive == true select new { DriverID = main.driverID, Name = main.name, Address = main.address, Phone = main.phone, CardNo = main.cardNo, License = main.license, Township = ge.name, Photo = main.photo }); return(MainQuery.ToDataSourceResult(request)); }
public dynamic GetAllCompany(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var MainQuery = (from main in RepositoryContext.Company where main.inactive == true select new { CompanyID = main.companyID, CompanyName = main.name, Address = main.address, Phone = main.phone, Code = main.code, Township = (from general in RepositoryContext.General where main.township == general.id select general.name).FirstOrDefault(), State = (from general in RepositoryContext.General where main.state == general.id select general.name).FirstOrDefault(), }); return(MainQuery.ToDataSourceResult(request)); }
public dynamic GetAllDemandOrderList(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var MainQuery = (from main in RepositoryContext.DemandOrder join driver in RepositoryContext.Driver on main.driverID equals driver.driverID join bowser in RepositoryContext.Bowser on main.bowserID equals bowser.bowserID join customer in RepositoryContext.Customer on main.customerID equals customer.customerID where main.inactive == true select new { DemandOrderID = main.demandorderID, OrderDate = main.deliveryorderDate, DriverName = driver.name, CarNo = bowser.carNo, Customer = customer.customername, DeliveryDate = main.deliveryDate, }); return(MainQuery.ToDataSourceResult(request)); }
public dynamic GetAllCashRecriptList(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var Query = (from main in RepositoryContext.CashReceipt // join SaleInvoice in RepositoryContext.SaleInvoice on main.saleinvoiceID equals SaleInvoice.saleinvoiceID join customer in RepositoryContext.Customer on main.customerID equals customer.customerID where main.inactive == true && customer.inactive == true select new { cashreceiptID = main.cashreceiptID, saleinvoiceID = main.saleinvoiceID, invoiceDate = main.paymentDate.ToString("yyyy-MM-dd"), customername = customer.customername, netamount = main.netAmount, balance = main.balance, paidamount = main.paidAmount, } ); return(Query.ToDataSourceResult(request)); }
public dynamic GetCustomerAssignOrderByMonth(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); dynamic obj = param; int ProductID = obj.data.ProductID; DateTime Date = obj.data.Month; int Month = Date.Month; int Year = Date.Year; int Day = Date.Day; string[] CustomerOrderID = obj.data.selectedOrder.Value.Split(","); var MainQuery = (from de in RepositoryContext.CustomerOrderDetail join cu in RepositoryContext.CustomerOrder on de.customerOrderID equals cu.customerOrderID where cu.inactive == true && de.productID == ProductID && cu.ordermonth.Month == Month && cu.ordermonth.Year == Year && CustomerOrderID.Contains(de.customerOrderID) select new { CustomerAssignID = 0, CustomerOrderID = cu.customerOrderID, CustomerName = RepositoryContext.Customer.Where(x => x.customerID == cu.customerID).Select(x => x.customername).FirstOrDefault(), OrderLiter = Day <= 7 ? de.week1_liter : Day <= 14 ? de.week2_liter : Day <= 21 ? de.week3_liter : de.week4_liter, AssignLiter = 0, tt = (from c in RepositoryContext.CustomerAssign join cd in RepositoryContext.CustomerAssignDetail on c.customerassignID equals cd.customerassignID where cd.customerOrderID == de.customerOrderID && c.productID == ProductID select cd.assignliter).FirstOrDefault(), OrderBalance = (from c in RepositoryContext.CustomerAssign join cd in RepositoryContext.CustomerAssignDetail on c.customerassignID equals cd.customerassignID where cd.customerOrderID == de.customerOrderID && c.productID == ProductID && c.assignweek.Month == Month && c.assignweek.Day == Day && c.inactive == true select c.customerassignID).Count() > 0 ? (Day <= 7 ? de.week1_liter : Day <= 14 ? de.week2_liter : Day <= 21 ? de.week3_liter : de.week4_liter) - (from c in RepositoryContext.CustomerAssign join cd in RepositoryContext.CustomerAssignDetail on c.customerassignID equals cd.customerassignID where cd.customerOrderID == de.customerOrderID && c.productID == ProductID && c.assignweek.Month == Month && c.assignweek.Day == Day && c.inactive == true select cd.assignliter).Sum() : Day <= 7 ? de.week1_liter : Day <= 14 ? de.week2_liter : Day <= 21 ? de.week3_liter : de.week4_liter }); var aa = MainQuery.ToList(); return(MainQuery.ToDataSourceResult(request)); }
public dynamic GetAllSupplierOrderList(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); dynamic obj = param; var MainQuery = (from main in RepositoryContext.SupplierOrder where main.inactive == true select new { SupplierOrderID = main.supplierOrderID, Supplier = main.suppliername, ArrivalDate = main.arrivaldate, Shipment = main.shipment }); if (obj.data.FromDate.ToString() != "") { DateTime fromDate = obj.data.FromDate; MainQuery = MainQuery.Where(m => m.ArrivalDate >= fromDate); } if (obj.data.ToDate.ToString() != "") { DateTime toDate = obj.data.ToDate; MainQuery = MainQuery.Where(m => m.ArrivalDate <= toDate); } if (obj.data.supplierName.ToString() != "") { string supplierName = obj.data.supplierName; MainQuery = MainQuery.Where(m => m.Supplier.ToLower().Contains(supplierName)); } if (obj.data.shipment.ToString() != "") { string shipment = obj.data.shipment; MainQuery = MainQuery.Where(m => m.Shipment.ToLower().Contains(shipment)); } return(MainQuery.ToDataSourceResult(request)); }
public dynamic GetTankDataList(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); dynamic obj = param; dynamic objresponse = null; var Main = (from Tanklist in RepositoryContext.Tank where Tanklist.inactive == true select new { TankID = Tanklist.tankID, TankName = Tanklist.tankname, ProductID = Tanklist.productID, ProductName = RepositoryContext.Product.Where(a => a.productID == Tanklist.productID && a.inactive == true).Select(a => a.productName).FirstOrDefault(), // TGLAddress = Tanklist.TLG_Address, // TempperatureAddress= Tanklist.temperatureAddress, // Balance = Tanklist.tankID, // Temperature = Tanklist.tankID, // TLGStatus = Tanklist.tankID, }); return(objresponse = Main.ToDataSourceResult(request)); }
public dynamic getEventlogReportList(dynamic param) { DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); dynamic obj = param; var mainQuery = from ev in RepositoryContext.EventLog join ad in RepositoryContext.Admin on ev.UserID equals ad.AdminID into tmp from c in tmp.DefaultIfEmpty() select new { ev.ID, LogDateTime = ev.LogDateTime.ToString("yyyy-MM-dd HH:mm:ss"), Message = (ev.LogType.ToString() == "2" ? ev.ErrMessage : ev.LogMessage), LogType = Enum.GetName(typeof(EventLogType), ev.LogType), Source = ev.Source, UserType = ev.UserType, ev.ipAddress, Name = c.AdminName, FormName = ev.FormName }; if (obj.data.FromDate.ToString() != "") { DateTime fromDate = obj.data.FromDate + " 00:00:00"; mainQuery = mainQuery.Where(m => Convert.ToDateTime(m.LogDateTime) >= fromDate); } if (obj.data.ToDate.ToString() != "") { DateTime toDate = obj.data.ToDate + " 23:59:59"; mainQuery = mainQuery.Where(m => Convert.ToDateTime(m.LogDateTime) <= toDate); } if (obj.data.logtype.ToString() != "") { String logtype = Convert.ToString(obj.data.logtype.Value); mainQuery = mainQuery.Where(m => m.LogType == logtype); } return(mainQuery.ToDataSourceResult(request)); }