public int Add(JobAddRequest request, int userId)
{
string procName = "[dbo].[Jobs_Insert_V2]";
int id = 0;
_data.ExecuteNonQuery(
procName,
delegate(SqlParameterCollection inputCollection)
{
JobAddInputs(request, inputCollection);
inputCollection.AddWithValue("@CreatedBy", userId);
SqlParameter outputId = new SqlParameter("@Id", SqlDbType.Int);
outputId.Direction = ParameterDirection.Output;
inputCollection.Add(outputId);
},
delegate(SqlParameterCollection returnCollection)
{
object outputOfId = returnCollection["@Id"].Value;
int.TryParse(outputOfId.ToString(), out id);
}
);
return(id);
}
public int Insert(JobAddRequest model)
{
int JobKey = 0;
int CategoryKey = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Job_Insert", inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@CategoryKey", CategoryKey);
paramCollection.AddWithValue("@CategoryName", model.CategoryName);
paramCollection.AddWithValue("@ProductionName", model.ProductionName);
paramCollection.AddWithValue("@JobDescription", model.JobDescription);
paramCollection.AddWithValue("@ProductionDate", model.ProductionDate);
paramCollection.AddWithValue("@CallTime", model.CallTime);
paramCollection.AddWithValue("@TimeCommitment", model.TimeCommitment);
paramCollection.AddWithValue("@Notes", model.Notes);
SqlParameter p = new SqlParameter("@JobKey", System.Data.SqlDbType.Int);
p.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(p);
}, returnParameters : delegate(SqlParameterCollection param)
{
int.TryParse(param["@JobKey"].Value.ToString(), out JobKey);
}
);
return(JobKey);
}
public HttpResponseMessage CreateJob(JobAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
int id = _jobService.Insert(model);
ItemResponse <int> response = new ItemResponse <int>();
response.Item = id;
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
private static void CommonParams(JobAddRequest model, SqlParameterCollection col)
{
col.AddWithValue("@OrganizationId", model.OrganizationId);
col.AddWithValue("@JobTypeId", model.JobTypeId);
col.AddWithValue("@LocationId", model.LocationId);
col.AddWithValue("@Title", model.Title);
col.AddWithValue("@Description", model.Description);
col.AddWithValue("@Requirements", model.Requirements);
col.AddWithValue("@IsActive", model.IsActive);
col.AddWithValue("@ContactName", model.ContactName);
col.AddWithValue("@ContactPhone", model.ContactPhone);
col.AddWithValue("@ContactEmail", model.ContactEmail);
}
public int Add(JobAddRequest model, int createdBy)
{
string procName = "[dbo].[Openings_Insert]";
int Id = 0;
_data.ExecuteNonQuery(procName,
inputParamMapper : delegate(SqlParameterCollection col)
{
CommonParams(model, col);
col.AddWithValue("@CreatedBy", createdBy);
SqlParameter idOutput = new SqlParameter("@Id", SqlDbType.Int);
idOutput.Direction = ParameterDirection.Output;
col.Add(idOutput);
},
returnParameters : delegate(SqlParameterCollection returnCol)
{
object oId = returnCol["@Id"].Value;
int.TryParse(oId.ToString(), out Id);
});
return(Id);
}
private static void JobAddInputs(JobAddRequest request, SqlParameterCollection inputCollection)
{
inputCollection.AddWithValue("@JobTypeId", request.JobTypeId);
inputCollection.AddWithValue("@LocationId", request.locationId);
inputCollection.AddWithValue("@Title", request.Title);
inputCollection.AddWithValue("@Description", request.Description);
inputCollection.AddWithValue("@Requirements", request.Requirements);
inputCollection.AddWithValue("@IsActive", request.IsActive);
//Location
if (request.locationId > 0)
{
request.Location = new LocationAddRequest();
}
inputCollection.AddWithValue("@LocationTypeId", request.Location.LocationTypeId);
inputCollection.AddWithValue("@LineOne", request.Location.LineOne);
inputCollection.AddWithValue("@LineTwo", request.Location.LineTwo);
inputCollection.AddWithValue("@City", request.Location.City);
inputCollection.AddWithValue("@Zip", request.Location.Zip);
inputCollection.AddWithValue("@StateId", request.Location.StateId);
inputCollection.AddWithValue("@Latitude", request.Location.Latitude);
inputCollection.AddWithValue("@Longitude", request.Location.Longitude);
}
public ActionResult <ItemResponse <int> > Create(JobAddRequest model)
{
int userId = _authService.GetCurrentUserId();
int code = 200;
BaseResponse response = null;
try
{
int id = _service.Add(model, userId);
response = new ItemResponse <int> {
Item = id
};
}
catch (Exception ex)
{
code = 500;
response = new ErrorResponse($"Exeption: {ex.Message}");
}
return(StatusCode(code, response));
}
public ActionResult <ItemResponse <int> > Create(JobAddRequest model)
{
ObjectResult result = null;
try
{
int userId = _authService.GetCurrentUserId();
int id = _service.Add(model, userId);
ItemResponse <int> response = new ItemResponse <int> {
Item = id
};
result = Created201(response);
}
catch (Exception exception)
{
base.Logger.LogError(exception.ToString());
ErrorResponse response = new ErrorResponse(exception.Message);
result = StatusCode(500, response);
}
return(result);
}
public ActionResult CreateJob(JobAddRequest pJobAddRequest)
{
try
{
string deToken = this.GetToken();
// Validate User by Token
Company company = this.GetCompany(deToken);
if (company == null)
{
this.APIResponse = APIResponseFactory.Create(System.Net.HttpStatusCode.Unauthorized);
return(Unauthorized(this.APIResponse));
}
// Validate Request
this.APIResponse = APIResponseFactory.Create(System.Net.HttpStatusCode.BadRequest);
if (string.IsNullOrEmpty(pJobAddRequest.DeTitle))
{
this.APIResponse.AddError("DeTitle", ValidationMessageConstant.RequiredField);
}
if (string.IsNullOrEmpty(pJobAddRequest.DeDescription))
{
this.APIResponse.AddError("DeDescription", ValidationMessageConstant.RequiredField);
}
if (pJobAddRequest.IdRole <= 0)
{
this.APIResponse.AddError("IdRole", ValidationMessageConstant.RequiredField);
}
else
{
Role role = ((IBaseRepository <Role>)RepositorySingleton.instance.RoleRepository).Get(pJobAddRequest.IdRole);
if (role == null)
{
this.APIResponse.AddError("IdRole", ValidationMessageConstant.InvalidValue);
}
}
if (this.APIResponse.Errors.Count() > 0)
{
return(BadRequest(this.APIResponse));
}
// Create New Job
Job job = new Job {
IdCompany = company.IdUser,
DtRegister = DateTime.Now,
IsActive = true,
DeDescription = pJobAddRequest.DeDescription,
DeTitle = pJobAddRequest.DeTitle,
IdRole = pJobAddRequest.IdRole,
VlSalaryMin = pJobAddRequest.VlSalaryMin,
VlSalaryMax = pJobAddRequest.VlSalaryMax
};
// Insert in DB
((IBaseRepository <Job>)RepositorySingleton.instance.JobRepository).Add(job);
}
catch (Exception ex)
{
this.APIResponse = APIResponseFactory.Create(System.Net.HttpStatusCode.BadRequest);
this.APIResponse.AddError("Exception", $"Message: {ex.Message.ToStringOrEmpty()}");
this.APIResponse.AddError("Exception", $"Stack Trace: {ex.StackTrace.ToStringOrEmpty()}");
this.APIResponse.AddError("Exception", $"Inner Exception: {ex.InnerException.ToStringOrEmpty()}");
return(BadRequest(this.APIResponse));
}
this.APIResponse = APIResponseFactory.Create(System.Net.HttpStatusCode.OK);
return(Ok(this.APIResponse));
}
