public HttpResponseMessage Insert([FromBody] JobBOQVariation JobBOQVariation) { _JobBOQVariationRepo.InsertJobBOQVariationDetailsAsync(JobBOQVariation); var message = Request.CreateResponse(HttpStatusCode.Created, JobBOQVariation); message.Headers.Location = new Uri(Request.RequestUri + JobBOQVariation.Id.ToString()); return(message); }
public void InsertJobBOQVariationDetailsAsync(JobBOQVariation jbBOQVariation) { if (myconn.State != ConnectionState.Open) { myconn.Open(); } SqlTransaction tran = myconn.BeginTransaction(); jbBOQVariation.createdDate = DateTime.Now; jbBOQVariation.modifiedDate = DateTime.Now; SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "SP_JobBOQVariationInsertUpdate"; sqlCmd.Parameters.Add(new SqlParameter("@mode", "I")); sqlCmd.Parameters.Add(new SqlParameter("@Id", jbBOQVariation.Id)); sqlCmd.Parameters.Add(new SqlParameter("@jobID", jbBOQVariation.jobID)); sqlCmd.Parameters.Add(new SqlParameter("@jobRatesId", jbBOQVariation.jobRatesId)); sqlCmd.Parameters.Add(new SqlParameter("@BOQQuantity", jbBOQVariation.BOQQuantity)); sqlCmd.Parameters.Add(new SqlParameter("@createdDate", jbBOQVariation.createdDate)); sqlCmd.Parameters.Add(new SqlParameter("@modifiedDate", jbBOQVariation.modifiedDate)); sqlCmd.Parameters.Add(new SqlParameter("@userId", jbBOQVariation.userId)); try { sqlCmd.Connection = myconn; sqlCmd.Transaction = tran; jbBOQVariation.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 async void Update([FromBody] JobBOQVariation JobBOQVariation) { await Task.Run(() => _JobBOQVariationRepo.UpdateJobBOQVariationDetailsAsync(JobBOQVariation)); }