public void InsertProjectRatesDetailsAsync(ProjectRates projRates)
{
if (myconn.State != ConnectionState.Open)
{
myconn.Open();
}
SqlTransaction tran = myconn.BeginTransaction();
projRates.createdDate = DateTime.Now;
projRates.modifiedDate = DateTime.Now;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "SP_ProjectRatesInsertUpdate";
sqlCmd.Parameters.Add(new SqlParameter("@mode", "I"));
sqlCmd.Parameters.Add(new SqlParameter("@Id", projRates.Id));
sqlCmd.Parameters.Add(new SqlParameter("@ProjId", projRates.ProjId));
sqlCmd.Parameters.Add(new SqlParameter("@SORTypeId", projRates.SORTypeId));
sqlCmd.Parameters.Add(new SqlParameter("@subSORTypeId", projRates.subSORTypeId));
sqlCmd.Parameters.Add(new SqlParameter("@SORCode", projRates.SORCode));
sqlCmd.Parameters.Add(new SqlParameter("@description", projRates.description));
sqlCmd.Parameters.Add(new SqlParameter("@unitOfMeasure", projRates.unitOfMeasure));
sqlCmd.Parameters.Add(new SqlParameter("@unit", projRates.unit));
sqlCmd.Parameters.Add(new SqlParameter("@unitPrice", projRates.unitPrice));
sqlCmd.Parameters.Add(new SqlParameter("@cost", projRates.cost));
sqlCmd.Parameters.Add(new SqlParameter("@statusId", projRates.statusId));
sqlCmd.Parameters.Add(new SqlParameter("@expiryDate", projRates.expiryDate));
sqlCmd.Parameters.Add(new SqlParameter("@createdDate", projRates.createdDate));
sqlCmd.Parameters.Add(new SqlParameter("@modifiedDate", projRates.modifiedDate));
sqlCmd.Parameters.Add(new SqlParameter("@userId", projRates.userId));
try
{
sqlCmd.Connection = myconn;
sqlCmd.Transaction = tran;
projRates.Id = Convert.ToInt32(sqlCmd.ExecuteScalar());
// InsertProjectRatesRateDetailsAsync(ProjectRatesRates, ProjectRates.ProjectRatesID, tran);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
gs.LogData(ex);
throw ex;
}
finally
{
if (myconn.State != ConnectionState.Closed)
{
myconn.Close();
}
}
}
public HttpResponseMessage Insert([FromBody] ProjectRates projRates)
{
_ProjectRatesRepo.InsertProjectRatesDetailsAsync(projRates);
var message = Request.CreateResponse(HttpStatusCode.Created, projRates);
message.Headers.Location = new Uri(Request.RequestUri + projRates.Id.ToString());
return(message);
}
public static ProjectRateModel ToProjectRateModel(ProjectRates dbModel)
{
return(new ProjectRateModel()
{
ProjectRateId = dbModel.ProjectRateId,
ProjectId = dbModel.ProjectId ?? 0,
UserId = dbModel.UserId ?? 0,
ExternalRate = dbModel.ExternalRate ?? 0
});
}
public async void Update([FromBody] ProjectRates projRates)
{
await Task.Run(() => _ProjectRatesRepo.UpdateProjectRatesDetailsAsync(projRates));
}
