public bool SaveDetailToAudit(BulkJobPostSummaryDetail detail)
{
using (var connection = new SqlConnection(connectionString))
{
try
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@CompanyName", detail.CompanyName),
new SqlParameter("@CreatedBy", detail.CreatedBy),
new SqlParameter("@CTC", detail.CTC),
new SqlParameter("@ErrorDetails", detail.ErrorDetails),
new SqlParameter("@FileName", detail.FileName),
//new SqlParameter("@FinancialYear",detail.FinancialYear),
new SqlParameter("@HiringCriteria", detail.HiringCriteria),
new SqlParameter("@JobDetails", detail.JobDetails),
new SqlParameter("@JobLocation", detail.JobLocation),
//new SqlParameter("@JobRole1",detail.JobRole1),
//new SqlParameter("@JobRole2",detail.JobRole2),
//new SqlParameter("@JobRole3",detail.JobRole3),
new SqlParameter("@JobTitle", detail.JobTitle),
new SqlParameter("@JobType", detail.JobType),
new SqlParameter("@MaxExp", detail.MaxExp),
new SqlParameter("@MinExp", detail.MinExp),
new SqlParameter("@ProcessedBy", detail.ProcessedBy),
new SqlParameter("@ProcessedOn", detail.ProcessedOn),
//new SqlParameter("@Quarter1",detail.Quarter1),
//new SqlParameter("@Quarter2",detail.Quarter2),
//new SqlParameter("@Quarter3",detail.Quarter3),
//new SqlParameter("@Quarter4",detail.Quarter4),
new SqlParameter("@SerialNo", detail.SerialNo),
new SqlParameter("@SPOC", detail.SPOC),
new SqlParameter("@SPOCContact", detail.SPOCContact),
new SqlParameter("@SPOCEmail", detail.SPOCEmail),
new SqlParameter("@State", detail.State),
new SqlParameter("@Status", detail.Status),
new SqlParameter("@Total", detail.Total)
};
var result =
SqlHelper.ExecuteNonQuery
(
connection,
CommandType.StoredProcedure,
"usp_InsertBulkJobPostSummaryDetail",
parameters
);
if (result > 0)
{
return(true);
}
}
finally
{
SqlHelper.CloseConnection(connection);
}
}
return(false);
}
private void SaveDetailToAudit(BulkJobPostSummaryDetailViewModel detail, string fileName, int userId)
{
try
{
var dModel = new BulkJobPostSummaryDetail
{
CompanyName = detail.CompanyName,
CreatedBy = userId,
CTC = detail.CTC,
ErrorDetails = detail.ErrorDetails,
FileName = fileName,
//FinancialYear = detail.FinancialYear,
HiringCriteria = detail.HiringCriteria,
JobDetails = detail.JobDetails,
JobLocation = detail.CityCode,
//JobRole1 = detail.JobRole1,
//JobRole2 = detail.JobRole2,
//JobRole3 = detail.JobRole3,
JobTitle = detail.JobTitleByEmployer,
JobType = detail.JobType,
MaxExp = detail.MaxExp,
MinExp = detail.MinExp,
ProcessedBy = detail.ProcessedBy,
ProcessedOn = detail.ProcessedOn,
//Quarter1 = detail.Quarter1,
//Quarter2 = detail.Quarter2,
//Quarter3 = detail.Quarter3,
//Quarter4 = detail.Quarter4,
SerialNo = detail.SequenceNo,
SPOC = detail.SPOC,
SPOCContact = detail.SPOCContact,
SPOCEmail = detail.SPOCEmail,
State = detail.StateCode,
Status = detail.Status,
Total = detail.Total
};
bjpProcessor.SaveDetailToAudit(dModel);
}
catch (Exception ex)
{
string errMessage = $"<li>Unable to insert job summary due to: {ex.Message}.</li>";
detail.ErrorDetails += errMessage;
}
}
