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