public static bool Update(ItemGroup itemGroup)
{
Int32 rowsAffected = 0;
SqlConnection cn = GetConnection();
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "UPDATE ItemGroup SET ItemGroupSourceItemId=@ItemGroupSourceItemId,ItemGroupTargetItemId=@ItemGroupTargetItemId,ItemGroupTargetItemQuantity=@ItemGroupTargetItemQuantity WHERE ItemGroupId=@ItemGroupId";
BuildSqlParameter(sqlCmd, "@ItemGroupId", SqlDbType.Int, itemGroup.Id);
BuildSqlParameter(sqlCmd, "@ItemGroupSourceItemId", SqlDbType.Int, itemGroup.SourceItemId);
BuildSqlParameter(sqlCmd, "@ItemGroupTargetItemId", SqlDbType.Int, itemGroup.TargetItemId);
BuildSqlParameter(sqlCmd, "@ItemGroupTargetItemQuantity", SqlDbType.Int, itemGroup.TargetItemQuantity);
rowsAffected = sqlCmd.ExecuteNonQuery();
}
FinishedWithConnection(cn);
return(rowsAffected != 0);
}
public static ItemGroup Get(int itemGroupId)
{
ItemGroup result = null;
SqlConnection cn = GetConnection();
using (SqlCommand cmd = new SqlCommand("SELECT * FROM ItemGroup WHERE ItemGroupId=" + itemGroupId, cn))
{
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
result = BuildItemGroup(rdr);
}
}
}
FinishedWithConnection(cn);
return(result);
}
public static ItemGroup Add(int sourceItemId, int targetItemId, int targetItemQuantity)
{
ItemGroup result = null;
SqlConnection cn = GetConnection();
using (SqlCommand sqlCmd = new SqlCommand("AddItemGroup", cn))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
BuildSqlParameter(sqlCmd, "@ItemGroupSourceItemId", SqlDbType.Int, sourceItemId);
BuildSqlParameter(sqlCmd, "@ItemGroupTargetItemId", SqlDbType.Int, targetItemId);
BuildSqlParameter(sqlCmd, "@ItemGroupTargetItemQuantity", SqlDbType.Int, targetItemQuantity);
BuildSqlParameter(sqlCmd, "@ItemGroupId", SqlDbType.Int, ParameterDirection.ReturnValue);
if (sqlCmd.ExecuteNonQuery() > 0)
{
result = new ItemGroup(Convert.ToInt32(sqlCmd.Parameters["@ItemGroupId"].Value),
sourceItemId, targetItemId, targetItemQuantity);
}
}
FinishedWithConnection(cn);
return(result);
}