public IHttpActionResult GetAllCustomers()
{
IList <CustomerViewModel> customers = null;
using (var ctx = new BikeShopEntities())
{
customers = ctx.CUSTOMERs.Select(c => new CustomerViewModel()
{
CustomerID = c.CUSTOMERID,
Phone = c.PHONE,
FirstName = c.FIRSTNAME,
LastName = c.LASTNAME,
Address = c.ADDRESS,
Zipcode = c.ZIPCODE,
CityID = c.CITYID,
BalanceDue = c.BALANCEDUE
}).ToList <CustomerViewModel>();
}
if (customers.Count == 0)
{
return(NotFound());
}
return(Ok(customers));
}
public IHttpActionResult GetAllPurchaseOrders()
{
IList <PurchaseOrderViewModel> purchaseorder = null;
using (var ctx = new BikeShopEntities())
{
purchaseorder = ctx.PURCHASEORDERs.Select(p => new PurchaseOrderViewModel()
{
PURCHASEID = p.PURCHASEID,
EMPLOYEEID = p.EMPLOYEEID,
MANUFACTURERID = p.MANUFACTURERID,
TOTALLIST = p.TOTALLIST,
SHIPPINGCOST = p.SHIPPINGCOST,
DISCOUNT = p.DISCOUNT,
ORDERDATE = p.ORDERDATE,
RECEIVEDATE = p.RECEIVEDATE,
AMOUNTDUE = p.AMOUNTDUE
}).ToList <PurchaseOrderViewModel>();
}
if (purchaseorder.Count == 0)
{
return(NotFound());
}
return(Ok(purchaseorder));
}
public IHttpActionResult GetEmployee(int id)
{
CustomerViewModel customer = null;
using (var ctx = new BikeShopEntities())
{
customer = ctx.CUSTOMERs
.Where(e => e.CUSTOMERID == id)
.Select(e => new CustomerViewModel()
{
CustomerID = e.CUSTOMERID,
Phone = e.PHONE,
FirstName = e.FIRSTNAME,
LastName = e.LASTNAME,
Address = e.ADDRESS,
Zipcode = e.ZIPCODE,
CityID = e.CITYID,
BalanceDue = e.BALANCEDUE
}).FirstOrDefault <CustomerViewModel>();
}
if (customer == null)
{
return(NotFound());
}
return(Ok(customer));
}
public IHttpActionResult GetAllTubeMaterials()
{
IList <TubeMaterialViewModel> tubematerial = null;
using (var ctx = new BikeShopEntities())
{
tubematerial = ctx.TUBEMATERIALs.Select(t => new TubeMaterialViewModel()
{
TUBEID = t.TUBEID,
MATERIAL = t.MATERIAL,
DESCRIPTION = t.DESCRIPTION,
DIAMETER = t.DIAMETER,
THICKNESS = t.THICKNESS,
ROUNDNESS = t.ROUNDNESS,
WEIGHT = t.WEIGHT,
STIFFNESS = t.STIFFNESS,
LISTPRICE = t.LISTPRICE,
CONSTRUCTION = t.CONSTRUCTION
}).ToList <TubeMaterialViewModel>();
}
if (tubematerial.Count == 0)
{
return(NotFound());
}
return(Ok(tubematerial));
}
public IHttpActionResult GetAllEmployees()
{
IList <EmployeeViewModel> employees = null;
using (var ctx = new BikeShopEntities())
{
employees = ctx.EMPLOYEEs.Select(e => new EmployeeViewModel()
{
EMPLOYEEID = e.EMPLOYEEID,
TAXPAYERID = e.TAXPAYERID,
LASTNAME = e.LASTNAME,
FIRSTNAME = e.FIRSTNAME,
HOMEPHONE = e.HOMEPHONE,
ADDRESS = e.ADDRESS,
ZIPCODE = e.ZIPCODE,
CITYID = e.CITYID,
DATEHIRED = e.DATEHIRED,
DATERELEASED = e.DATERELEASED,
CURRENTMANAGER = e.CURRENTMANAGER,
SALARYGRADE = e.SALARYGRADE,
SALARY = e.SALARY,
TITLE = e.TITLE,
WORKAREA = e.WORKAREA
}).ToList <EmployeeViewModel>();
}
if (employees.Count == 0)
{
return(NotFound());
}
return(Ok(employees));
}
public IHttpActionResult GetAllManufactorers()
{
IList <ManufactorerViewModel> manufactorer = null;
using (var ctx = new BikeShopEntities())
{
manufactorer = ctx.MANUFACTURERs.Select(m => new ManufactorerViewModel()
{
MANUFACTURERID = m.MANUFACTURERID,
MANUFACTURERNAME = m.MANUFACTURERNAME,
CONTACTNAME = m.CONTACTNAME,
PHONE = m.PHONE,
ADDRESS = m.ADDRESS,
ZIPCODE = m.ZIPCODE,
CITYID = m.CITYID,
BALANCEDUE = m.BALANCEDUE
}).ToList <ManufactorerViewModel>();
}
if (manufactorer.Count == 0)
{
return(NotFound());
}
return(Ok(manufactorer));
}
public IHttpActionResult GetAllModelSizes()
{
IList <ModelSizeViewModel> modelsize = null;
using (var ctx = new BikeShopEntities())
{
modelsize = ctx.MODELSIZEs.Select(m => new ModelSizeViewModel()
{
MODELTYPE = m.MODELTYPE,
MSIZE = m.MSIZE,
TOPTUBE = m.TOPTUBE,
CHAINSTAY = m.CHAINSTAY,
TOTALLENGTH = m.TOTALLENGTH,
GROUNDCLEARANCE = m.GROUNDCLEARANCE,
HEADTUBEANGLE = m.HEADTUBEANGLE,
SEATTUBEANGLE = m.SEATTUBEANGLE
}).ToList <ModelSizeViewModel>();
}
if (modelsize.Count == 0)
{
return(NotFound());
}
return(Ok(modelsize));
}
public IHttpActionResult GetAllCustomers()
{
IList <CustomerViewModel> customer = null;
using (var ctx = new BikeShopEntities())
{
customer = ctx.CUSTOMERs.Select(c => new CustomerViewModel()
{
CUSTOMERID = c.CUSTOMERID,
PHONE = c.PHONE,
FIRSTNAME = c.FIRSTNAME,
LASTNAME = c.LASTNAME,
ADDRESS = c.ADDRESS,
ZIPCODE = c.ZIPCODE,
CITYID = c.CITYID,
BALANCEDUE = c.BALANCEDUE
}).ToList <CustomerViewModel>();
}
if (customer.Count == 0)
{
return(NotFound());
}
return(Ok(customer));
}
public IHttpActionResult PostNewEmployee(EmployeeViewModel employee)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new BikeShopEntities())
{
ctx.EMPLOYEEs.Add(new EMPLOYEE()
{
EMPLOYEEID = employee.EmployeeID,
TAXPAYERID = employee.TaxpayerID,
LASTNAME = employee.LastName,
FIRSTNAME = employee.FirstName,
HOMEPHONE = employee.HomePhone,
ADDRESS = employee.Address,
ZIPCODE = employee.ZipCode,
CITYID = employee.CityID,
DATEHIRED = employee.DateHired,
DATERELEASED = employee.DateReleased,
CURRENTMANAGER = employee.CurrentManager,
SALARYGRADE = employee.SalaryGrade,
SALARY = employee.Salary,
TITLE = employee.Title,
WORKAREA = employee.Workarea
});
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult GetAllCities()
{
IList <CityViewModel> cities = null;
using (var ctx = new BikeShopEntities())
{
cities = ctx.CITies.Select(c => new CityViewModel()
{
CityID = c.CITYID,
ZipCode = c.ZIPCODE,
CityName = c.CITY1,
State = c.STATE,
AreaCode = c.AREACODE,
Population1990 = c.POPULATION1990,
Population1980 = c.POPULATION1980,
Country = c.COUNTRY,
Latitude = c.LATITUDE,
Longitude = c.LONGITUDE,
PopulationCDF = c.POPULATIONCDF
}).ToList <CityViewModel>();
}
if (cities.Count == 0)
{
return(NotFound());
}
return(Ok(cities));
}
public IHttpActionResult GetEmployee(int id)
{
EmployeeViewModel employee = null;
using (var ctx = new BikeShopEntities())
{
employee = ctx.EMPLOYEEs
.Where(e => e.EMPLOYEEID == id)
.Select(e => new EmployeeViewModel()
{
EmployeeID = e.EMPLOYEEID,
TaxpayerID = e.TAXPAYERID,
LastName = e.LASTNAME,
FirstName = e.FIRSTNAME,
HomePhone = e.HOMEPHONE,
Address = e.ADDRESS,
ZipCode = e.ZIPCODE,
CityID = e.CITYID,
DateHired = e.DATEHIRED,
DateReleased = e.DATERELEASED,
CurrentManager = e.CURRENTMANAGER,
SalaryGrade = e.SALARYGRADE,
Salary = e.SALARY,
Title = e.TITLE,
Workarea = e.WORKAREA
}).FirstOrDefault <EmployeeViewModel>();
}
if (employee == null)
{
return(NotFound());
}
return(Ok(employee));
}
public IHttpActionResult PostNewEmployee(EmployeeViewModel e)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new BikeShopEntities())
{
ctx.EMPLOYEEs.Add(new EMPLOYEE()
{
EMPLOYEEID = e.EMPLOYEEID,
TAXPAYERID = e.TAXPAYERID,
LASTNAME = e.LASTNAME,
FIRSTNAME = e.FIRSTNAME,
HOMEPHONE = e.HOMEPHONE,
ADDRESS = e.ADDRESS,
ZIPCODE = e.ZIPCODE,
CITYID = e.CITYID,
DATEHIRED = e.DATEHIRED,
DATERELEASED = e.DATERELEASED,
CURRENTMANAGER = e.CURRENTMANAGER,
SALARYGRADE = e.SALARYGRADE,
SALARY = e.SALARY,
TITLE = e.TITLE,
WORKAREA = e.WORKAREA
});
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult GetEmployee(int id)
{
CityViewModel city = null;
using (var ctx = new BikeShopEntities())
{
city = ctx.CITies
.Where(c => c.CITYID == id)
.Select(c => new CityViewModel()
{
CityID = c.CITYID,
ZipCode = c.ZIPCODE,
CityName = c.CITY1,
State = c.STATE,
AreaCode = c.AREACODE,
Population1990 = c.POPULATION1990,
Population1980 = c.POPULATION1980,
Country = c.COUNTRY,
Latitude = c.LATITUDE,
Longitude = c.LONGITUDE,
PopulationCDF = c.POPULATIONCDF
}).FirstOrDefault <CityViewModel>();
}
if (city == null)
{
return(NotFound());
}
return(Ok(city));
}
public IHttpActionResult GetBikePart(int serialNumber, int componentID)
{
BikePartsViewModel bikeParts = null;
using (var ctx = new BikeShopEntities())
{
bikeParts = ctx.BIKEPARTS
.Where(bp => bp.SERIALNUMBER == serialNumber && bp.COMPONENTID == componentID)
.Select(bp => new BikePartsViewModel()
{
SERIALNUMBER = bp.SERIALNUMBER,
COMPONENTID = bp.COMPONENTID,
SUBSTITUTEID = bp.SUBSTITUTEID,
LOCATION = bp.LOCATION,
QUANTITY = bp.QUANTITY,
DATEINSTALLED = bp.DATEINSTALLED,
EMPLOYEEID = bp.EMPLOYEEID
}).FirstOrDefault <BikePartsViewModel>();
}
if (bikeParts == null)
{
return(NotFound());
}
return(Ok(bikeParts));
}
public IHttpActionResult GetEmployee(int id)
{
EmployeeViewModel employee = null;
using (var ctx = new BikeShopEntities())
{
employee = ctx.EMPLOYEEs
.Where(e => e.EMPLOYEEID == id)
.Select(e => new EmployeeViewModel()
{
EMPLOYEEID = e.EMPLOYEEID,
TAXPAYERID = e.TAXPAYERID,
LASTNAME = e.LASTNAME,
FIRSTNAME = e.FIRSTNAME,
HOMEPHONE = e.HOMEPHONE,
ADDRESS = e.ADDRESS,
ZIPCODE = e.ZIPCODE,
CITYID = e.CITYID,
DATEHIRED = e.DATEHIRED,
DATERELEASED = e.DATERELEASED,
CURRENTMANAGER = e.CURRENTMANAGER,
SALARYGRADE = e.SALARYGRADE,
SALARY = e.SALARY,
TITLE = e.TITLE,
WORKAREA = e.WORKAREA
}).FirstOrDefault <EmployeeViewModel>();
}
if (employee == null)
{
return(NotFound());
}
return(Ok(employee));
}
public IHttpActionResult GetAllRetailStores()
{
IList <RetailStoreViewModel> retailstore = null;
using (var ctx = new BikeShopEntities())
{
retailstore = ctx.RETAILSTOREs.Select(r => new RetailStoreViewModel()
{
STOREID = r.STOREID,
STORENAME = r.STORENAME,
PHONE = r.PHONE,
CONTACTFIRSTNAME = r.CONTACTFIRSTNAME,
CONTACTLASTNAME = r.CONTACTLASTNAME,
ADDRESS = r.ADDRESS,
ZIPCODE = r.ZIPCODE,
CITYID = r.CITYID
}).ToList <RetailStoreViewModel>();
}
if (retailstore.Count == 0)
{
return(NotFound());
}
return(Ok(retailstore));
}
public IHttpActionResult PostNewEmployee(CityViewModel city)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new BikeShopEntities())
{
ctx.CITies.Add(new CITY()
{
CITYID = city.CityID,
ZIPCODE = city.ZipCode,
CITY1 = city.CityName,
STATE = city.State,
AREACODE = city.AreaCode,
POPULATION1990 = city.Population1990,
POPULATION1980 = city.Population1980,
COUNTRY = city.Country,
LATITUDE = city.Latitude,
LONGITUDE = city.Longitude,
POPULATIONCDF = city.PopulationCDF
});
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult GetAllComponents()
{
IList <ComponentViewModel> components = null;
using (var ctx = new BikeShopEntities())
{
components = ctx.COMPONENTs.Select(c => new ComponentViewModel()
{
COMPONENTID = c.COMPONENTID,
MANUFACTURERID = c.MANUFACTURERID,
PRODUCTNUMBER = c.PRODUCTNUMBER,
ROAD = c.ROAD,
CATEGORY = c.CATEGORY,
LENGTH = c.LENGTH,
HEIGHT = c.HEIGHT,
WIDTH = c.WIDTH,
WEIGHT = c.WEIGHT,
YEAR = c.YEAR,
ENDYEAR = c.ENDYEAR,
DESCRIPTION = c.DESCRIPTION,
LISTPRICE = c.LISTPRICE,
ESTIMATEDCOST = c.ESTIMATEDCOST,
QUANTITYONHAND = c.QUANTITYONHAND
}).ToList <ComponentViewModel>();
}
if (components.Count == 0)
{
return(NotFound());
}
return(Ok(components));
}
public IHttpActionResult GetAllStateTaxRates()
{
IList <StateTaxRateViewModel> taxrate = null;
using (var ctx = new BikeShopEntities())
{
taxrate = ctx.STATETAXRATEs.Select(s => new StateTaxRateViewModel()
{
STATE = s.STATE,
TAXRATE = s.TAXRATE
}).ToList <StateTaxRateViewModel>();
}
if (taxrate.Count == 0)
{
return(NotFound());
}
return(Ok(taxrate));
}
public IHttpActionResult GetAllSampleStreets()
{
IList <SampleStreetViewModel> samplestreet = null;
using (var ctx = new BikeShopEntities())
{
samplestreet = ctx.SAMPLESTREETs.Select(s => new SampleStreetViewModel()
{
ID = s.ID,
BASEADDRESS = s.BASEADDRESS
}).ToList <SampleStreetViewModel>();
}
if (samplestreet.Count == 0)
{
return(NotFound());
}
return(Ok(samplestreet));
}
public IHttpActionResult GetAllComponentNames()
{
IList<ComponentNameViewModel> componentname = null;
using (var ctx = new BikeShopEntities())
{
componentname = ctx.COMPONENTNAMEs.Select(c => new ComponentNameViewModel()
{
COMPONENTNAME1 = c.COMPONENTNAME1,
ASSEMBLYORDER = c.ASSEMBLYORDER,
DESCRIPTION = c.DESCRIPTION
}).ToList<ComponentNameViewModel>();
}
if (componentname.Count == 0)
{
return NotFound();
}
return Ok(componentname);
}
public IHttpActionResult GetAllWorkAreas()
{
IList <WorkAreaViewModel> workareas = null;
using (var ctx = new BikeShopEntities())
{
workareas = ctx.WORKAREAs.Select(w => new WorkAreaViewModel()
{
WORKAREA1 = w.WORKAREA1,
DESCRIPTION = w.DESCRIPTION
}).ToList <WorkAreaViewModel>();
}
if (workareas.Count == 0)
{
return(NotFound());
}
return(Ok(workareas));
}
public IHttpActionResult GetAllLetterStyle()
{
IList <LetterStyleViewModel> group = null;
using (var ctx = new BikeShopEntities())
{
group = ctx.LETTERSTYLEs.Select(c => new LetterStyleViewModel()
{
LetterStyle1 = c.LETTERSTYLE1,
Description = c.DESCRIPTION
}).ToList <LetterStyleViewModel>();
}
if (group.Count == 0)
{
return(NotFound());
}
return(Ok(group));
}
public IHttpActionResult GetAllCommonSizes()
{
IList <CommonSizeViewModel> commonsizes = null;
using (var ctx = new BikeShopEntities())
{
commonsizes = ctx.COMMONSIZES.Select(c => new CommonSizeViewModel()
{
MODELTYPE = c.MODELTYPE,
FRAMESIZE = c.FRAMESIZE
}).ToList <CommonSizeViewModel>();
}
if (commonsizes.Count == 0)
{
return(NotFound());
}
return(Ok(commonsizes));
}
public IHttpActionResult GetAllTempDateMade()
{
IList <TempDateMadeViewModel> datemade = null;
using (var ctx = new BikeShopEntities())
{
datemade = ctx.TEMPDATEMADEs.Select(t => new TempDateMadeViewModel()
{
DATEVALUE = t.DATEVALUE,
MADECOUNT = t.MADECOUNT
}).ToList <TempDateMadeViewModel>();
}
if (datemade.Count == 0)
{
return(NotFound());
}
return(Ok(datemade));
}
public IHttpActionResult GetAllBicycleTubeUsage()
{
IList <BicycleTubeUsageViewModel> bicycleTubeUsages = null;
using (var ctx = new BikeShopEntities())
{
bicycleTubeUsages = ctx.BICYCLETUBEUSAGEs.Select(btu => new BicycleTubeUsageViewModel()
{
SERIALNUMBER = btu.SERIALNUMBER,
TUBEID = btu.TUBEID,
QUANTITY = btu.QUANTITY
}).ToList <BicycleTubeUsageViewModel>();
}
if (bicycleTubeUsages.Count == 0)
{
return(NotFound());
}
return(Ok(bicycleTubeUsages));
}
public IHttpActionResult PostNewBicycleTubeUsage(BicycleTubeUsageViewModel btu)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new BikeShopEntities())
{
ctx.BICYCLETUBEUSAGEs.Add(new BICYCLETUBEUSAGE()
{
SERIALNUMBER = btu.SERIALNUMBER,
TUBEID = btu.TUBEID,
QUANTITY = btu.QUANTITY
});
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult GetAllModels()
{
IList <ModelTypeViewModel> modeltype = null;
using (var ctx = new BikeShopEntities())
{
modeltype = ctx.MODELTYPEs.Select(m => new ModelTypeViewModel()
{
MODELTYPE1 = m.MODELTYPE1,
DESCRIPTION = m.DESCRIPTION,
COMPONENTID = m.COMPONENTID
}).ToList <ModelTypeViewModel>();
}
if (modeltype.Count == 0)
{
return(NotFound());
}
return(Ok(modeltype));
}
public IHttpActionResult GetAllRevisionHistories()
{
IList<RevisionHistoryViewModel> revisionhistory = null;
using (var ctx = new BikeShopEntities())
{
revisionhistory = ctx.REVISIONHISTORies.Select(r => new RevisionHistoryViewModel()
{
ID = r.ID,
VERSION = r.VERSION,
CHANGEDATE = r.CHANGEDATE,
NAME = r.NAME,
REVISIONCOMMENTS = r.REVISIONCOMMENTS
}).ToList<RevisionHistoryViewModel>();
}
if (revisionhistory.Count == 0)
{
return NotFound();
}
return Ok(revisionhistory);
}
public IHttpActionResult GetBicycleTubeUsage(int id)
{
BicycleTubeUsageViewModel bicycleTubeUsage = null;
using (var ctx = new BikeShopEntities())
{
bicycleTubeUsage = ctx.BICYCLETUBEUSAGEs
.Where(btu => btu.SERIALNUMBER == id)
.Select(btu => new BicycleTubeUsageViewModel()
{
SERIALNUMBER = btu.SERIALNUMBER,
TUBEID = btu.TUBEID,
QUANTITY = btu.QUANTITY
}).FirstOrDefault <BicycleTubeUsageViewModel>();
}
if (bicycleTubeUsage == null)
{
return(NotFound());
}
return(Ok(bicycleTubeUsage));
}
