public HttpResponseMessage Insert([FromBody] JobRates JobRates) { _JobRatesRepo.InsertJobRatesDetailsAsync(JobRates); var message = Request.CreateResponse(HttpStatusCode.Created, JobRates); message.Headers.Location = new Uri(Request.RequestUri + JobRates.Id.ToString()); return(message); }
public void UpdateJobRatesDetailsAsync(JobRates 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_JobRatesInsertUpdate"; sqlCmd.Parameters.Add(new SqlParameter("@mode", "U")); sqlCmd.Parameters.Add(new SqlParameter("@Id", jobAssign.Id)); sqlCmd.Parameters.Add(new SqlParameter("@jobID", jobAssign.jobID)); sqlCmd.Parameters.Add(new SqlParameter("@projRatesId", jobAssign.projRatesId)); sqlCmd.Parameters.Add(new SqlParameter("@propsedBOQQuantity", jobAssign.propsedBOQQuantity)); sqlCmd.Parameters.Add(new SqlParameter("@actualBOQQuantity", jobAssign.actualBOQQuantity)); 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; sqlCmd.ExecuteNonQuery(); // UpdateJobRatesRatesDetailsAsync(JobRatesRates, tran); tran.Commit(); } catch (Exception ex) { tran.Rollback(); gs.LogData(ex); throw ex; } finally { if (myconn.State != ConnectionState.Closed) myconn.Close(); } }
public async void Update([FromBody] JobRates JobRates) { await Task.Run(() => _JobRatesRepo.UpdateJobRatesDetailsAsync(JobRates)); }