public ArbitrCase GetArbitrCase(int Id)
{
ArbitrCase acase = new ArbitrCase();
using (var sqlConnection = new SqlConnection(ConnectionString))
{
sqlConnection.Open();
SqlCommand cmd = new SqlCommand("select CaseNumber,Date from ArbitrCases where Id=" + Id.ToString(), sqlConnection);
using (var reader = cmd.ExecuteReader())
{
reader.Read();
acase.Id = Id;
acase.CaseNumber = reader.GetString(0);
}
cmd = new SqlCommand("select SideId,ObjectType,SideType from ArbitrSides where CaseId=" + Id, sqlConnection);
acase.Sides = new List<ArbitrSide>();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
ArbitrSide side = new ArbitrSide();
int type = reader.GetBoolean(1)?1:0;
int sid = reader.GetInt32(0);
if (type == 0)
side.Object = GetCompany(sid);
else
side.Object = GetPerson(sid);
side.SideType = GetSideType(int.Parse(reader.GetValue(2).ToString()));
acase.Sides.Add(side);
}
}
}
return acase;
}
public List<ArbitrCase> GetArbitrCases(int Id)
{
List<ArbitrCase> result = new List<ArbitrCase>();
using (var sqlConnection = new SqlConnection(ConnectionString))
{
sqlConnection.Open();
SqlCommand cmd = new SqlCommand(@"select ArbitrCases.Id, ArbitrCases.CaseNumber, ArbitrCases.[Date], SideType from ARbitrSides
inner join ArbitrCases on ArbitrCases.Id = ArbitrSides.CaseId where ArbitrSides.SideId=@id and ArbitrSides.SideType = 0", sqlConnection);
cmd.Parameters.AddWithValue("id", Id);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
ArbitrCase _case = new ArbitrCase();
_case.Id = reader.GetInt32(0);
_case.CaseNumber = reader.GetString(1);
_case.Date = reader.GetDateTime(2);
result.Add(_case);
}
}
}
return result;
}
