internal void GetMeterForEdit(int meterId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var meterDB = context.METERs.Find(meterId);
if (meterDB != null)
{
var meterTypeDB = context.METER_TYPEs.Where(mt => mt.ID == meterDB.METER_TYPE_ID).FirstOrDefault();
var utility = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).Select(Utility.GetUtilityWithIdAndResourceName).FirstOrDefault();
var meterType = new MeterType()
{
Id = meterTypeDB.ID, Name = meterTypeDB.NAME, VarificationPeriod = meterTypeDB.VARIFICATION_PERIOD_YEARS, Utility = utility
};
Id = meterDB.ID;
MeterType = meterType;
SerialNumber = meterDB.SERIAL_NUMBER;
ReleaseDate = meterDB.RELEASE_DATE;
VarificationDate = meterDB.VARIFICATION_DATE;
MeterTypes = context.METER_TYPEs.Select(MeterType.Get).ToList();
}
}
}
private void FillMetersForModel(TownUtilityBillSystemV2Entities context, ADDRESS addressDB)
{
var metersDB = context.METERs.Where(m => m.ADDRESS_ID == addressDB.ID).ToList();
foreach (var m in metersDB)
{
var meterTypeDB = context.METER_TYPEs.Where(mt => mt.ID == m.METER_TYPE_ID).FirstOrDefault();
var utilityDB = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).FirstOrDefault();
var utility = new Utility()
{
Id = utilityDB.ID, Name = utilityDB.NAME
};
var meterType = new MeterType()
{
Id = meterTypeDB.ID, Name = meterTypeDB.NAME, Utility = utility
};
Meters.Add(new Meter()
{
Id = m.ID, SerialNumber = m.SERIAL_NUMBER, ReleaseDate = m.RELEASE_DATE, VarificationDate = m.VARIFICATION_DATE, MeterType = meterType
});
}
}
public void GetBillsToShow()
{
using (var context = new TownUtilityBillSystemV2Entities())
{
List <BILL> rndBillsDB = GetSomeRandomBillsDB(context);
foreach (var b in rndBillsDB)
{
Customer customer = new Customer();
var accountDB = context.ACCOUNTs.Where(c => c.ID == b.ACCOUNT_ID).FirstOrDefault();
var customerDB = context.CUSTOMERs.Where(c => c.ACCOUNT_ID == accountDB.ID).FirstOrDefault();
CustomerType customerType;
Address address;
GetAddressAndCustomerTypeForCustomer(context, customerDB, out customerType, out address);
customer.Id = customerDB.ID;
customer.Surname = customerDB.SURNAME;
customer.Name = customerDB.NAME;
customer.Address = address;
Bills.Add(new Bill()
{
Id = b.ID, Number = b.NUMBER, Period = HelperMethod.GetFullMonthName(b.PERIOD), Date = b.DATE, Sum = b.SUM, Paid = b.PAID, Customer = customer
});
}
}
}
public static string GetUtilityImage(int utilityId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
IMAGE_UTILITY imageDB = null;
string imageName = "";
string imagePathForHtml = "";
string imagePathDB = "";
string folderName = "";
var utilityDB = context.UTILITYs.Where(b => b.ID == utilityId).FirstOrDefault();
if (utilityDB != null)
{
imageDB = context.IMAGE_UTILITYs.Where(i => i.ID == utilityDB.IMAGE_ID).FirstOrDefault();
}
if (imageDB != null)
{
imagePathDB = imageDB.PATH.ToString();
folderName = Path.GetFileName(Path.GetDirectoryName(imagePathDB));
imageName = Path.GetFileName(imagePathDB);
imagePathForHtml = "/Content/Images/" + folderName + "/" + imageName;
}
return(imagePathForHtml);
}
}
internal List <CustomerType> GetCustomerTypes()
{
using (var context = new TownUtilityBillSystemV2Entities())
{
return(context.CUSTOMER_TYPEs.Select(CustomerType.Get).ToList());
}
}
internal void GetMeterDetailsForCustomer(int customerId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var customerDB = context.CUSTOMERs.Find(customerId);
if (customerDB != null)
{
var customerTypeDB = context.CUSTOMER_TYPEs.Where(mt => mt.ID == customerDB.CUSTOMER_TYPE_ID).FirstOrDefault();
var addressDB = context.ADDRESSes.Where(a => a.ID == customerDB.ADDRESS_ID).FirstOrDefault();
var index = context.INDEXes.Where(i => i.ID == addressDB.INDEX_ID).Select(Index.Get).FirstOrDefault();
var town = context.TOWNs.Where(t => t.ID == addressDB.TOWN_ID).Select(Town.Get).FirstOrDefault();
var street = context.STREETs.Where(s => s.ID == addressDB.STREET_ID).Select(Street.Get).FirstOrDefault();
var building = context.BUILDINGs.Where(b => b.ID == addressDB.BUILDING_ID).Select(Building.GetWithSquareAndImagePath).FirstOrDefault();
var flatPartDB = context.FLAT_PARTs.Where(fp => fp.ID == addressDB.FLAT_PART_ID).FirstOrDefault();
var metersDB = context.METERs.Where(m => m.ADDRESS_ID == addressDB.ID).ToList();
foreach (var m in metersDB)
{
var meterTypeDB = context.METER_TYPEs.Where(mt => mt.ID == m.METER_TYPE_ID).FirstOrDefault();
var utility = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).Select(Utility.GetUtilityWithIdAndResourceName).FirstOrDefault();
var meterType = new MeterType()
{
Id = meterTypeDB.ID, Name = meterTypeDB.NAME, Utility = utility
};
Meters.Add(new Meter()
{
Id = m.ID, SerialNumber = m.SERIAL_NUMBER, ReleaseDate = m.RELEASE_DATE, VarificationDate = m.VARIFICATION_DATE, MeterType = meterType
});
}
FlatPart flatPart = null;
if (flatPartDB != null)
{
flatPart = FlatPart.Get(flatPartDB);
}
var customerType = new CustomerType()
{
Id = customerTypeDB.ID, Name = customerTypeDB.NAME, ResourceName = CustomerType.GetResourceName(customerTypeDB.NAME)
};
var account = context.ACCOUNTs.Where(a => a.ID == customerDB.ACCOUNT_ID).Select(Account.Get).FirstOrDefault();
var address = new Address()
{
Id = addressDB.ID, Index = index, Town = town, Street = street, Building = building, FlatPart = flatPart
};
Customer = new Customer()
{
Id = customerDB.ID, Account = account, Surname = customerDB.SURNAME, Name = customerDB.NAME, Email = customerDB.EMAIL, Phone = customerDB.PHONE, CustomerType = customerType, Address = address
};
}
else
{
Customer = null;
}
}
}
public List <Customer> GetPrivateCutomers()
{
using (var context = new TownUtilityBillSystemV2Entities())
{
List <Customer> privateCustomers = new List <Customer>();
List <int> privateTypeIds = GetPrivateCustomerTypeIds(context);
var privateCustomersDB = context.CUSTOMERs.Where(c => privateTypeIds.Any(i => c.CUSTOMER_TYPE_ID == i)).ToList();
foreach (var c in privateCustomersDB)
{
var customerTypeDB = context.CUSTOMER_TYPEs.Where(ct => ct.ID == c.CUSTOMER_TYPE_ID).FirstOrDefault();
CustomerType customerType = CustomerType.Get(customerTypeDB);
var accountDB = context.ACCOUNTs.Where(a => a.ID == c.ACCOUNT_ID).FirstOrDefault();
Account account = Account.Get(accountDB);
privateCustomers.Add(new Customer()
{
Id = c.ID, Account = account, Surname = c.SURNAME, Name = c.NAME, Email = c.EMAIL, Phone = c.PHONE, CustomerType = customerType
});
}
return(privateCustomers);
}
}
public void CalculateCharges(CalculatorItemModel inputModel)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var elUtilityDB = context.UTILITYs.Find((int)InitialDB.InitialDBEnums.Utilities.Electricity);
var waterUtilityDB = context.UTILITYs.Find((int)InitialDB.InitialDBEnums.Utilities.Water);
var heatUtilityDB = context.UTILITYs.Find((int)InitialDB.InitialDBEnums.Utilities.Heating);
var gasUtilityDB = context.UTILITYs.Find((int)InitialDB.InitialDBEnums.Utilities.Gas);
ElCharges = (inputModel.ElectricUsage > (float)elUtilityDB.USAGEFORSTANDARTPRICE)
? (float)elUtilityDB.USAGEFORSTANDARTPRICE * (float)elUtilityDB.PRICE + (inputModel.ElectricUsage - (float)elUtilityDB.USAGEFORSTANDARTPRICE) * (float)elUtilityDB.BIGUSAGEPRICE
: inputModel.ElectricUsage * (float)elUtilityDB.PRICE;
WaterCharges = inputModel.WaterUsage * (float)waterUtilityDB.PRICE;
HeatCharges = inputModel.HeatUsage * (float)heatUtilityDB.PRICE;
GasCharges = inputModel.GasUsage * (float)gasUtilityDB.PRICE;
ElectricUsage = inputModel.ElectricUsage;
WaterUsage = inputModel.WaterUsage;
HeatUsage = inputModel.HeatUsage;
GasUsage = inputModel.GasUsage;
TotalCharges = ElCharges + WaterCharges + HeatCharges + GasCharges;
}
}
public static string GetBuildingImageForCustomerDetailsView(int buildingId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
IMAGE_BUILDING imageDB = null;
string imageName = "";
string imagePath = "";
string imagePathDB = "";
string folderName = "";
var buildingDB = context.BUILDINGs.Where(b => b.ID == buildingId).FirstOrDefault();
if (buildingDB != null)
{
imageDB = context.IMAGE_BUILDINGs.Where(i => i.ID == buildingDB.IMAGE_ID).FirstOrDefault();
}
if (imageDB != null)
{
imagePathDB = imageDB.PATH.ToString();
folderName = Path.GetFileName(Path.GetDirectoryName(imagePathDB));
imageName = Path.GetFileName(imagePathDB);
imagePath = "/Content/Images/TownBuildings/" + folderName + "/" + imageName;
}
else
{
imagePath = "/Content/Images/EmptyImages/NoImageBuilding" + HelperMethod.UppercaseFirstLetter(HelperMethod.GetCurrentLanguage()) + ".jpg";
}
return(imagePath);
}
}
public void GetSingleNews(int newsId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var singleNewsDB = context.NEWS.Find(newsId);
string currentLanguage = HelperMethod.GetCurrentLanguage();
var newsTitle = context.NEWS_TITLEs.
Where(t => t.NEWS_ID == singleNewsDB.ID).
Where(t => t.LANGUAGE == currentLanguage).
FirstOrDefault().TITLE;
var chaptersDB = context.NEWS_CHAPTERs.
Where(c => c.NEWS_ID == newsId).
Where(c => c.LANGUAGE == currentLanguage).
ToList();
SingleNews.Title = newsTitle;
SingleNews.Date = singleNewsDB.DATE;
foreach (var ch in chaptersDB)
{
SingleNews.NewsChapters.Add(new NewsChapter()
{
Id = ch.ID, Text = ch.TEXT
});
}
}
}
internal MeterType GetMeterType(int meterTypeId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
MeterType meterType;
var meterTypeDB = context.METER_TYPEs.Find(meterTypeId);
if (meterTypeDB != null)
{
var utilityDB = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).FirstOrDefault();
var utility = Utility.GetUtilityWithIdAndResourceName(utilityDB);
meterType = MeterType.Get(meterTypeDB);
meterType.Utility = utility;
meterType.Utilities = context.UTILITYs.Select(Utility.GetUtilityWithIdAndResourceName).ToList();
}
else
{
meterType = null;
}
return(meterType);
}
}
internal int GetMeterId(int meterItemId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
return(context.METER_ITEMs.Find(meterItemId).METER_ID);
}
}
public void GetDataForUtility(string utilityName)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var utilityDB = context.UTILITYs.Where(u => u.NAME == utilityName).FirstOrDefault();
var unitDB = context.UNITs.Find(utilityDB.UNIT_ID);
var utilitiesDB = context.UTILITYs.ToList();
Unit.Id = unitDB.ID;
Unit.Name = unitDB.NAME;
Utility.Id = utilityDB.ID;
Utility.Name = utilityDB.NAME;
Utility.Price = utilityDB.PRICE;
Utility.ResourceName = GetResourceNameForUtility(utilityDB.NAME);
Utility.ImagePath = HelperMethod.GetUtilityImage(utilityDB.ID);
if (utilityDB.USAGEFORSTANDARTPRICE != null)
{
Utility.UsageForStandartPrice = (decimal)utilityDB.USAGEFORSTANDARTPRICE;
}
if (utilityDB.BIGUSAGEPRICE != null)
{
Utility.BigUsagePrice = (decimal)utilityDB.BIGUSAGEPRICE;
}
Utility.Unit = Unit;
foreach (var u in utilitiesDB)
{
if (u.NAME != Utility.Name)
{
Utilities.Add(new Utility()
{
Name = u.NAME, ResourceName = GetResourceNameForUtility(u.NAME)
});
}
}
var meterTypesDB = context.METER_TYPEs.Where(mt => mt.UTILITY_ID == Utility.Id).ToList();
var metersDB = context.METERs.ToList();
HashSet <int> meterTypesIds = new HashSet <int>();
foreach (var m in meterTypesDB)
{
meterTypesIds.Add(m.ID);
}
foreach (var m in metersDB)
{
if (meterTypesIds.Contains(m.METER_TYPE_ID))
{
MeterQty += 1;
}
}
}
}
private static void CreateMeterModelFromMeterList(TownUtilityBillSystemV2Entities context, MeterModel model, List <METER> rndMetersDB)
{
foreach (var m in rndMetersDB)
{
var meterTypeDB = context.METER_TYPEs.Where(mt => mt.ID == m.METER_TYPE_ID).FirstOrDefault();
var utilityDB = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).FirstOrDefault();
var addressDB = context.ADDRESSes.Where(a => a.ID == m.ADDRESS_ID).FirstOrDefault();
var indexDB = context.INDEXes.Where(i => i.ID == addressDB.INDEX_ID).FirstOrDefault();
var townDB = context.TOWNs.Where(t => t.ID == addressDB.TOWN_ID).FirstOrDefault();
var streetDB = context.STREETs.Where(s => s.ID == addressDB.STREET_ID).FirstOrDefault();
var buildingDB = context.BUILDINGs.Where(b => b.ID == addressDB.BUILDING_ID).FirstOrDefault();
var flatPartDB = context.FLAT_PARTs.Where(fp => fp.ID == addressDB.FLAT_PART_ID).FirstOrDefault();
var utility = new Utility()
{
Id = utilityDB.ID, Name = utilityDB.NAME, ResourceName = UtilityModel.GetResourceNameForUtility(utilityDB.NAME)
};
var meterType = new MeterType()
{
Id = meterTypeDB.ID, Name = meterTypeDB.NAME, Utility = utility
};
var index = new Index()
{
Id = indexDB.ID, Value = indexDB.VALUE
};
var town = new Town()
{
Id = townDB.ID, Name = townDB.NAME
};
var street = new Street()
{
Id = streetDB.ID, Name = streetDB.NAME
};
var building = new Building()
{
Id = buildingDB.ID, Number = buildingDB.NUMBER
};
FlatPart flatPart = null;
if (flatPartDB != null)
{
flatPart = FlatPart.Get(flatPartDB);
}
var address = new Address()
{
Id = addressDB.ID, Index = index, Town = town, Street = street, Building = building, FlatPart = flatPart
};
model.Meters.Add(new Meter()
{
Id = m.ID, SerialNumber = m.SERIAL_NUMBER, ReleaseDate = m.RELEASE_DATE, VarificationDate = m.VARIFICATION_DATE, MeterType = meterType, Address = address
});
}
}
public IEnumerable <METER> GetAllMeters()
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var metersDB = context.METERs.Include(m => m.ADDRESS).Include(m => m.METER_TYPE).ToList();
return(metersDB);
}
}
internal void GetMeterData(int meterId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
InitializeMeterProperty(meterId, context);
MeterItems = context.METER_ITEMs.Where(mi => mi.METER_ID == meterId).Select(MeterItem.GetMeterItemWithOutMeter).ToList();
}
}
internal void UpdateMeterData(MeterItem meterItem)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var meterItemDB = context.METER_ITEMs.Find(meterItem.Id);
meterItemDB.VALUE = meterItem.Value;
context.SaveChanges();
}
}
public SelectList GetTowns()
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var townsDB = context.TOWNs.OrderBy(t => t.NAME).ToList();
var townList = townsDB.Select(Town.Get).ToList();
return(new SelectList(townList, "Id", "Name"));
}
}
internal void GetMeterAndDataToEdit(int meterItemId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var meterItemDB = context.METER_ITEMs.Find(meterItemId);
var meterDB = context.METERs.Where(m => m.ID == meterItemDB.METER_ID).FirstOrDefault();
CreateMeterModelWithOneMeter(meterDB.ID, context, this);
MeterItem = MeterItem.GetMeterItemWithOutMeter(meterItemDB);
}
}
internal void GetBillData(int bill_Id)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var billDB = context.BILLs.Where(b => b.ID == bill_Id).FirstOrDefault();
if (billDB != null)
{
GetBillData(billDB.NUMBER);
}
}
}
private static void CreateCustomerModelFromCustomerList(TownUtilityBillSystemV2Entities context, ref List <Customer> customers, List <CUSTOMER> customersDB)
{
foreach (var c in customersDB)
{
var customerTypeDB = context.CUSTOMER_TYPEs.Where(ct => ct.ID == c.CUSTOMER_TYPE_ID).FirstOrDefault();
var addressDB = context.ADDRESSes.Where(a => a.ID == c.ADDRESS_ID).FirstOrDefault();
var indexDB = context.INDEXes.Where(i => i.ID == addressDB.INDEX_ID).FirstOrDefault();
var townDB = context.TOWNs.Where(t => t.ID == addressDB.TOWN_ID).FirstOrDefault();
var streetDB = context.STREETs.Where(s => s.ID == addressDB.STREET_ID).FirstOrDefault();
var buildingDB = context.BUILDINGs.Where(b => b.ID == addressDB.BUILDING_ID).FirstOrDefault();
var flatPartDB = context.FLAT_PARTs.Where(fp => fp.ID == addressDB.FLAT_PART_ID).FirstOrDefault();
CustomerType customerType = CustomerType.Get(customerTypeDB);
var index = new Index()
{
Id = indexDB.ID, Value = indexDB.VALUE
};
var town = new Town()
{
Id = townDB.ID, Name = townDB.NAME
};
var street = new Street()
{
Id = streetDB.ID, Name = streetDB.NAME
};
var building = new Building()
{
Id = buildingDB.ID, Number = buildingDB.NUMBER
};
FlatPart flatPart = null;
if (flatPartDB != null)
{
flatPart = FlatPart.Get(flatPartDB);
}
var address = new Address()
{
Id = addressDB.ID, Index = index, Town = town, Street = street, Building = building, FlatPart = flatPart
};
var accountDB = context.ACCOUNTs.Where(a => a.ID == c.ACCOUNT_ID).FirstOrDefault();
Account account = Account.Get(accountDB);
customers.Add(new Customer()
{
Id = c.ID, Account = account, Surname = c.SURNAME, Name = c.NAME, Email = c.EMAIL, Phone = c.PHONE, CustomerType = customerType, Address = address
});
}
}
public void GetMeterDataForChart(int meterId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
List <MeterItem> meterItems = new List <MeterItem>();
DateTime presDate = DateTime.Today;
DateTime startDate = new DateTime();
DateTime finishDate = new DateTime();
int startDay = 1;
int presYear = presDate.Year;
int presMonth = presDate.Month;
int prevYear = presYear - 1;
int prevMonth = presMonth - 1;
int nextMonth = presMonth + 1;
float valueDifference;
string monthName;
startDate = new DateTime(prevYear, nextMonth, startDay);
finishDate = new DateTime(presYear, presMonth, startDay);
meterItems = context.METER_ITEMs.Where(mi => mi.METER_ID == meterId).Select(MeterItem.GetMeterItemWithOutMeter).ToList();
if (meterItems.Count != 0)
{
for (; startDate <= finishDate; startDate = startDate.AddMonths(1))
{
var startValue = meterItems.Where(m => m.Date == startDate.AddMonths(-1)).FirstOrDefault().Value;
var finishValue = meterItems.Where(m => m.Date == startDate).FirstOrDefault().Value;
valueDifference = (float)Math.Round(finishValue - startValue, 2);
if (startDate.Month != 1)
{
Months month = (Months)(startDate.Month - 1);
monthName = HelperMethod.GetResourceNameForMonth(month.ToString()) + " " + startDate.Year;
}
else
{
Months month = Months.December;
monthName = HelperMethod.GetResourceNameForMonth(month.ToString()) + " " + startDate.AddYears(-1).Year;
}
ChartData.Add(new ChartData()
{
MonthName = monthName, Value = valueDifference
});
}
}
}
}
public List <Street> GetStreetList(int townId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
context.Configuration.ProxyCreationEnabled = false;
var streetsDB = context.STREETs.Where(s => s.TOWN_ID == townId).ToList();
List <Street> streetList = streetsDB.Select(Street.Get).ToList();
return(streetList);
}
}
internal void UpdateMeterType(MeterType meterType)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var meterTypeDB = context.METER_TYPEs.Find(meterType.Id);
meterTypeDB.NAME = meterType.Name;
meterTypeDB.UTILITY_ID = meterType.Utility.Id;
meterTypeDB.VARIFICATION_PERIOD_YEARS = meterType.VarificationPeriod;
context.SaveChanges();
}
}
public List <Building> GetBuildingList(int streetId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
context.Configuration.ProxyCreationEnabled = false;
var buildingsDB = context.BUILDINGs.Where(b => b.STREET_ID == streetId).ToList();
List <Building> buildingList = buildingsDB.Select(Building.Get).ToList();
return(buildingList);
}
}
public List <FlatPart> GetFlatPartList(int buildingId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
context.Configuration.ProxyCreationEnabled = false;
var flatPartsDB = context.FLAT_PARTs.Where(f => f.BUILDING_ID == buildingId).ToList();
List <FlatPart> flatPartList = flatPartsDB.Select(FlatPart.Get).ToList();
return(flatPartList);
}
}
public void GetMetersForFlatPart(int flatPartId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
context.Configuration.ProxyCreationEnabled = false;
var addressDB = context.ADDRESSes.Where(a => a.FLAT_PART_ID == flatPartId).FirstOrDefault();
if (addressDB != null)
{
FillMetersForModel(context, addressDB);
}
}
}
internal void UpdateMeter(Meter meter)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var meterDB = context.METERs.Find(meter.Id);
meterDB.SERIAL_NUMBER = meter.SerialNumber;
meterDB.RELEASE_DATE = meter.ReleaseDate;
meterDB.VARIFICATION_DATE = meter.VarificationDate;
meterDB.METER_TYPE_ID = meter.MeterType.Id;
context.SaveChanges();
}
}
internal Customer GetCustomerForEdit(int customerId)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var model = new Customer();
var customerDB = context.CUSTOMERs.Find(customerId);
if (customerDB != null)
{
var customerType = context.CUSTOMER_TYPEs.Where(mt => mt.ID == customerDB.CUSTOMER_TYPE_ID).Select(CustomerType.Get).FirstOrDefault();
var addressDB = context.ADDRESSes.Where(a => a.ID == customerDB.ADDRESS_ID).FirstOrDefault();
var index = context.INDEXes.Where(i => i.ID == addressDB.INDEX_ID).Select(Index.Get).FirstOrDefault();
var town = context.TOWNs.Where(t => t.ID == addressDB.TOWN_ID).Select(Town.Get).FirstOrDefault();
var street = context.STREETs.Where(s => s.ID == addressDB.STREET_ID).Select(Street.Get).FirstOrDefault();
var building = context.BUILDINGs.Where(b => b.ID == addressDB.BUILDING_ID).Select(Building.Get).FirstOrDefault();
var flatPartDB = context.FLAT_PARTs.Where(fp => fp.ID == addressDB.FLAT_PART_ID).FirstOrDefault();
var account = context.ACCOUNTs.Where(a => a.ID == customerDB.ACCOUNT_ID).Select(Account.Get).FirstOrDefault();
FlatPart flatPart = null;
if (flatPartDB != null)
{
flatPart = FlatPart.Get(flatPartDB);
}
var address = new Address()
{
Id = addressDB.ID, Index = index, Town = town, Street = street, Building = building, FlatPart = flatPart
};
model.Id = customerDB.ID;
model.Account = account;
model.Surname = customerDB.SURNAME;
model.Name = customerDB.NAME;
model.Email = customerDB.EMAIL;
model.Phone = customerDB.PHONE;
model.CustomerType = customerType;
model.Address = address;
model.CustomerTypes = context.CUSTOMER_TYPEs.Select(CustomerType.Get).ToList();
}
else
{
model = null;
}
return(model);
}
}
public void GetUtilitiesName()
{
using (var context = new TownUtilityBillSystemV2Entities())
{
var utilitiesDB = context.UTILITYs.ToList();
foreach (var item in utilitiesDB)
{
Utilities.Add(new Utility {
Id = item.ID, Name = item.NAME, ResourceName = GetResourceNameForUtility(item.NAME)
});
}
}
}
