internal static async Task UpdateCandidateTimesheet(tblCandidateTimesheet model) { try { using (db = new eMSPEntities()) { var existingParent = db.tblCandidateTimesheets .Where(p => p.ID == model.ID) .Include(p => p.tblCandidateTimesheetHours) .SingleOrDefault(); if (existingParent != null) { db.Entry(existingParent).CurrentValues.SetValues(model); foreach (var existingChild in existingParent.tblCandidateTimesheetHours.ToList()) { if (!model.tblCandidateTimesheetHours.Any(c => c.ID == existingChild.ID)) { db.tblCandidateTimesheetHours.Remove(existingChild); } } foreach (var childModel in model.tblCandidateTimesheetHours) { var existingChild = existingParent.tblCandidateTimesheetHours .Where(c => c.ID == childModel.ID) .SingleOrDefault(); if (existingChild != null) { db.Entry(existingChild).CurrentValues.SetValues(childModel); } else { existingParent.tblCandidateTimesheetHours.Add(childModel); } } int x = await Task.Run(() => db.SaveChangesAsync()); } else { await Task.Run(() => InsertCandidateTimesheet(model)); } } } catch (Exception) { throw; } }
internal static async Task <tblVacancyLocation> UpdateVacancyLocation(long a, tblVacancy vacancy) { try { using (db = new eMSPEntities()) { tblVacancyLocation model = await Task.Run(() => db.tblVacancyLocations.Where(b => b.VacancyID == vacancy.ID && b.LocationID == a).FirstOrDefaultAsync()); if (model != null) { db.Entry(model).State = EntityState.Modified; int x = await Task.Run(() => db.SaveChangesAsync()); } else { model = await Task.Run(() => AddVacancyLocation(a, vacancy)); } return(model); } } catch (Exception) { throw; } }
internal static async Task UpdateCandidateTimesheetCategoriesHours(tblCandidateTimesheetCategoriesHour model) { try { using (db = new eMSPEntities()) { db.Entry(model).State = EntityState.Modified; int x = await Task.Run(() => db.SaveChangesAsync()); } } catch (Exception) { throw; } }
internal static async Task <tblMSPSpendCategory> UpdateMSPSpendCategory(tblMSPSpendCategory model) { try { using (db = new eMSPEntities()) { db.Entry(model).State = EntityState.Modified; int x = await Task.Run(() => db.SaveChangesAsync()); return(model); } } catch (Exception) { throw; } }
internal static async Task <tblSupplierUser> ToggleUser(tblSupplierUser model) { try { using (db = new eMSPEntities()) { db.Entry(model).State = EntityState.Modified; int x = await Task.Run(() => db.SaveChangesAsync()); return(model); } } catch (Exception) { throw; } }
internal static async Task <tblVacancyFile> UpdateVacancyFile(tblVacancyFile model, tblVacancy vacancy) { try { using (db = new eMSPEntities()) { db.Entry(model).State = EntityState.Modified; int x = await Task.Run(() => db.SaveChangesAsync()); return(model); } } catch (Exception) { throw; } }
internal static async Task <CandidateSubmissionModel> UpdateCandidateSubmissions(tblCandidateSubmission model) { try { using (db = new eMSPEntities()) { db.Entry(model).State = EntityState.Modified; int x = await Task.Run(() => db.SaveChangesAsync()); return(model.ConvertToCandidateSubmissionModel()); } } catch (Exception ex) { throw; } }
internal static async Task UpdateCandidateFiles(tblCandidateFile model) { try { using (db = new eMSPEntities()) { db.Entry(model).State = EntityState.Modified; int x = await Task.Run(() => db.SaveChangesAsync()); //return model; } } catch (Exception) { throw; } }
internal static async Task <tblCustomerLocationBranch> UpdateCustomerLocationBranch(tblCustomerLocationBranch model) { try { using (db = new eMSPEntities()) { db.Entry(model).State = EntityState.Modified; int x = await Task.Run(() => db.SaveChangesAsync()); return(model); } } catch (Exception) { throw; } }
internal static async Task <tblCandidatePlacement> UpdateCandidatePlacement(tblCandidatePlacement model) { try { using (db = new eMSPEntities()) { db.Entry(model).State = EntityState.Modified; int x = await Task.Run(() => db.SaveChangesAsync()); return(model); } } catch (Exception) { throw; } }