/// <summary>
/// Загружает тип станка.
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private static TypeMachine LoadTypeMachine(SqlDataReader reader)
{
TypeMachine typeMachine = new TypeMachine();
try
{
typeMachine.CodeMachine = reader.GetInt32(reader.GetOrdinal("CodeMachine"));
typeMachine.Mark = reader.GetString(reader.GetOrdinal("Mark"));
typeMachine.YearOfIssue = reader.GetInt32(reader.GetOrdinal("YearOfIssue"));;
}
catch (Exception exc)
{
MessageBox.Show(exc.Message, "Ошибка");
}
return(typeMachine);
}
/// <summary>
/// Добавляет текущий тип станка.
/// </summary>
/// <param name="typeMachine"></param>
public void Add(TypeMachine typeMachine)
{
try
{
using (var conn = GetConnection())
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "INSERT INTO TypeMachine(CodeMachine, Mark, YearOfIssue) VALUES(@CodeMachine, @Mark, @YearOfIssue)";
cmd.Parameters.AddWithValue("@CodeMachine", typeMachine.CodeMachine);
cmd.Parameters.AddWithValue("@Mark", typeMachine.Mark);
cmd.Parameters.AddWithValue("@YearOfIssue", typeMachine.YearOfIssue);
cmd.ExecuteNonQuery();
}
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message, "Ошибка");
}
}
/// <summary>
/// Обновляет текущий тип станка.
/// </summary>
/// <param name="typeRepair"></param>
public void Update(TypeMachine typeRepair)
{
try
{
using (var conn = GetConnection())
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "UPDATE TypeMachine SET Mark = @Mark, YearOfIssue=@YearOfIssue WHERE CodeMachine = @ID1";
cmd.Parameters.AddWithValue("@ID1", typeRepair.CodeMachine);
cmd.Parameters.AddWithValue("@Mark", typeRepair.Mark);
cmd.Parameters.AddWithValue("@YearOfIssue", typeRepair.YearOfIssue);
cmd.ExecuteNonQuery();
}
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message, "Ошибка");
}
}