public bool UpdateJobIndustryArea(JobIndustryAreaModel jobIndustry)
{
using (var connection = new SqlConnection(connectionString))
{
try
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@JobIndustryAreaId", jobIndustry.JobIndustryAreaId),
new SqlParameter("@JobIndustryAreaName", jobIndustry.JobIndustryAreaName),
};
var data =
SqlHelper.ExecuteNonQuery
(
connection,
CommandType.StoredProcedure,
"usp_UpdateJobIndustryArea",
parameters
);
if (data > 0)
{
return(true);
}
}
finally
{
SqlHelper.CloseConnection(connection);
}
}
throw new Exception("Unable to update data");
}
public bool UpdateJobIndustryArea(JobIndustryAreaViewModel jobIndustryAreaViewModel)
{
JobIndustryAreaModel jobIndustryArea = new JobIndustryAreaModel
{
JobIndustryAreaId = jobIndustryAreaViewModel.JobIndustryAreaId,
JobIndustryAreaName = jobIndustryAreaViewModel.JobIndustryAreaName,
};
var result = _jobIndustryAreaHandler.UpdateJobIndustryArea(jobIndustryArea);
if (result)
{
return(true);
}
throw new Exception("Unable to update data");
}
public List <JobIndustryAreaModel> JobIndustryArea()
{
DataTable dt = masterRepository.JobIndustryArea();
List <JobIndustryAreaModel> jobIndustryArea = new List <JobIndustryAreaModel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
JobIndustryAreaModel JobIndustry = new JobIndustryAreaModel()
{
JobIndustryAreaId = Convert.ToInt32(dt.Rows[i]["JobIndustryAreaId"]),
JobIndustryAreaName = Convert.ToString(dt.Rows[i]["JobIndustryAreaName"]),
};
jobIndustryArea.Add(JobIndustry);
}
return(jobIndustryArea);
}
