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