public static FleetViewModel GetByFleetId(string fleetid)
{
FleetViewModel result = new FleetViewModel();
using (var db = new FleetManagementContext())
{
result = (from flt in db.MstFleets
join kar in db.MstKaroseris
on flt.KaroseriId equals kar.KaroseriId
join tyb in db.MstTypeBus
on flt.TypeId equals tyb.TypeId
join mrk in db.MstMerkBus
on tyb.MerkId equals mrk.MerkId
//where flt.Id == fleetid
where flt.FleetId == fleetid
select new FleetViewModel
{
Id = flt.Id,
FleetId = flt.FleetId,
TypeId = flt.TypeId,
TypeName = tyb.Description,
MerkId = tyb.MerkId,
MerkName = mrk.MerkId,
LicenseNumber = flt.LicenseNumber,
KaroseriId = flt.KaroseriId,
KaroseriName = kar.Description,
SeatCapacity = flt.SeatCapacity,
IsActive = flt.IsActive
}).FirstOrDefault();
}
return(result);
}
public static CustomerViewModel GetById(int id)
{
CustomerViewModel result = new CustomerViewModel();
using (var db = new FleetManagementContext())
{
result = (from ctm in db.MstCustomers
where ctm.Id == id
select new CustomerViewModel
{
Id = ctm.Id,
CustomerId = ctm.CustomerId,
CustomerName = ctm.CustomerName,
OrganizationName = ctm.OrganizationName,
CustomerAddress = ctm.CustomerAddress,
OrganizationAddress = ctm.OrganizationAddress,
IdNumber = ctm.IdNumber,
CustomerPhone = ctm.CustomerPhone,
OrganizationPhone = ctm.OrganizationPhone,
OrganizationEmail = ctm.OrganizationEmail,
IsActive = ctm.IsActive
}).FirstOrDefault();
}
return(result);
}
public static List <FleetViewModel> GetAll()
{
List <FleetViewModel> result = new List <FleetViewModel>();
using (var db = new FleetManagementContext())
{
result = (from flt in db.MstFleets
join kar in db.MstKaroseris
on flt.KaroseriId equals kar.KaroseriId
join tyb in db.MstTypeBus
on flt.TypeId equals tyb.TypeId
join mrk in db.MstMerkBus
on tyb.MerkId equals mrk.MerkId
select new FleetViewModel
{
Id = flt.Id,
FleetId = flt.FleetId,
TypeId = flt.TypeId,
TypeName = tyb.Description,
MerkId = tyb.MerkId,
MerkName = mrk.Description,
LicenseNumber = flt.LicenseNumber,
KaroseriId = flt.KaroseriId,
KaroseriName = kar.Description,
SeatCapacity = flt.SeatCapacity,
IsActive = flt.IsActive
}).ToList();
}
return(result);
}
public static List <OrderViewModel> GetAll()
{
List <OrderViewModel> result = new List <OrderViewModel>();
using (var db = new FleetManagementContext())
{
result = (from od in db.TrxOrders
join ctm in db.MstCustomers
on od.CustomerId equals ctm.CustomerId
select new OrderViewModel
{
Id = od.Id,
OrderId = od.OrderId,
CustomerId = od.CustomerId,
CustomerName = ctm.CustomerName,
OrderName = od.OrderName,
OrderDate = od.OrderDate,
Destination = od.Destination,
StartDate = od.StartDate,
EndDate = od.EndDate,
TotalPerson = od.TotalPerson,
OrderStatus = od.OrderStatus
}).ToList();
}
return(result);
}
public static List <TypeBusViewModel> GetAll()
{
List <TypeBusViewModel> result = new List <TypeBusViewModel>();
using (var db = new FleetManagementContext())
{
result = (from tb in db.MstTypeBus
join mb in db.MstMerkBus
on tb.MerkId equals mb.MerkId
select new TypeBusViewModel
{
Id = tb.Id,
MerkId = tb.MerkId,
MerkName = mb.Description,
TypeId = tb.TypeId,
Description = tb.Description,
IsActive = tb.IsActive,
CreatedBy = tb.CreatedBy,
Created = tb.Created,
ModifiedBy = tb.ModifiedBy,
Modified = tb.Modified
}).ToList();
}
return(result);
}
public static TypeBusViewModel GetById(int id)
{
TypeBusViewModel result = new TypeBusViewModel();
using (var db = new FleetManagementContext())
{
result = (from tb in db.MstTypeBus
join mb in db.MstMerkBus
on tb.MerkId equals mb.MerkId
where tb.Id == id
select new TypeBusViewModel
{
Id = tb.Id,
MerkId = tb.MerkId,
MerkName = mb.Description,
TypeId = tb.TypeId,
Description = tb.Description,
IsActive = tb.IsActive,
CreatedBy = tb.CreatedBy,
Created = tb.Created,
ModifiedBy = tb.ModifiedBy,
Modified = tb.Modified
}).FirstOrDefault();
}
return(result);
}
public static List <CustomerViewModel> GetByFilter(string filterstring)
{
List <CustomerViewModel> result = new List <CustomerViewModel>();
using (var db = new FleetManagementContext())
{
result = (from ctm in db.MstCustomers
select new CustomerViewModel
{
Id = ctm.Id,
CustomerId = ctm.CustomerId,
CustomerName = ctm.CustomerName,
OrganizationName = ctm.OrganizationName,
CustomerAddress = ctm.CustomerAddress,
OrganizationAddress = ctm.OrganizationAddress,
IdNumber = ctm.IdNumber,
CustomerPhone = ctm.CustomerPhone,
OrganizationPhone = ctm.OrganizationPhone,
OrganizationEmail = ctm.OrganizationEmail,
IsActive = ctm.IsActive
}).ToList();
result = result.Where(o => o.CustomerId.ToLower().Contains(filterstring.ToLower()) ||
o.CustomerName.ToLower().Contains(filterstring.ToLower()) ||
o.OrganizationName.ToLower().Contains(filterstring.ToLower())).ToList();
}
return(result);
}
public static bool Update(CustomerViewModel model)
{
bool result = true;
try
{
using (var db = new FleetManagementContext())
{
if (model.Id == 0)
{
MstCustomer ctm = new MstCustomer();
ctm.CustomerId = model.CustomerId;
ctm.CustomerName = model.CustomerName;
ctm.OrganizationName = model.OrganizationName;
ctm.CustomerAddress = model.CustomerAddress;
ctm.OrganizationAddress = model.OrganizationAddress;
ctm.IdNumber = model.IdNumber;
ctm.CustomerPhone = model.CustomerPhone;
ctm.OrganizationPhone = model.OrganizationPhone;
ctm.OrganizationEmail = model.OrganizationEmail;
ctm.IsActive = model.IsActive;
db.MstCustomers.Add(ctm);
db.SaveChanges();
}
else
{
MstCustomer ctm = db.MstCustomers.Where(o => o.Id == model.Id).FirstOrDefault();
if (ctm != null)
{
ctm.CustomerId = model.CustomerId;
ctm.CustomerName = model.CustomerName;
ctm.OrganizationName = model.OrganizationName;
ctm.CustomerAddress = model.CustomerAddress;
ctm.OrganizationAddress = model.OrganizationAddress;
ctm.IdNumber = model.IdNumber;
ctm.CustomerPhone = model.CustomerPhone;
ctm.OrganizationPhone = model.OrganizationPhone;
ctm.OrganizationEmail = model.OrganizationEmail;
ctm.IsActive = model.IsActive;
db.SaveChanges();
}
}
}
}
catch (Exception Ex)
{
Message = Ex.Message;
result = false;
}
return(result);
}
public static bool Update(CrewViewModel model)
{
bool result = true;
try
{
using (var db = new FleetManagementContext())
{
if (model.Id == 0)
{
MstCrew crw = new MstCrew();
crw.CrewId = model.CrewId;
crw.CrewName = model.CrewName;
crw.DrivingLicenseNumber = model.DrivingLicenseNumber;
crw.Address = model.Address;
crw.PlaceOfBirth = model.PlaceOfBirth;
crw.DateOfBirth = model.DateOfBirth;
crw.Gender = model.Gender;
crw.Role = model.Role;
crw.IsActive = model.IsActive;
db.MstCrews.Add(crw);
db.SaveChanges();
}
else
{
MstCrew crw = db.MstCrews.Where(o => o.Id == model.Id).FirstOrDefault();
if (crw != null)
{
crw.CrewId = model.CrewId;
crw.CrewName = model.CrewName;
crw.DrivingLicenseNumber = model.DrivingLicenseNumber;
crw.Address = model.Address;
crw.PlaceOfBirth = model.PlaceOfBirth;
crw.DateOfBirth = model.DateOfBirth;
crw.Gender = model.Gender;
crw.Role = model.Role;
crw.IsActive = model.IsActive;
db.SaveChanges();
}
}
}
}
catch (Exception Ex)
{
Message = Ex.Message;
result = false;
}
return(result);
}
public static bool Update(PartViewModel model)
{
bool result = true;
try
{
using (var db = new FleetManagementContext())
{
if (model.Id == 0)
{
MstPart part = new MstPart();
part.PartId = model.PartId;
part.Description = model.Description;
part.Price = model.Price;
part.IsActive = model.IsActive;
part.CreatedBy = model.CreatedBy;
part.Created = model.Created;
part.ModifiedBy = model.ModifiedBy;
part.Modified = model.Modified;
db.MstParts.Add(part);
db.SaveChanges();
}
else
{
MstPart part = db.MstParts.Where(o => o.Id == model.Id).FirstOrDefault();
if (part != null)
{
part.PartId = model.PartId;
part.Description = model.Description;
part.Price = model.Price;
part.IsActive = model.IsActive;
part.CreatedBy = model.CreatedBy;
part.Created = model.Created;
part.ModifiedBy = model.ModifiedBy;
part.Modified = model.Modified;
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
}
return(result);
}
public static bool Update(TypeBusViewModel model)
{
bool result = true;
try
{
using (var db = new FleetManagementContext())
{
if (model.Id == 0)
{
MstTypeBu typebus = new MstTypeBu();
typebus.MerkId = model.MerkId;
typebus.TypeId = model.TypeId;
typebus.Description = model.Description;
typebus.IsActive = model.IsActive;
typebus.CreatedBy = model.CreatedBy;
typebus.Created = model.Created;
typebus.ModifiedBy = model.ModifiedBy;
typebus.Modified = model.Modified;
db.MstTypeBus.Add(typebus);
db.SaveChanges();
}
else
{
MstTypeBu typebus = db.MstTypeBus.Where(o => o.Id == model.Id).FirstOrDefault();
if (typebus != null)
{
typebus.MerkId = model.MerkId;
typebus.TypeId = model.TypeId;
typebus.Description = model.Description;
typebus.IsActive = model.IsActive;
typebus.CreatedBy = model.CreatedBy;
typebus.Created = model.Created;
typebus.ModifiedBy = model.ModifiedBy;
typebus.Modified = model.Modified;
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
}
return(result);
}
public static List <KaroseriViewModel> GetAll()
{
List <KaroseriViewModel> result = new List <KaroseriViewModel>();
using (var db = new FleetManagementContext())
{
result = (from kar in db.MstKaroseris
select new KaroseriViewModel
{
Id = kar.Id,
KaroseriId = kar.KaroseriId,
Description = kar.Description,
IsActive = kar.IsActive
}).ToList();
}
return(result);
}
public static bool Update(ServiceViewModel model)
{
bool result = true;
try
{
using (var db = new FleetManagementContext())
{
if (model.Id == 0)
{
MstService service = new MstService();
service.ServiceId = model.ServiceId;
service.Description = model.Description;
service.IsActive = model.IsActive;
service.CreatedBy = model.CreatedBy;
service.Created = model.Created;
service.ModifiedBy = model.ModifiedBy;
service.Modified = model.Modified;
db.MstServices.Add(service);
db.SaveChanges();
}
else
{
MstService service = db.MstServices.Where(o => o.Id == model.Id).FirstOrDefault();
if (service != null)
{
service.ServiceId = model.ServiceId;
service.Description = model.Description;
service.IsActive = model.IsActive;
service.CreatedBy = model.CreatedBy;
service.Created = model.Created;
service.ModifiedBy = model.ModifiedBy;
service.Modified = model.Modified;
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
}
return(result);
}
public static KaroseriViewModel GetById(int id)
{
KaroseriViewModel result = new KaroseriViewModel();
using (var db = new FleetManagementContext())
{
result = (from kar in db.MstKaroseris
where kar.Id == id
select new KaroseriViewModel
{
Id = kar.Id,
KaroseriId = kar.KaroseriId,
Description = kar.Description,
IsActive = kar.IsActive
}).FirstOrDefault();
}
return(result);
}
public static bool Update(FleetViewModel model)
{
bool result = true;
try
{
using (var db = new FleetManagementContext())
{
if (model.Id == 0)
{
MstFleet flt = new MstFleet();
flt.FleetId = model.FleetId;
flt.TypeId = model.TypeId;
flt.LicenseNumber = model.LicenseNumber;
flt.KaroseriId = model.KaroseriId;
flt.SeatCapacity = model.SeatCapacity;
flt.IsActive = model.IsActive;
db.MstFleets.Add(flt);
db.SaveChanges();
}
else
{
MstFleet flt = db.MstFleets.Where(o => o.Id == model.Id).FirstOrDefault();
if (flt != null)
{
flt.FleetId = model.FleetId;
flt.TypeId = model.TypeId;
flt.LicenseNumber = model.LicenseNumber;
flt.KaroseriId = model.KaroseriId;
flt.SeatCapacity = model.SeatCapacity;
flt.IsActive = model.IsActive;
db.SaveChanges();
}
}
}
}
catch (Exception Ex)
{
Message = Ex.Message;
result = false;
}
return(result);
}
public static List <TypeBusViewModel> GetByMerkBus(string merkbusid)
{
List <TypeBusViewModel> result = new List <TypeBusViewModel>();
using (var db = new FleetManagementContext())
{
result = (from tb in db.MstTypeBus
join mb in db.MstMerkBus
on tb.MerkId equals mb.MerkId
where tb.MerkId == merkbusid
select new TypeBusViewModel
{
Id = tb.Id,
MerkId = tb.MerkId,
TypeId = tb.TypeId,
Description = tb.Description
}).ToList();
}
return(result);
}
public static List <MerkBusViewModel> GetAll()
{
List <MerkBusViewModel> result = new List <MerkBusViewModel>();
using (var db = new FleetManagementContext())
{
result = (from mb in db.MstMerkBus
select new MerkBusViewModel
{
Id = mb.Id,
MerkId = mb.MerkId,
Description = mb.Description,
IsActive = mb.IsActive,
CreatedBy = mb.CreatedBy,
Created = mb.Created,
ModifiedBy = mb.ModifiedBy,
Modified = mb.Modified
}).ToList();
}
return(result);
}
public static List <ServiceViewModel> GetAll()
{
List <ServiceViewModel> result = new List <ServiceViewModel>();
using (var db = new FleetManagementContext())
{
result = (from sr in db.MstServices
select new ServiceViewModel
{
Id = sr.Id,
ServiceId = sr.ServiceId,
Description = sr.Description,
IsActive = sr.IsActive,
CreatedBy = sr.CreatedBy,
Created = sr.Created,
ModifiedBy = sr.ModifiedBy,
Modified = sr.Modified,
}).ToList();
}
return(result);
}
public static ServiceViewModel GetById(int id)
{
ServiceViewModel result = new ServiceViewModel();
using (var db = new FleetManagementContext())
{
result = (from sr in db.MstServices
where sr.Id == id
select new ServiceViewModel
{
Id = sr.Id,
ServiceId = sr.ServiceId,
Description = sr.Description,
IsActive = sr.IsActive,
CreatedBy = sr.CreatedBy,
Created = sr.Created,
ModifiedBy = sr.ModifiedBy,
Modified = sr.Modified,
}).FirstOrDefault();
}
return(result);
}
public static List <PartViewModel> GetAll()
{
List <PartViewModel> result = new List <PartViewModel>();
using (var db = new FleetManagementContext())
{
result = (from pt in db.MstParts
select new PartViewModel
{
Id = pt.Id,
PartId = pt.PartId,
Description = pt.Description,
Price = pt.Price,
IsActive = pt.IsActive,
CreatedBy = pt.CreatedBy,
Created = pt.Created,
ModifiedBy = pt.ModifiedBy,
Modified = pt.Modified
}).ToList();
}
return(result);
}
public static MerkBusViewModel GetById(int id)
{
MerkBusViewModel result = new MerkBusViewModel();
using (var db = new FleetManagementContext())
{
result = (from mb in db.MstMerkBus
where mb.Id == id
select new MerkBusViewModel
{
Id = mb.Id,
MerkId = mb.MerkId,
Description = mb.Description,
IsActive = mb.IsActive,
CreatedBy = mb.CreatedBy,
Created = mb.Created,
ModifiedBy = mb.ModifiedBy,
Modified = mb.Modified
}).FirstOrDefault();
}
return(result);
}
public static bool Update(MaintenanceHeaderViewModel model)
{
bool result = true;
try
{
using (var db = new FleetManagementContext())
{
TrxMaintenanceHeader mh = new TrxMaintenanceHeader();
mh.Id = 1;
mh.MaintenanceId = model.MaintenanceId;
mh.MaintenanceDate = model.MaintenanceDate;
mh.FleetId = model.FleetId;
mh.MaintenanceKm = model.MaintenanceKm;
mh.TotalPrice = model.TotalPrice;
db.TrxMaintenanceHeaders.Add(mh);
foreach (var item in model.MaintenanceDetails)
{
TrxMaintenanceDetail md = new TrxMaintenanceDetail();
md.MaintenanceId = mh.MaintenanceId;
md.MechanicId = item.MechanicId;
md.ServiceId = item.ServiceId;
md.PartId = item.PartId;
md.PartQuantity = item.PartQuantity;
md.SubTotalPrice = item.SubTotalPrice;
db.TrxMaintenanceDetails.Add(md);
}
db.SaveChanges();
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
}
return(result);
}
public static bool Update(KaroseriViewModel model)
{
bool result = true;
try
{
using (var db = new FleetManagementContext())
{
if (model.Id == 0)
{
MstKaroseri kar = new MstKaroseri();
kar.KaroseriId = model.KaroseriId;
kar.Description = model.Description;
kar.IsActive = model.IsActive;
db.MstKaroseris.Add(kar);
db.SaveChanges();
}
else
{
MstKaroseri kar = db.MstKaroseris.Where(o => o.Id == model.Id).FirstOrDefault();
if (kar != null)
{
kar.KaroseriId = model.KaroseriId;
kar.Description = model.Description;
kar.IsActive = model.IsActive;
db.SaveChanges();
}
}
}
}
catch (Exception Ex)
{
Message = Ex.Message;
result = false;
}
return(result);
}
public static bool Delete(int id)
{
bool result = true;
try
{
using (var db = new FleetManagementContext())
{
MstKaroseri kar = db.MstKaroseris.Where(o => o.Id == id).FirstOrDefault();
if (kar != null)
{
db.MstKaroseris.Remove(kar);
db.SaveChanges();
}
}
}
catch (Exception Ex)
{
Message = Ex.Message;
result = false;
}
return(result);
}
public static List <CrewViewModel> GetAll()
{
List <CrewViewModel> result = new List <CrewViewModel>();
using (var db = new FleetManagementContext())
{
result = (from crw in db.MstCrews
select new CrewViewModel
{
Id = crw.Id,
CrewId = crw.CrewId,
CrewName = crw.CrewName,
DrivingLicenseNumber = crw.DrivingLicenseNumber,
Address = crw.Address,
PlaceOfBirth = crw.PlaceOfBirth,
DateOfBirth = crw.DateOfBirth,
Gender = crw.Gender,
Role = crw.Role,
IsActive = crw.IsActive
}).ToList();
}
return(result);
}
public static PartViewModel GetById(int id)
{
PartViewModel result = new PartViewModel();
using (var db = new FleetManagementContext())
{
result = (from pt in db.MstParts
where pt.Id == id
select new PartViewModel
{
Id = pt.Id,
PartId = pt.PartId,
Description = pt.Description,
Price = pt.Price,
IsActive = pt.IsActive,
CreatedBy = pt.CreatedBy,
Created = pt.Created,
ModifiedBy = pt.ModifiedBy,
Modified = pt.Modified
}).FirstOrDefault();
}
return(result);
}
public static bool Delete(int id)
{
bool result = true;
try
{
using (var db = new FleetManagementContext())
{
MstTypeBu typebus = db.MstTypeBus.Where(o => o.Id == o.Id).FirstOrDefault();
if (typebus != null)
{
db.MstTypeBus.Remove(typebus);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
}
return(result);
}
public static CrewViewModel GetById(int id)
{
CrewViewModel result = new CrewViewModel();
using (var db = new FleetManagementContext())
{
result = (from crw in db.MstCrews
where crw.Id == id
select new CrewViewModel
{
Id = crw.Id,
CrewId = crw.CrewId,
CrewName = crw.CrewName,
DrivingLicenseNumber = crw.DrivingLicenseNumber,
Address = crw.Address,
PlaceOfBirth = crw.PlaceOfBirth,
DateOfBirth = crw.DateOfBirth,
Gender = crw.Gender,
Role = crw.Role,
IsActive = crw.IsActive
}).FirstOrDefault();
}
return(result);
}
public static List <CrewViewModel> GetByAssistantException(FleetOrderException fleetorderexception)
{
List <CrewViewModel> result = new List <CrewViewModel>();
using (var db = new FleetManagementContext())
{
result = (from crw in db.MstCrews
where crw.Role == "A"
select new CrewViewModel
{
Id = crw.Id,
CrewId = crw.CrewId,
CrewName = crw.CrewName,
DrivingLicenseNumber = crw.DrivingLicenseNumber,
Address = crw.Address,
PlaceOfBirth = crw.PlaceOfBirth,
DateOfBirth = crw.DateOfBirth,
Gender = crw.Gender,
Role = crw.Role,
IsActive = crw.IsActive
}).Where(o => !fleetorderexception.assistantexceptlist.Contains(o.CrewId)).ToList();
}
return(result);
}
public static List <CustomerViewModel> GetAll()
{
List <CustomerViewModel> result = new List <CustomerViewModel>();
using (var db = new FleetManagementContext())
{
result = (from ctm in db.MstCustomers
select new CustomerViewModel
{
Id = ctm.Id,
CustomerId = ctm.CustomerId,
CustomerName = ctm.CustomerName,
OrganizationName = ctm.OrganizationName,
CustomerAddress = ctm.CustomerAddress,
OrganizationAddress = ctm.OrganizationAddress,
IdNumber = ctm.IdNumber,
CustomerPhone = ctm.CustomerPhone,
OrganizationPhone = ctm.OrganizationPhone,
OrganizationEmail = ctm.OrganizationEmail,
IsActive = ctm.IsActive
}).ToList();
}
return(result);
}
