internal static async Task <tblVacanciesQuestion> AddVacanciesQuestions(tblVacanciesQuestion data, tblVacancy vacancy)
{
try
{
using (db = new eMSPEntities())
{
tblVacanciesQuestion model = db.tblVacanciesQuestions.Add(new tblVacanciesQuestion
{
VacancyID = vacancy.ID,
QuestionID = data.ID,
QuestionName = data.QuestionName,
QuestionDescription = data.QuestionDescription,
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 async Task <VacancyQuestionViewModel> Save(VacancyQuestionViewModel data)
{
try
{
using (var db = mContext)
{
var obj = new tblVacanciesQuestion()
{
QuestionName = data.QuestionName,
QuestionDescription = data.QuestionDescription,
VacancyID = data.VacancyID,
IsActive = data.isActive,
IsMandatory = data.IsMandatory,
IsDeleted = data.isDeleted,
CreatedTimestamp = DateTime.UtcNow,
CreatedUserID = data.createdUserID
};
db.tblVacanciesQuestions.Add(obj);
await db.SaveChangesAsync();
return(new VacancyQuestionViewModel
{
ID = obj.ID,
QuestionName = obj.QuestionName,
QuestionDescription = obj.QuestionDescription,
VacancyID = obj.VacancyID,
IsMandatory = obj.IsMandatory,
isActive = obj.IsActive,
isDeleted = obj.IsDeleted,
createdTimestamp = obj.CreatedTimestamp
});
}
}
catch (Exception)
{
throw;
}
}
public static VacancyQuestionViewModel ConvertToVacancyQuestion(this tblVacanciesQuestion data)
{
return(new VacancyQuestionViewModel()
{
ID = data.ID,
VacancyID = data.VacancyID,
QuestionID = data.QuestionID,
IsMandatory = data.IsMandatory,
QuestionName = data.QuestionName,
QuestionDescription = data.QuestionDescription,
IsSelected = false,
isActive = data.IsActive,
isDeleted = data.IsDeleted,
createdUserID = data.CreatedUserID,
updatedUserID = data.UpdatedUserID,
createdTimestamp = data.CreatedTimestamp,
updatedTimestamp = data.UpdatedTimestamp,
CandidateSubmissionsQuestionsResponse = data.tblCandidateSubmissionsQuestionsResponses?
.Select(x => x.ConvertToCandidateSubmissionsQuestionsResponseModel())
.ToList()
});
}