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