public string UpdateQuotationStatus(QuotationStatusModel objModel) { string result = "Error on Updating Quotation Status!"; try { var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = connection.CreateCommand(); SqlTransaction transaction; transaction = connection.BeginTransaction(); cmd.Transaction = transaction; cmd.Connection = connection; try { string sqlstr = ""; sqlstr = "update ACRF_Quotation set QuotationStatus=@QuotationStatus,UpdatedOn=@UpdatedOn,UpdatedBy=@UpdatedBy"; sqlstr = sqlstr + " where QuotationId=@QuotationId "; cmd.CommandText = sqlstr; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@QuotationStatus", objModel.QuotationStatus); cmd.Parameters.AddWithValue("@UpdatedBy", objModel.UpdatedBy); cmd.Parameters.AddWithValue("@QuotationId", objModel.QuotationId); cmd.Parameters.AddWithValue("@UpdatedOn", StandardDateTime.GetDateTime()); cmd.ExecuteNonQuery(); transaction.Commit(); connection.Close(); result = "Quotation Status Updated Successfully!"; } catch (Exception ex) { transaction.Rollback(); connection.Close(); Global.ErrorHandlerClass.LogError(ex); result = ex.Message; } } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(result); }
public IHttpActionResult UpdateQuotationStatus(QuotationStatusModel objModel) { string result = ""; if (ModelState.IsValid) { try { objModel.UpdatedBy = GlobalFunction.getLoggedInUser(Request.Headers.GetValues("Token").First()); result = objQuotationVM.UpdateQuotationStatus(objModel); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); result = ex.Message; } } else { result = "Enter Valid Mandatory Fields"; } return(Ok(new { results = result })); }