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);
}
public static ItemAdjustment Get(int id)
{
ItemAdjustment result = null;
SqlConnection cn = GetConnection();
result = Get(cn, id);
FinishedWithConnection(cn);
return(result);
}
private static ItemAdjustment Get(SqlConnection cn, int id)
{
ItemAdjustment result = null;
using (SqlCommand cmd = new SqlCommand("SELECT * FROM ItemAdjustment WHERE ItemAdjustmentId=" + id, cn))
{
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
result = BuildItemAdjustment(rdr);
}
}
}
return(result);
}