public void Save(ComplainViewModel complain)
{
Complains compalinsmodel = GetEntity(complain);
using (var _context = new NasscomEntities())
{
var tt = _context.Complains.ToList();
Complains complaincheck = _context.Complains.Find(compalinsmodel.ContactNumber);
if (complaincheck != null)
{
complaincheck.Name = compalinsmodel.Name;
complaincheck.Email = compalinsmodel.Email;
complaincheck.ContactNumber = compalinsmodel.ContactNumber;
complaincheck.Location = compalinsmodel.Location;
complaincheck.Compactor = compalinsmodel.Compactor;
complaincheck.Description = compalinsmodel.Description;
}
else
{
_context.Complains.Add(compalinsmodel);
}
_context.SaveChanges();
}
}
public void Save(List <DeploymentSheetModel> model)
{
using (var _context = new NasscomEntities())
{
foreach (var item in model)
{
if (item.Id > 0)
{
var updatedEntity = _context.DeploymentSheet.Find(item.Id);
updatedEntity.Id = item.Id;
updatedEntity.RouteNumber = item.RouteNumber;
updatedEntity.DeploymentDate = item.DeploymentDate;
updatedEntity.VehicleNo = item.VehicleNo;
updatedEntity.Substitute = item.Substitute;
updatedEntity.StaffId = item.StaffId;
updatedEntity.StaffType = item.StaffType;
_context.Entry(updatedEntity).State = EntityState.Modified;
}
else
{
var entity = GetEntity(item);
_context.DeploymentSheet.Add(entity);
}
_context.SaveChanges();
}
}
}
public List <ComplainViewModel> GetAllComplains()
{
List <ComplainViewModel> complains = null;
using (var _context = new NasscomEntities())
{
complains = (from complain in _context.Complains
select
new ComplainViewModel
{
ComplainID = complain.ComplainID,
Name = complain.Name,
Email = complain.Email,
ContactNumber = complain.ContactNumber,
Location = complain.Location,
Compactor = complain.Compactor,
Decription = complain.Description
}).ToList();
}
if (complains != null)
{
return(complains);
}
else
{
return(new List <ComplainViewModel>());
}
}
public ComplainViewModel GetComplains(string contactNumber)
{
ComplainViewModel complain = null;
using (var _context = new NasscomEntities())
{
complain = (from complains in _context.Complains
where complains.ContactNumber == contactNumber
select
new ComplainViewModel
{
Name = complains.Name,
Email = complains.Email,
ContactNumber = complains.ContactNumber,
Location = complains.Location,
Decription = complains.Description,
Compactor = complains.Compactor
}).FirstOrDefault();
}
if (complain != null)
{
return(complain);
}
else
{
return(new ComplainViewModel());
}
}
public void Save(StaffTypeViewModel staffTypeViewModel)
{
using (var _context = new NasscomEntities())
{
_context.StaffType.Add(GetEntity(staffTypeViewModel));
_context.SaveChanges();
}
}
public StaffTypeViewModel GetStaffTypeById(int id)
{
StaffTypeViewModel staffType = null;
using (var _context = new NasscomEntities())
{
staffType = (from allstafftypes in _context.StaffType where allstafftypes.Id == id select GetModel(allstafftypes)).FirstOrDefault();
}
return(staffType);
}
public List <DeploymentSheetViewModel> InitDeploymentSheet()
{
var result = new List <DeploymentSheetViewModel>();
using (var _context = new NasscomEntities())
{
var routes = _context.Route;
}
return(result);
}
public List <StaffTypeViewModel> GetAllStaffTypes()
{
List <StaffTypeViewModel> staffTypes = null;
using (var _context = new NasscomEntities())
{
staffTypes = (from allstaffTypes in _context.StaffType select GetModel(allstaffTypes)).ToList();
}
if (staffTypes != null)
{
return(staffTypes);
}
else
{
return(new List <StaffTypeViewModel>());
}
}
public List <LocationViewModel> GetAllLocations()
{
List <LocationViewModel> locations = null;
using (var _context = new NasscomEntities())
{
locations = (from alllocations in _context.Location select GetModel(alllocations)).ToList();
}
if (locations != null)
{
return(locations);
}
else
{
return(locations);
}
}
public VehicleViewModel GetVehicle(string vehicleNo)
{
VehicleViewModel vehicle = null;
using (var _context = new NasscomEntities())
{
vehicle = (from vehicles in _context.Vehicle where vehicles.VehicleNo == vehicleNo select GetModel(vehicles)).FirstOrDefault();
}
if (vehicle != null)
{
return(vehicle);
}
else
{
return(new VehicleViewModel());
}
}
public CompactorViewModel GetCompactorById(int id)
{
CompactorViewModel compactor = null;
using (var _context = new NasscomEntities())
{
compactor = (from allCompactors in _context.Compactor where allCompactors.Id == id select GetModel(allCompactors)).FirstOrDefault();
}
if (compactor != null)
{
return(compactor);
}
else
{
return(new CompactorViewModel());
}
}
public List <CompactorViewModel> GetAllCompactors()
{
List <CompactorViewModel> compactors = null;
using (var _context = new NasscomEntities())
{
compactors = (from compactor in _context.Compactor select GetModel(compactor)).ToList();
}
if (compactors != null)
{
return(compactors);
}
else
{
return(new List <CompactorViewModel>());
}
}
public List <VehicleViewModel> GetAllVehicles()
{
List <VehicleViewModel> vehicles = null;
using (var _context = new NasscomEntities())
{
vehicles = (from vehicle in _context.Vehicle select GetModel(vehicle)).ToList();
}
if (vehicles != null)
{
return(vehicles);
}
else
{
return(new List <VehicleViewModel>());
}
}
public List <StaffViewModel> GetAllStaffMembers()
{
List <StaffViewModel> allStaffMembers = null;
using (var _context = new NasscomEntities())
{
allStaffMembers = (from staffmembers in _context.Staff select GetModel(staffmembers)).ToList();
}
if (allStaffMembers != null)
{
return(allStaffMembers);
}
else
{
return(new List <StaffViewModel>());
}
}
public LocationViewModel GetLocationById(int id)
{
LocationViewModel location = null;
using (var _context = new NasscomEntities())
{
location = (from alllocations in _context.Location where alllocations.Id == id select GetModel(alllocations)).FirstOrDefault();
}
if (location != null)
{
return(location);
}
else
{
return(new LocationViewModel());
}
}
public List <RouteViewModel> GetAllRoutes()
{
List <RouteViewModel> routes = null;
using (var _context = new NasscomEntities())
{
routes = (from allroutes in _context.Route select GetModel(allroutes)).ToList();
}
if (routes != null)
{
return(routes);
}
else
{
return(new List <RouteViewModel>());
}
}
public RouteViewModel GetRouteByRouteNum(string routeNum)
{
RouteViewModel route = null;
using (var _context = new NasscomEntities())
{
route = (from allroutes in _context.Route where allroutes.RouteNumber == routeNum select GetModel(allroutes)).FirstOrDefault();
}
if (route != null)
{
return(route);
}
else
{
return(new RouteViewModel());
}
}
public RouteViewModel GetRouteById(int id)
{
RouteViewModel route = null;
using (var _context = new NasscomEntities())
{
route = (from allroutes in _context.Route where allroutes.Id == id select GetModel(allroutes)).FirstOrDefault();
}
if (route != null)
{
return(route);
}
else
{
return(new RouteViewModel());
}
}
public void Save(LocationViewModel locationViewModel)
{
using (var _context = new NasscomEntities())
{
Location location = (from locations in _context.Location where locations.Id == locationViewModel.Id select locations).FirstOrDefault();
if (location != null)
{
location.Id = locationViewModel.Id;
location.Description = locationViewModel.Description;
location.Name = locationViewModel.Name;
}
else
{
_context.Location.Add(GetEntity(locationViewModel));
}
_context.SaveChanges();
}
}
public void Save(CompactorViewModel compactorViewModel)
{
using (var _context = new NasscomEntities())
{
Compactor compactor = _context.Compactor.Find(compactorViewModel.Id);
if (compactor != null)
{
compactor.CompactorNumber = compactorViewModel.CompactorNumber;
compactor.LocationId = compactorViewModel.LocationId;
compactor.Make = compactorViewModel.Make;
compactor.Size = compactorViewModel.Size;
}
else
{
_context.Compactor.Add(GetEntity(compactorViewModel));
}
_context.SaveChanges();
}
}
public void Save(StaffViewModel staffmember)
{
using (var _context = new NasscomEntities())
{
Staff staff = (from staffs in _context.Staff where staffs.Id == staffmember.Id select staffs).FirstOrDefault();
if (staff != null)
{
staff.Name = staffmember.Name;
staff.Phone = staffmember.Phone;
staff.Type = staffmember.Type;
staff.Email = staffmember.Email;
}
else
{
_context.Staff.Add(GetEntity(staffmember));
}
_context.SaveChanges();
}
}
public void Save(VehicleViewModel vehicle)
{
Vehicle vehiclemodel = GetEntity(vehicle);
using (var _context = new NasscomEntities())
{
Vehicle vehiclecheck = _context.Vehicle.Find(vehiclemodel);
if (vehiclecheck != null)
{
vehiclecheck.Make = vehiclemodel.Make;
vehiclecheck.RegistrationDate = vehiclemodel.RegistrationDate;
vehiclecheck.VehicleNo = vehiclemodel.VehicleNo;
}
else
{
_context.Vehicle.Add(vehiclemodel);
}
_context.SaveChanges();
}
}
public void Save(RouteViewModel routeViewModel)
{
using (var _context = new NasscomEntities())
{
Route route = (from routes in _context.Route where routes.Id == routeViewModel.Id select routes).FirstOrDefault();
if (route != null)
{
route.CrewID = routeViewModel.CrewID;
route.DriverID = routeViewModel.DriverID;
route.Id = routeViewModel.Id;
route.Location = routeViewModel.Location;
route.RouteNumber = routeViewModel.RouteNumber;
route.VehicleNo = routeViewModel.VehicleNo;
route.WorkerID = routeViewModel.WorkerID;
}
else
{
_context.Route.Add(GetEntity(routeViewModel));
}
}
}
public List <VehicleViewModel> GetAllVehicles()
{
List <VehicleViewModel> vehicles = null;
using (var _context = new NasscomEntities())
{
vehicles = (from vehicle in _context.Vehicle
select
new VehicleViewModel
{
VehicleNumber = vehicle.VehicleNo,
RegistrationYear = vehicle.RegistrationDate.HasValue ? SqlFunctions.StringConvert((double)vehicle.RegistrationDate.Value.Year) : "2001",
VehicleDetails = vehicle.Make
}).ToList();
}
if (vehicles != null)
{
return(vehicles);
}
else
{
return(new List <VehicleViewModel>());
}
}
public Repository()
{
_context = new NasscomEntities();
}