internal static async Task <tblVacancySupplier> InsertVacancySupplier(string a, tblVacancy vacancy) { try { using (db = new eMSPEntities()) { tblVacancySupplier model = new tblVacancySupplier(); model = db.tblVacancySuppliers.Add(new tblVacancySupplier { VacancyID = vacancy.ID, SupplierID = Convert.ToInt16(a), IsReleased = true, IsActive = true, IsDeleted = false, CreatedTimestamp = vacancy.CreatedTimestamp, CreatedUserID = vacancy.CreatedUserID, UpdatedTimestamp = vacancy.UpdatedTimestamp, UpdatedUserID = vacancy.UpdatedUserID }); int x = await Task.Run(() => db.SaveChangesAsync()); return(model); } } catch (Exception ex) { throw; } }
public static VacancySupplierModel ConvertToVacancySupplier(this tblVacancySupplier data) { return(new VacancySupplierModel() { id = data.ID, vacancyId = data.VacancyID, supplierId = data.SupplierID, supplierName = data.tblSupplier != null ? data.tblSupplier.Name : "", isReleased = data.IsReleased, isActive = data.IsActive, isDeleted = data.IsDeleted, createdUserID = data.CreatedUserID, updatedUserID = data.UpdatedUserID, createdTimestamp = data.CreatedTimestamp, updatedTimestamp = data.UpdatedTimestamp }); }
internal static async Task <VacancyCreateModel> Update(VacancyCreateModel model) { try { using (db = new eMSPEntities()) { tblVacancy vacancy = await Task.Run(() => UpdateVacancy(model.Vacancy.ConvertTotblVacancy())); await Task.Run(() => ManageVacancySkills.DeleteVacancySkills(vacancy.ID)); foreach (IndustrySkillsCreateModel a in model.VacancySkills) { tblVacancieSkill vacancySkill = await Task.Run(() => ManageVacancySkills.AddVacancySkills(a.id, vacancy)); } await Task.Run(() => ManageVacancySuppliers.UpdateVacancySupplier(vacancy.ID)); foreach (CompanyCreateModel a in model.VacancySuppliers) { tblVacancySupplier vacancySupplier = await Task.Run(() => ManageVacancySuppliers.InsertVacancySupplier(a.id, vacancy)); } await Task.Run(() => ManageVacancyLocations.DeleteVacancyLocation(vacancy.ID)); foreach (LocationCreateModel a in model.VacancyLocations) { tblVacancyLocation vacancyLocation = await Task.Run(() => ManageVacancyLocations.AddVacancyLocation(a.locationId, vacancy)); } await Task.Run(() => ManageVacancyFiles.DeleteVacancyFile(vacancy.ID)); foreach (VacancyFileModel a in model.VacancyFiles) { tblVacancyFile vacancyFile = await Task.Run(() => ManageVacancyFiles.InsertVacancyFiles(a.ConvertTotblVacancyFile(), vacancy)); } await Task.Run(() => ManageVacancyRequiredDocuments.DeleteVacanciesRequiredDocument(vacancy.ID)); foreach (VacancyRequiredDocumentViewModel a in model.RequiredDocument.Where(x => x.IsSelected ?? false)) { await Task.Run(() => ManageVacancyRequiredDocuments.AddVacanciesRequiredDocument(a.ConvertTotblVacanciesRequiredDocument(), vacancy)); } await Task.Run(() => ManageVacancyQuestions.DeleteVacancySkills(vacancy.ID)); foreach (VacancyQuestionViewModel a in model.Questions.Where(x => x.IsSelected ?? false)) { await Task.Run(() => ManageVacancyQuestions.AddVacanciesQuestions(a.ConvertTotblVacanciesQuestion(), vacancy)); } //Comments foreach (CommentModel c in model.VacancyComment) { if (!string.IsNullOrEmpty(c.comment)) { c.updatedUserID = vacancy.UpdatedUserID; c.updatedTimestamp = vacancy.UpdatedTimestamp; tblComment comment = await Task.Run(() => ManageComments.UpdateComment(c.ConvertTotblComment())); } } return(model); } } catch (Exception ex) { throw; } }