public void addPart(PartM part)
{
string spName = @"[dbo].[addPart]";
using (SqlCommand cmd = new SqlCommand(spName, SQLConnection))
{
SqlParameter[] parms = new SqlParameter[4];
string[] names =
{
"@Part_id", "@PState", "@Price", "@Work_order_id"
};
SqlDbType[] DBtypes =
{
SqlDbType.Int, SqlDbType.VarChar, SqlDbType.Decimal, SqlDbType.Int
};
Object[] values =
{
part.Part_id, part.State, part.Price, part.Work_order_id
};
for (int i = 0; i < parms.Length; i++)
{
parms[i] = new SqlParameter();
parms[i].ParameterName = names[i];
parms[i].SqlDbType = DBtypes[i];
parms[i].Value = values[i];
cmd.Parameters.Add(parms[i]);
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}
}
public PartM getPart(int Part_id, int Part_instance_id)
{
PartM part = null;
string spName = @"[dbo].[getPart]";
using (SqlCommand cmd = new SqlCommand(spName, SQLConnection))
{
SqlParameter part_id_Parameter = new SqlParameter();
SqlParameter instance_id_Parameter = new SqlParameter();
part_id_Parameter.ParameterName = "@Part_id";
instance_id_Parameter.ParameterName = "@Part_instance_no";
part_id_Parameter.SqlDbType = SqlDbType.Int;
instance_id_Parameter.SqlDbType = SqlDbType.Int;
part_id_Parameter.Value = Part_id;
instance_id_Parameter.Value = Part_instance_id;
cmd.Parameters.Add(part_id_Parameter);
cmd.Parameters.Add(instance_id_Parameter);
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
int test = 0;
while (reader.Read())
{
if (test > 0)
{
throw new Exception("more then one part with the PK: " + Part_id + " " + Part_instance_id + ", key values have been destroyed");
}
part = new PartM(reader);
}
}
}
}
return(part);
}
