public static VendorLocationModel GetVendorLocation(int id) { try { if (id != 0) { using (RoundTheCornerEntities rc = new RoundTheCornerEntities()) { var tblVendorLocation = rc.TblVendorLocations.FirstOrDefault(v => v.VendorID == id); if (tblVendorLocation != null) { VendorLocationModel vendorLocation = new VendorLocationModel { VendorID = tblVendorLocation.VendorID, LocationX = tblVendorLocation.LocationX, LocationY = tblVendorLocation.LocationY, Date = (DateTime)tblVendorLocation.Datetime }; return(vendorLocation); } throw new Exception("Vendor location cannot be found"); } } else { throw new Exception("ID cannot be 0"); } } catch (Exception ex) { throw ex; } }
public static bool Seed() { VendorLocationModel vendorLocation = new VendorLocationModel { VendorID = 1, LocationX = 100, LocationY = 200, Date = new DateTime(1950, 12, 31), }; return(Insert(vendorLocation)); }
public void Update() { VendorLocationModel vendorLocation = new VendorLocationModel { VendorID = 2, LocationX = 111, LocationY = 222, Date = new DateTime(1950, 12, 31) }; VendorLocationManager.Update(vendorLocation); VendorLocationModel newVendorLocation = VendorLocationManager.GetVendorLocation(2); Assert.AreEqual(vendorLocation.VendorID, newVendorLocation.VendorID); }
public static bool Insert(VendorLocationModel vendorLocation) { try { using (RoundTheCornerEntities rc = new RoundTheCornerEntities()) { PL.TblVendorLocation newRow = new TblVendorLocation() { VendorID = rc.TblVendorLocations.Any() ? rc.TblVendorLocations.Max(v => v.VendorID) + 1 : 1, LocationX = vendorLocation.LocationX, LocationY = vendorLocation.LocationY, Datetime = vendorLocation.Date }; rc.TblVendorLocations.Add(newRow); rc.SaveChanges(); return(true); } } catch (Exception ex) { throw ex; } }
public static bool Update(VendorLocationModel vendorLocation) { try { if (vendorLocation.VendorID != 0) { using (RoundTheCornerEntities rc = new RoundTheCornerEntities()) { TblVendorLocation tblVendorLocation = rc.TblVendorLocations.FirstOrDefault(v => v.VendorID == vendorLocation.VendorID); if (tblVendorLocation != null) { tblVendorLocation.VendorID = vendorLocation.VendorID; tblVendorLocation.LocationX = vendorLocation.LocationX; tblVendorLocation.LocationY = vendorLocation.LocationY; tblVendorLocation.Datetime = vendorLocation.Date; rc.SaveChanges(); return(true); } else { throw new Exception("Vendor was not found"); } } } else { throw new Exception("Must have a valid id"); } } catch (Exception ex) { throw ex; } }