public static DataSourceResult GetDrivers([DataSourceRequest] DataSourceRequest request)
{
DataSourceResult drivers;
using (var db = new truckloadEntities())
{
var query = from h in db.Drivers select h;
drivers = query.Select(d => new VmDriver()
{
DriverId = d.DriverId,
Email = d.Email,
FirstName = d.FirstName,
LastName = d.LastName,
IsActive = d.IsActive,
IsEmployee = d.IsEmployee,
PhoneNumber = d.PhoneNumber,
TdgTrainingDate = d.TdgTrainingDate,
WhmisTrainingDate = d.WhmisTrainingDate,
LicenseExpireDate = d.LicenseExpireDate,
}).ToDataSourceResult(request);
}
return(drivers);
}
public static List <VmKoOrder> GetOrdersList(truckloadEntities db, VmUser currentUser, long?orderId = null, string orderNumberFilter = "", long?loadId = null)
{
var isSingleOrder = orderId != null;
var isByLoadId = loadId != null;
var query = from h in db.Orders select h;
if (isSingleOrder)
{
query = query.Where(o => o.OrderId == orderId);
}
query = isByLoadId ?
query.Where(o => o.LoadId == loadId) :
query.Where(o => o.LoadId == null);
if (!orderNumberFilter.IsNullOrEmpty())
{
query = query.Where(o => o.OrderNumber.Contains(orderNumberFilter));
}
var orders = query.Select(d => new VmKoOrder()
{
OrderId = d.OrderId,
OrderNumber = d.OrderNumber,
CustomerName = d.CustomerName,
CustomerAddress = d.CustAddress,
UserName = d.UserLogin1.UserName ?? d.UserLogin.UserName,
LastChangeDate = d.ModifiedDate ?? d.CreatedDate,
UnitDescription = "" + d.Volume + " " + d.UnitOfMeasure.Description + " / " + d.WeightKg + "KG",
PickupDate = d.PickupDate,
DeliveryDate = d.DeliveryDate,
WarehouseDescription = d.Warehouse.Description,
IsCustomerPickup = d.IsCustomerPickup,
IsDangerousGoods = d.IsDangerousGoods,
IsDraggable = currentUser.UserLevel > 1,
LoadSort = d.LoadSort ?? 0,
WarehouseId = d.WarehouseId,
UnitOfMeasureId = d.UnitOfMeasureId,
Destination = d.Destination,
Notes = d.Notes,
Volume = d.Volume ?? 0,
WeightKg = d.WeightKg
}).ToList();
return(orders);
}
public static DataSourceResult GetWarehouses([DataSourceRequest] DataSourceRequest request)
{
DataSourceResult warehouses;
using (var db = new truckloadEntities())
{
var query = from h in db.Warehouses select h;
warehouses = query.Select(d => new VmWarehouse()
{
WarehouseId = d.WarehouseId,
IsActive = d.IsActive,
WarehouseCode = d.WarehouseCode,
Description = d.Description
}).ToDataSourceResult(request);
}
return(warehouses);
}
public static DataSourceResult GetTrucks([DataSourceRequest] DataSourceRequest request)
{
DataSourceResult trucks;
using (var db = new truckloadEntities())
{
var query = from h in db.Trucks select h;
trucks = query.Select(d => new VmTruck()
{
TruckId = d.TruckId,
TruckDescription = d.TruckDescription,
NextInspectionDate = d.NextInspectionDate,
NextMaintenanceDate = d.NextMaintenanceDate,
IsActive = d.IsActive,
}).ToDataSourceResult(request);
}
return(trucks);
}
public static DataSourceResult GetTrailers([DataSourceRequest] DataSourceRequest request)
{
DataSourceResult trailers;
using (var db = new truckloadEntities())
{
var query = from h in db.Trailers select h;
trailers = query.Select(d => new VmTrailer()
{
TrailerId = d.TrailerId,
TrailerDescription = d.TrailerDescription,
AxlesDescription = d.AxlesDescription,
CapacityKg = d.CapacityKg,
TrailerTypeId = d.TrailerTypeId,
UnitOfMeasureId = d.UnitOfMeasureId,
Volume = d.Volume,
IsActive = d.IsActive,
}).ToDataSourceResult(request);
}
return(trailers);
}
public static long LogException(Exception exception, string exeptionUrl, string globalId)
{
using (var db = new truckloadEntities())
{
var error = GetErrorFromException(exception);
var newError = new Error()
{
ExceptionMsg = error.ExceptionMsg,
ExceptionType = error.ExceptionType,
ExceptionURL = exeptionUrl,
ExceptionSource = exception.StackTrace,
utcLogdate = DateTime.UtcNow,
GlobalId = globalId.Split('\\').Last()
};
db.Errors.Add(newError);
db.SaveChanges();
return(newError.ExceptionId);
}
}
public BaseController()
{
//Database.SetInitializer<truckloadEntities>(null);
Db = new truckloadEntities();
}
