public Work_orderM getWorkOrder(int WorkOrder_id)
{
Work_orderM WO = null;
string spName = @"[dbo].[getWorkOrder]";
using (SqlCommand cmd = new SqlCommand(spName, SQLConnection))
{
SqlParameter Emp_id_Parameter = new SqlParameter();
Emp_id_Parameter.ParameterName = "@Work_order_id";
Emp_id_Parameter.SqlDbType = SqlDbType.Int;
Emp_id_Parameter.Value = WorkOrder_id;
cmd.Parameters.Add(Emp_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 work order with the PK: " + WorkOrder_id + ", key values have been destroyed");
}
WO = new Work_orderM(reader);
}
}
}
}
return(WO);
}
public void updateWorkOrder(Work_orderM WO)
{
string spName = @"[dbo].[updateWorkOrder]";
using (SqlCommand cmd = new SqlCommand(spName, SQLConnection))
{
SqlParameter[] parms = new SqlParameter[5];
string[] names =
{
"@Work_order_id", "@Closed", "@Amount_due", "@Vehicle_VIN", "@CustomerID"
};
SqlDbType[] DBtypes =
{
SqlDbType.Int, SqlDbType.Bit, SqlDbType.Decimal, SqlDbType.VarChar, SqlDbType.Int
};
Object[] values =
{
WO.Work_order_id, WO.Closed, WO.Amount_Due, WO.Vehicle_VIN, WO.CustomerID
};
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();
}
}
