public static tblCommentUser ConvertTotblCommentUser(this CommentUsersModel data) { return(new tblCommentUser() { ID = Convert.ToInt64(data.id), CommentID = data.commentId, UserID = data.userId, IsRead = data.isRead ?? false, ReadBy = data.readBy, IsActive = data.isActive, IsDeleted = data.isDeleted, CreatedUserID = data.createdUserID, UpdatedUserID = data.updatedUserID, CreatedTimestamp = data.createdTimestamp ?? DateTime.Now, UpdatedTimestamp = data.updatedTimestamp ?? DateTime.Now }); }
internal static async Task <VacancyCreateModel> Insert(VacancyCreateModel model) { try { using (db = new eMSPEntities()) { tblVacancy vacancy = await Task.Run(() => InsertVacancy(model.Vacancy.ConvertTotblVacancy())); foreach (IndustrySkillsCreateModel a in model.VacancySkills) { await Task.Run(() => ManageVacancySkills.AddVacancySkills(a.id, vacancy)); } foreach (CompanyCreateModel a in model.VacancySuppliers) { await Task.Run(() => ManageVacancySuppliers.InsertVacancySupplier(a.id, vacancy)); } foreach (LocationCreateModel a in model.VacancyLocations) { await Task.Run(() => ManageVacancyLocations.AddVacancyLocation(a.locationId, vacancy)); } foreach (VacancyFileModel a in model.VacancyFiles) { await Task.Run(() => ManageVacancyFiles.InsertVacancyFiles(a.ConvertTotblVacancyFile(), vacancy)); } foreach (VacancyRequiredDocumentViewModel a in model.RequiredDocument.Where(x => x.IsSelected ?? false)) { await Task.Run(() => ManageVacancyRequiredDocuments.AddVacanciesRequiredDocument(a.ConvertTotblVacanciesRequiredDocument(), vacancy)); } 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.createdUserID = vacancy.CreatedUserID; c.createdTimestamp = vacancy.CreatedTimestamp; c.updatedUserID = vacancy.UpdatedUserID; c.updatedTimestamp = vacancy.UpdatedTimestamp; tblComment comment = await Task.Run(() => ManageComments.InsertComment(c.ConvertTotblComment())); tblVacancyComment vc = db.tblVacancyComments.Add(new tblVacancyComment { CommentID = comment.ID, VacancyID = vacancy.ID, IsActive = true, IsDeleted = false, CreatedTimestamp = vacancy.CreatedTimestamp, CreatedUserID = vacancy.CreatedUserID, UpdatedTimestamp = vacancy.UpdatedTimestamp, UpdatedUserID = vacancy.UpdatedUserID }); tblVacancyComment resVC = await Task.Run(() => ManageVacancyComments.CommentVacancy(vc)); CommentUsersModel commentUM = new CommentUsersModel { commentId = comment.ID, userId = vacancy.CreatedUserID, isActive = true, isDeleted = false, createdTimestamp = vacancy.CreatedTimestamp, createdUserID = vacancy.CreatedUserID, updatedTimestamp = vacancy.UpdatedTimestamp, updatedUserID = vacancy.UpdatedUserID }; tblCommentUser resCommentUser = await Task.Run(() => ManageComments.InsertCommentUser(commentUM.ConvertTotblCommentUser())); } } return(model); } } catch (Exception ex) { throw; } }