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)); }