public static bool UpdateInvoicePay(UpdateInvoicePayRequest request) { Service client = new Service(); bool response = client.UpdateInvoicePay(request); return(response); }
public static bool UpdateInvoicePay(UpdateInvoicePayRequest request) { bool result = false; using (SqlConnection con = new SqlConnection(Variables.PaymentSystemDBConnection)) { try { con.Open(); using (SqlCommand cmd = new SqlCommand(SQLConstants.SP_UPDATE_INVOICE_PAY, con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@INVOICE_ID", request.InvoiceId); cmd.Parameters.AddWithValue("@UPDATE_USER", request.UpdateUser); var ReturnParameter = cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int); ReturnParameter.Direction = ParameterDirection.ReturnValue; cmd.ExecuteNonQuery(); result = Convert.ToInt32(ReturnParameter.Value) == 0 ? false : true; } } catch (Exception ex) { throw; } } return(result); }
public bool UpdateInvoicePay(UpdateInvoicePayRequest request) { return(DBLayer.UpdateInvoicePay(request)); }