internal static async Task <tblVacancyLocation> AddVacancyLocation(long a, tblVacancy vacancy) { try { using (db = new eMSPEntities()) { tblVacancyLocation model = new tblVacancyLocation(); model = db.tblVacancyLocations.Add(new tblVacancyLocation { VacancyID = vacancy.ID, LocationID = a, 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 VacancyModel ConvertToVacancy(this tblVacancy data) { return(new VacancyModel() { id = data.ID, vacancyType = data.VacancyType, customerId = data.CustomerID, customerName = data.tblCustomer.Name, vacancyTypeName = data.tblMSPVacancieType.Name, startDate = data.StartDate, endDate = data.EndDate, submissionDueDate = data.SubmissionDueDate, hiringManager = data.HiringManager, reportingManager = data.ReportingManager, positionTitle = data.PositionTitle, noOfPositions = data.NoOfPositions, vacancyDescription = data.VacancyDescription, yearOfExperience = Convert.ToDecimal(data.YearOfExperience), showCustomerDetailsToSupplier = data.ShowCustomerDetailsToSupplier, minPayRate = data.MinPayRate, maxPayRate = data.MaxPayRate, targetPayRate = data.TargetPayRate, payRateMarkUp = data.PayRateMarkUp, isActive = data.IsActive, isDeleted = data.IsDeleted, createdUserID = data.CreatedUserID, updatedUserID = data.UpdatedUserID, createdTimestamp = data.CreatedTimestamp, updatedTimestamp = data.UpdatedTimestamp, jobStatusId = data.tblJobVacanciesStatu.ID.ToString(), vacancyStatus = data.tblJobVacanciesStatu?.ConvertToVacanciesStatus() }); }
internal static async Task <tblVacancieSkill> UpdateVacancySkills(long a, tblVacancy vacancy) { try { using (db = new eMSPEntities()) { tblVacancieSkill model = await Task.Run(() => db.tblVacancieSkills.Where(b => b.VacancyID == vacancy.ID && b.SkillID == a).FirstOrDefaultAsync()); if (model != null) { db.Entry(model).State = EntityState.Modified; int x = await Task.Run(() => db.SaveChangesAsync()); } else { model = await Task.Run(() => AddVacancySkills(a, vacancy)); } return(model); } } catch (Exception) { throw; } }
public async Task <VacancyCreateModel> GetVacancy(long Id) { try { VacancyCreateModel model = null; tblVacancy data = await Task.Run(() => ManageVacancy.GetVacancyDetails(Id)); model = data.ConvertToVacancyCreateModel(); return(model); } catch (Exception) { throw; } }
public async Task <List <CommentModel> > GetVacancyComments(long id) { try { List <CommentModel> data = null; tblVacancy res = await Task.Run(() => ManageVacancy.GetVacancyComments(id)); data = res.tblVacancyComments?.Select(a => a.tblComment?.ConvertToComment()).ToList(); return(data); } catch (Exception ex) { throw; } }
public tblVacancy Addvac(string vacname, string cityname, int posid, int depid, string qualification, int joblevel, int marks, string test) { var vac = new tblVacancy() { VacancyName = vacname, CityName = cityname, PositionId = posid, DepartmentId = depid, RequiredQualification = qualification, JobLevel = Convert.ToInt32(joblevel), CreationDate = DateTime.Now, MarksCriteria = marks, Testpaper = test, }; return(vac); }
internal static async Task DeleteVacancy(long Id) { try { using (db = new eMSPEntities()) { tblVacancy obj = await db.tblVacancies.FindAsync(Id); db.tblVacancies.Remove(obj); int x = await Task.Run(() => db.SaveChangesAsync()); } } catch (Exception) { throw; } }
internal static async Task <tblVacancy> UpdateVacancy(tblVacancy 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 <tblVacancy> InsertVacancy(tblVacancy model) { try { using (db = new eMSPEntities()) { model = db.tblVacancies.Add(model); int x = await Task.Run(() => db.SaveChangesAsync()); return(model); } } catch (Exception ex) { throw; } }
public static VacancyCreateModel ConvertToVacancyCreateModel(this tblVacancy data) { return(new VacancyCreateModel() { Vacancy = new VacancyModel() { id = data.ID, customerId = data.CustomerID, customerName = data.tblCustomer != null ? data.tblCustomer.Name : "", vacancyType = data.VacancyType, vacancyTypeName = data.tblMSPVacancieType != null ? data.tblMSPVacancieType.Name : "", startDate = data.StartDate, endDate = data.EndDate, submissionDueDate = data.SubmissionDueDate, hiringManager = data.HiringManager, reportingManager = data.ReportingManager, positionTitle = data.PositionTitle, noOfPositions = data.NoOfPositions, vacancyDescription = data.VacancyDescription, yearOfExperience = Convert.ToDecimal(data.YearOfExperience), showCustomerDetailsToSupplier = data.ShowCustomerDetailsToSupplier, minPayRate = data.MinPayRate, maxPayRate = data.MaxPayRate, targetPayRate = data.TargetPayRate, payRateMarkUp = data.PayRateMarkUp, isActive = data.IsActive, isDeleted = data.IsDeleted, createdTimestamp = data.CreatedTimestamp, createdUserID = data.CreatedUserID, updatedTimestamp = data.UpdatedTimestamp, updatedUserID = data.UpdatedUserID, jobStatusId = data.JobStatusID.ToString(), vacancyStatus = data.tblJobVacanciesStatu?.ConvertToVacanciesStatus() }, VacancyFiles = data.tblVacancyFiles?.Select(a => a.ConvertToVacancyFile()).ToList(), //VacancyComment = data.tblVacancyComments?.Select(a => a.tblComment?.ConvertToComment()).ToList(), VacancySkills = data.tblVacancieSkills?.Select(a => a.tblIndustrySkill?.ConvertToIndustrySkill()).ToList(), VacancyLocations = data.tblVacancyLocations?.Select(a => a.tblLocation.ConvertToLocation()).ToList(), VacancySuppliers = data.tblVacancySuppliers?.Where(x => !(x.IsDeleted ?? false)).Select(a => a.tblSupplier?.ConvertTocompany()).ToList(), Questions = data.tblVacanciesQuestions?.Select(a => a.ConvertToVacancyQuestion()).ToList(), RequiredDocument = data.tblVacanciesRequiredDocuments?.Select(a => a.ConvertToVacancyRequiredDocument()).ToList() }); }
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; } }
internal static async Task <tblVacancyFile> InsertVacancyFiles(tblVacancyFile model, tblVacancy vacancy) { try { using (db = new eMSPEntities()) { model = db.tblVacancyFiles.Add(new tblVacancyFile { VacancyID = vacancy.ID, FilePath = model.FilePath, FileName = model.FileName, 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; } }
internal static async Task <tblVacanciesRequiredDocument> AddVacanciesRequiredDocument(tblVacanciesRequiredDocument data, tblVacancy vacancy) { try { using (db = new eMSPEntities()) { tblVacanciesRequiredDocument model = db.tblVacanciesRequiredDocuments.Add(new tblVacanciesRequiredDocument { VacancyID = vacancy.ID, RequiredDocumentID = data.ID, RequiredDocumentName = data.RequiredDocumentName, RequiredDocumentDescription = data.RequiredDocumentDescription, IsMandatory = data.IsMandatory, 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 void Addvacant(tblVacancy obj) { context.tblVacancies.Add(obj); }
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; } }
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; } }