//Returns true if there was an errand of matching id that was updated. public bool UpdateErrand(Errand errand) { if (errand.ErrandID != 0) //cannot attempt to update an errand that isnt in the database { Errand dbErrand = context.Errands.FirstOrDefault(err => errand.ErrandID == err.ErrandID); if (dbErrand != null) { dbErrand.DateOfObservation = errand.DateOfObservation; dbErrand.DepartmentId = errand.DepartmentId; dbErrand.EmployeeId = errand.EmployeeId; dbErrand.InformerName = errand.InformerName; dbErrand.InformerPhone = errand.InformerPhone; dbErrand.InvestigatorAction = errand.InvestigatorAction; dbErrand.InvestigatorInfo = errand.InvestigatorInfo; dbErrand.Observation = errand.Observation; dbErrand.Place = errand.Place; dbErrand.RefNumber = errand.RefNumber; dbErrand.StatusId = errand.StatusId; dbErrand.TypeOfCrime = errand.TypeOfCrime; context.SaveChanges(); } return(true); } else { return(false); } }
public string SaveErrand(Errand errand) { if (errand.ErrandID == 0) //A new errand not yet added to the database { errand.RefNumber = CreateErrandRefNumber(); errand.StatusId = "S_A"; context.Errands.Add(errand); context.SaveChanges(); } else { UpdateErrand(errand); } return(errand.RefNumber); }
public async Task <CrimeContentErrandView> GetCrimeContentErrandView(int errandId) { Errand viewErrand = await GetErrand(errandId); var errandList = from err in Errands join stat in ErrandStatuses on err.StatusId equals stat.StatusId join dep in Departments on err.DepartmentId equals dep.DepartmentId into departmentErrand from deptE in departmentErrand.DefaultIfEmpty() join ee in Employees on err.EmployeeId equals ee.EmployeeId into employeeErrand from empE in employeeErrand.DefaultIfEmpty() orderby err.RefNumber ascending select new CrimeContentErrandView { DateOfObservation = err.DateOfObservation, ErrandId = err.ErrandID, RefNumber = err.RefNumber, TypeOfCrime = err.TypeOfCrime, StatusName = stat.StatusName, DepartmentName = (err.DepartmentId == null ? "ej tillsatt" : deptE.DepartmentName), EmployeeName = (err.EmployeeId == null ? "ej tillsatt" : empE.EmployeeName), Place = err.Place, Observation = err.Observation, InvestigatorInfo = err.InvestigatorInfo, InvestigatorAction = err.InvestigatorAction, InformerName = err.InformerName, InformerPhone = err.InformerPhone, Samples = err.Samples, Pictures = err.Pictures }; var actualErrand = from crimeContentErrandView in errandList where crimeContentErrandView.ErrandId.Equals(viewErrand.ErrandID) select crimeContentErrandView; return(actualErrand.FirstOrDefault()); }