public SaveCode Save(SaveCode saveCode) { saveCode.dateCode = DateTime.Now; saveCode.driverId = Database.Session.QueryOver <Driver>().Where(x => x.driverId == saveCode.driverId.driverId && x.state == true).SingleOrDefault(); Database.Session.Save(saveCode); return(saveCode); }
public SaveCode GetCode(SaveCode saveCode) { Driver driver = Database.Session.QueryOver <Driver>().Where(x => x.driverId == saveCode.driverId.driverId).SingleOrDefault(); saveCode = Database.Session.QueryOver <SaveCode>().Where(x => x.driverId.driverId == driver.driverId).OrderBy(x => x.codeId).Desc.List().FirstOrDefault(); return(saveCode); }
public DriverPoints DriverPointSave(DriverPoints driverpoint) { Driver driver = new Driver(); driver = Database.Session.QueryOver <Driver>().Where(x => x.tc == driverpoint.DriverPoint.driverId.tc && x.state == true).SingleOrDefault(); SaveCode savecode = Database.Session.QueryOver <SaveCode>().Where(x => x.driverId.driverId == driver.driverId).OrderBy(x => x.codeId).Desc.List().FirstOrDefault(); if (driverpoint.Code == savecode.code) { if (driver.driverId != 0) { driverpoint.DriverPoint.createdAt = DateTime.Now; driverpoint.DriverPoint.pointTime = DateTime.Now; driverpoint.DriverPoint.state = true; driverpoint.DriverPoint.driverId = driver; Database.Session.Save(driverpoint.DriverPoint); return(driverpoint); } else { return(null); } } return(null); }