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; }