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;
}
}
