public Firearm(string name, int id, int pid, FirearmClass type)
{
Name = name;
TypeId = id;
PieceId = pid;
Type = type;
}
public License(string number, string holderName, DateTime issueDate, DateTime expiryDate, string issuer, FirearmClass type)
{
Number = number;
HolderName = holderName;
IssueDate = issueDate;
ExpiryDate = expiryDate;
Issuer = issuer;
Type = type;
}
public int GetUnusedGun(FirearmClass type)
{
openConn();
int i = -1;
using (var cmd = _conn.CreateCommand())
{
switch (type)
{
case FirearmClass.Shotgun:
cmd.CommandText = "exec СвободнаяЕдиницаГс @id output";
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@id"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
i = Convert.ToInt32(cmd.Parameters["@id"].Value);
break;
case FirearmClass.Rifle:
cmd.CommandText = "exec СвободнаяЕдиницаНар @id output";
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@id"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
i = Convert.ToInt32(cmd.Parameters["@id"].Value);
break;
case FirearmClass.LessLethal:
cmd.CommandText = "exec СвободнаяЕдиницаОооп @id output";
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@id"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
i = Convert.ToInt32(cmd.Parameters["@id"].Value);
break;
case FirearmClass.NotAGun:
throw new Exception("Разрешаю и так!");
}
}
closeConn();
return(i);
}
public License(FirearmClass type)
{
Type = type;
}
