public List <ComplexWithHouses> SelectAllComplexWithHouses()
{
var tempComplexList = new List <ComplexWithHouses>();
using (var sqlConnection = new SqlConnection(ConnectionStringValue()))
{
try
{
const string sqlQuery =
@"SELECT [IdComplex], [Name_Housing_Complex], [City],
[Status_Construction_Housing_Complex],
[Added_Value], [Building_Costs]
FROM [dbo].[Complex]
WHERE [Complex].IsDeleted = 0";
SqlDataReader reader;
using (var sqlCommand = new SqlCommand(sqlQuery,
sqlConnection))
{
sqlConnection.Open();
reader = sqlCommand.ExecuteReader();
}
if (reader.HasRows)
{
var items = new List <ComplexWithHouses>();
while (reader.Read())
{
var u = new ComplexWithHouses
{
IdComplex = reader.GetInt32(0),
NameHousingComplex = reader.GetString(1),
City = reader.GetString(2),
StatusConstructionHousingComplex = reader.GetString(3),
AddedValue = reader.GetInt64(4),
BuildingCost = reader.GetInt64(5)
};
items.Add(u);
}
tempComplexList = items;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
"Ошибка",
MessageBoxButton.OK,
MessageBoxImage.Error);
}
finally
{
sqlConnection.Close();
}
}
return(tempComplexList);
}
public ComplexWithHouses GetComplexWithHouses(Complex selectComplex)
{
if (ComplexAccess != null)
{
Complex temp = ComplexAccess.SelectComplex(selectComplex);
var downCastedComplex = new ComplexWithHouses
{
AddedValue = temp.AddedValue,
BuildingCost = temp.BuildingCost,
City = temp.City,
IdComplex = temp.IdComplex,
IsDeleted = temp.IsDeleted,
StatusConstructionHousingComplex = temp.StatusConstructionHousingComplex,
NameHousingComplex = temp.NameHousingComplex
};
return(downCastedComplex);
}
return(new ComplexWithHouses());
}
public ComplexVM()
{
_complexAdapter = new ComplexAdapter();
Validator = new Validator();
SaveCommand = new RelayCommand(Save);
AddCommand = new RelayCommand(Add);
CurrentComplex = new ComplexWithHouses();
StatusList = new List <string> {
"План", "Строительство", "Реализация"
};
CurrentComplex.IdComplex = App.CurrentItemId;
CurrentComplex = _complexAdapter.GetComplexWithHouses(CurrentComplex);
CurrentStatus =
StatusList.FirstOrDefault(
item => item == CurrentComplex.StatusConstructionHousingComplexName);
}
