public List <JobDocuments> GetDocumentsByJobId(int jobid)
{
JobDocuments _object = new JobDocuments();
_object.JobId = jobid;
return(base.GetCustomFunction <JobDocuments>("spLoadDocumentsByJobId", _object));
}
public HttpResponseMessage Insert([FromBody] JobDocuments JobDocuments)
{
_JobDocumentsRepo.InsertJobDocumentsDetailsAsync(JobDocuments);
var message = Request.CreateResponse(HttpStatusCode.Created, JobDocuments);
message.Headers.Location = new Uri(Request.RequestUri + JobDocuments.Id.ToString());
return(message);
}
public void InsertJobDocumentsDetailsAsync(JobDocuments jobAssign)
{
if (myconn.State != ConnectionState.Open)
{
myconn.Open();
}
SqlTransaction tran = myconn.BeginTransaction();
jobAssign.createdDate = DateTime.Now;
jobAssign.modifiedDate = DateTime.Now;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "SP_JobDocumentsInsertUpdate";
sqlCmd.Parameters.Add(new SqlParameter("@mode", "I"));
sqlCmd.Parameters.Add(new SqlParameter("@Id", jobAssign.Id));
sqlCmd.Parameters.Add(new SqlParameter("@jobID", jobAssign.jobID));
sqlCmd.Parameters.Add(new SqlParameter("@documentPath", jobAssign.documentPath));
sqlCmd.Parameters.Add(new SqlParameter("@documentType", jobAssign.documentType));
sqlCmd.Parameters.Add(new SqlParameter("@createdDate", jobAssign.createdDate));
sqlCmd.Parameters.Add(new SqlParameter("@modifiedDate", jobAssign.modifiedDate));
sqlCmd.Parameters.Add(new SqlParameter("@userId", jobAssign.userId));
try
{
sqlCmd.Connection = myconn;
sqlCmd.Transaction = tran;
jobAssign.Id = Convert.ToInt32(sqlCmd.ExecuteScalar());
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
gs.LogData(ex);
throw ex;
}
finally
{
if (myconn.State != ConnectionState.Closed)
{
myconn.Close();
}
}
}
public int Save(JobDocuments _object)
{
int _returnValue = base.Save <JobDocuments>("spAddEditJobDocuments", _object);
return(_returnValue);
}
public async void Update([FromBody] JobDocuments JobDocuments)
{
await Task.Run(() => _JobDocumentsRepo.UpdateJobDocumentsDetailsAsync(JobDocuments));
}
