/*******************************************************************************************************/ #region DATABASE METHODS public static string add(Guid id, Guid customerID, string customerInfo, decimal discountAmount, decimal otherCharges, string notes, DataTable gordenOrderItems, List <GordenOrderItemMaterial> materials) { string no = ""; try { using (SqlCommand cmd = new SqlCommand("gordenorder_add", DBConnection.ActiveSqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@" + COL_DB_ID, SqlDbType.UniqueIdentifier).Value = id; cmd.Parameters.Add("@" + COL_DB_CUSTOMERID, SqlDbType.UniqueIdentifier).Value = customerID; cmd.Parameters.Add("@" + COL_DB_CUSTOMERINFO, SqlDbType.VarChar).Value = customerInfo; cmd.Parameters.Add("@" + COL_DB_DISCOUNTAMOUNT, SqlDbType.Decimal).Value = discountAmount; cmd.Parameters.Add("@" + COL_DB_OTHERCHARGES, SqlDbType.Decimal).Value = otherCharges; cmd.Parameters.Add("@" + COL_DB_NOTES, SqlDbType.VarChar).Value = Util.wrapNullable(notes); SqlParameter return_value = cmd.Parameters.Add("@return_value", SqlDbType.Int); return_value.Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); no = Convert.ToInt32(return_value.Value).ToString(); ActivityLog.submit(id, "Item added"); GordenOrderItem.addItems(gordenOrderItems); GordenOrderItemMaterial.addItems(materials); } } catch (Exception ex) { Tools.showError(ex.Message); } return(no); }
public static void update(Guid id, string description, decimal sellAmountPerUnit, int qty, string notes) { try { string log = ""; GordenOrderItem objOld = new GordenOrderItem(id); log = ActivityLog.appendChange(log, objOld.Description, description, "Description: '{0}' to '{1}'"); log = ActivityLog.appendChange(log, objOld.SellAmountPerUnit, sellAmountPerUnit, "Sell Amount Per Unit: '{0}' to '{1}'"); log = ActivityLog.appendChange(log, objOld.Qty, qty, "Qty: '{0}' to '{1}'"); log = ActivityLog.appendChange(log, objOld.Notes, notes, "Notes: '{0}' to '{1}'"); using (SqlCommand cmd = new SqlCommand("gordenorderitem_update", DBConnection.ActiveSqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@" + COL_DB_ID, SqlDbType.UniqueIdentifier).Value = id; cmd.Parameters.Add("@" + COL_DB_DESCRIPTION, SqlDbType.VarChar).Value = description; cmd.Parameters.Add("@" + COL_DB_SELLAMOUNTPERUNIT, SqlDbType.Decimal).Value = sellAmountPerUnit; cmd.Parameters.Add("@" + COL_DB_QTY, SqlDbType.Int).Value = qty; cmd.Parameters.Add("@" + COL_DB_NOTES, SqlDbType.VarChar).Value = Util.wrapNullable(notes); cmd.ExecuteNonQuery(); ActivityLog.submit(id, String.Format("Item updated: {0}", log)); } } catch (Exception ex) { Tools.showError(ex.Message); } }
public static void update(Guid id, string notes) { try { string log = ""; GordenOrderItem objOld = new GordenOrderItem(id); log = ActivityLog.appendChange(log, objOld.Notes, notes, "Notes: '{0}' to '{1}'"); using (SqlCommand cmd = new SqlCommand("gordenorderitemmaterial_update", DBConnection.ActiveSqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@" + COL_DB_ID, SqlDbType.UniqueIdentifier).Value = id; cmd.Parameters.Add("@" + COL_DB_NOTES, SqlDbType.VarChar).Value = Util.wrapNullable(notes); cmd.ExecuteNonQuery(); ActivityLog.submit(id, String.Format("Item updated: {0}", log)); } } catch (Exception ex) { Tools.showError(ex.Message); } }