/*******************************************************************************************************/
#region CLASS METHODS
public static void updateStatus(Guid id, SaleOrderItemStatus statusEnumID)
{
try
{
using (SqlCommand cmd = new SqlCommand("SaleOrderItems_update_Status_enum_id", DBConnection.ActiveSqlConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@" + COL_DB_Id, SqlDbType.UniqueIdentifier).Value = id;
cmd.Parameters.Add("@" + COL_DB_Status_enum_id, SqlDbType.TinyInt).Value = statusEnumID;
cmd.ExecuteNonQuery();
ActivityLog.submit(id, "Status changed to: " + statusEnumID.ToString());
}
}
catch (Exception ex) { Tools.showError(ex.Message); }
}
/*******************************************************************************************************/
#region CONSTRUCTORS
public SaleOrderItem(Guid id)
{
Id = id;
DataTable dt = get(null, Id, null, false);
SaleOrders_Id = (Guid)dt.Rows[0][COL_DB_SaleOrders_Id];
if (dt.Rows[0][COL_DB_Ref_Inventory_Id] != DBNull.Value)
{
Ref_Inventory_Id = (Guid)dt.Rows[0][COL_DB_Ref_Inventory_Id];
}
PricePerUnit = Convert.ToDecimal(dt.Rows[0][COL_DB_PricePerUnit]);
ProductDescription = dt.Rows[0][COL_DB_ProductDescription].ToString();
Qty = Convert.ToInt16(dt.Rows[0][COL_DB_Qty]);
UnitName = dt.Rows[0][COL_DB_UnitName].ToString();
LineNo = Convert.ToInt16(dt.Rows[0][COL_DB_LineNo]);
PriorityNo = DBUtil.parseData <int>(dt.Rows[0], COL_DB_PriorityNo);
ExpectedDeliveryDate = DBUtil.parseData <DateTime?>(dt.Rows[0], COL_DB_ExpectedDeliveryDate);
Notes = dt.Rows[0][COL_DB_Notes].ToString();
Subtotal = DBUtil.parseData <decimal>(dt.Rows[0], COL_Subtotal);
Status = Util.parseEnum <SaleOrderItemStatus>(DBUtil.parseData <object>(dt.Rows[0], COL_DB_Status_enum_id));
Customers_Id = DBUtil.parseData <Guid>(dt.Rows[0], COL_Customers_Id);
CustomerName = DBUtil.parseData <string>(dt.Rows[0], COL_CustomerName);
}
