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