public static ItemOptionAdjustment Get(int id) { ItemOptionAdjustment result = null; SqlConnection cn = GetConnection(); result = Get(cn, id); FinishedWithConnection(cn); return(result); }
private static ItemOptionAdjustment Get(SqlConnection cn, int id) { ItemOptionAdjustment result = null; using (SqlCommand cmd = new SqlCommand("SELECT * FROM ItemAdjustment WHERE ItemAdjustmentId=" + id, cn)) { using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { result = BuildItemOptionAdjustment(rdr); } } } return(result); }
public static ItemOptionAdjustment Add(int employeeId, ItemOptionAdjustmentType type, int?itemOptionSetId, int?itemOptionId, int?oldProductId, int?newProductId, byte?oldTinyIntValue, byte?newTinyIntValue, double?oldFloatValue, double?newFloatValue) { ItemOptionAdjustment result = null; SqlConnection cn = GetConnection(); DateTime when = DateTime.Now; string cmd = "AddItemOptionAdjustment"; using (SqlCommand sqlCmd = new SqlCommand(cmd, cn)) { sqlCmd.CommandType = CommandType.StoredProcedure; BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentEmployeeId", SqlDbType.Int, employeeId); BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentItemOptionSetId", SqlDbType.Int, itemOptionSetId); BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentItemOptionId", SqlDbType.Int, itemOptionId); BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentType", SqlDbType.TinyInt, type); BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentOldProductId", SqlDbType.Int, oldProductId); BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentNewProductId", SqlDbType.Int, newProductId); BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentOldTinyIntValue", SqlDbType.TinyInt, oldTinyIntValue); BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentNewTinyIntValue", SqlDbType.TinyInt, newTinyIntValue); BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentOldFloatValue", SqlDbType.Float, oldFloatValue); BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentNewFloatValue", SqlDbType.Float, newFloatValue); BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentWhen", SqlDbType.DateTime, when); BuildSqlParameter(sqlCmd, "@ItemOptionAdjustmentId", SqlDbType.Int, ParameterDirection.ReturnValue); if (sqlCmd.ExecuteNonQuery() > 0) { result = new ItemOptionAdjustment(Convert.ToInt32(sqlCmd.Parameters["@ItemAdjustmentId"].Value), employeeId, type, itemOptionSetId, itemOptionId, oldProductId, newProductId, oldTinyIntValue, newTinyIntValue, oldFloatValue, newFloatValue, when); } } FinishedWithConnection(cn); return(result); }