public static ItemAdjustment Add(int employeeId, ItemAdjustmentType type, int itemId, int?itemOptionSetId = null) { ItemAdjustment result = null; SqlConnection cn = GetConnection(); DateTime when = DateTime.Now; string cmd = "AddItemAdjustment"; using (SqlCommand sqlCmd = new SqlCommand(cmd, cn)) { sqlCmd.CommandType = CommandType.StoredProcedure; BuildSqlParameter(sqlCmd, "@ItemAdjustmentItemId", SqlDbType.Int, itemId); BuildSqlParameter(sqlCmd, "@ItemAdjustmentEmployeeId", SqlDbType.Int, employeeId); BuildSqlParameter(sqlCmd, "@ItemAdjustmentItemOptionSetId", SqlDbType.Int, itemOptionSetId); BuildSqlParameter(sqlCmd, "@ItemAdjustmentType", SqlDbType.TinyInt, type); BuildSqlParameter(sqlCmd, "@ItemAdjustmentWhen", SqlDbType.DateTime, when); BuildSqlParameter(sqlCmd, "@ItemAdjustmentId", SqlDbType.Int, ParameterDirection.ReturnValue); if (sqlCmd.ExecuteNonQuery() > 0) { result = new ItemAdjustment(Convert.ToInt32(sqlCmd.Parameters["@ItemAdjustmentId"].Value), employeeId, type, itemId, itemOptionSetId, when); } } FinishedWithConnection(cn); return(result); }
private ItemAdjustment(int id, int employeeId, ItemAdjustmentType type, int itemId, int?itemOptionSetId, DateTime when) { Id = id; EmployeeId = employeeId; Type = type; ItemId = itemId; ItemOptionSetId = itemOptionSetId; When = when; }