public int UpdateProductOrderData(ProductOrder productOrder) { try { SqlCommand sqlCommand = new SqlCommand("ProductOrderCrud", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@ProductOrder", "Update"); sqlCommand.Parameters.AddWithValue("@ProductOderId", productOrder.ProductOderId); sqlCommand.Parameters.AddWithValue("@CustId", productOrder.CustId); sqlCommand.Parameters.AddWithValue("@ProductId", productOrder.ProductId); sqlCommand.Parameters.AddWithValue("@ProductOrderStatus", productOrder.ProductOrderStatus); sqlCommand.Parameters.AddWithValue("@CancelDate", productOrder.CancelDate.ToLongDateString()); sqlConnection.Open(); int dataUpdated = sqlCommand.ExecuteNonQuery(); CloseAndDisposeCon(); return(dataUpdated); } catch (Exception ex) { throw ex; } finally { CloseAndDisposeCon(); } }
public int DeleteProductOrderData(ProductOrder productOrder) { try { SqlCommand sqlCommand = new SqlCommand("ProductOrderCrud", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@ProductOrder", "Delete"); sqlCommand.Parameters.AddWithValue("@ProductOrderId", productOrder.ProductOderId); sqlConnection.Open(); int dataDeleted = sqlCommand.ExecuteNonQuery(); CloseAndDisposeCon(); return(dataDeleted); } catch (Exception ex) { throw ex; } finally { CloseAndDisposeCon(); } }