private static void UpdateMedical(DSModel db, KeyBinder key, DriverMedicalModel model) { var poco = db.DriversMedicals .Where(m => m.DriverMedicalID == model.DriverMedicalID) .FirstOrDefault(); model.Map(poco); db.FlushChanges(); SaveReminders(db, key, model, poco); }
private static void InsertMedical(DSModel db, KeyBinder key, DriverMedicalModel model) { DriversMedical poco = new DriversMedical(); model.Map(poco); db.Add(poco); key.AddKey(poco, model, model.GetName(p => p.DriverMedicalID)); db.FlushChanges(); SaveReminders(db, key, model, poco); }
private static void InsertDriverLicense(DSModel db, KeyBinder key, DriverLicenseModel model) { var poco = new DriversLicense(); model.Map(poco); db.Add(poco); key.AddKey(poco, model, model.GetName(p => p.DriverLicenseID)); db.FlushChanges(); SaveDriverLicensePermits(db, key, poco, model); SaveDriverLicenseReminders(db, key, poco, model); }
public static void Log(DSModel db, LogType type, string location, string message) { DriverSolutions.DAL.Log log = new Log(); try { log.LogType = (byte)type; log.LogLocation = location; log.LogMessage = message; db.Add(log); db.FlushChanges(); } catch (Exception ex) { try { File.AppendAllText("error.log", log.ToMessage()); } catch { } } }
public static void Log(DSModel db, Exception ex, string location = "") { Logger.Log(db, LogType.Error, (location == "" ? "Error" : location), ex.ToString()); db.FlushChanges(); }
private static void UpdateDriver(DSModel db, KeyBinder key, DriverModel model) { var poco = db.Drivers.Where(d => d.DriverID == model.DriverID).FirstOrDefault(); if (poco == null) throw new ArgumentException("No driver with this ID!"); poco.DriverCode = model.DriverCode; poco.FirstName = model.FirstName; poco.SecondName = model.SecondName; poco.LastName = model.LastName; poco.DateOfBirth = model.DateOfBirth; poco.DateOfHire = model.DateOfHire; poco.CellPhone = model.CellPhone; poco.EmergencyPhone = model.EmergencyPhone; poco.Email = model.Email; poco.PayRateOverride = model.PayRateOverride; poco.IsEnabled = model.IsEnabled; foreach (var l in poco.LocationsDrivers.ToList()) { db.Delete(l); poco.LocationsDrivers.Remove(l); } db.FlushChanges(); foreach (var l in model.Locations) { poco.LocationsDrivers.Add( new LocationsDriver() { LocationID = l.LocationID, DriverID = l.DriverID, TravelPay = l.TravelPay }); } }
private static void UpdateDriverLicense(DSModel db, KeyBinder key, DriverLicenseModel model) { var poco = db.DriversLicenses.Where(d => d.DriverLicenseID == model.DriverLicenseID).FirstOrDefault(); if (poco == null) throw new ArgumentNullException("poco"); model.Map(poco); db.FlushChanges(); SaveDriverLicensePermits(db, key, poco, model); SaveDriverLicenseReminders(db, key, poco, model); }