/*******************************************************************************************************/
#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); }
}