public async Task <bool> CreateOwner(CreateOwnerDTO dto)
{
if (await LoginExist(dto.Login))
{
return(false);
}
Guid id = Guid.NewGuid();
Role ownerrole = await GetRole("Owner");
var ownerId = await ownerService.Create(new OwnerDTO
{
FirstName = dto.FirstName,
LastName = dto.LastName,
MiddlleName = dto.MiddlleName,
Status = dto.Status,
});
using (MUEContext db = new MUEContext())
{
User user = new User
{
Login = dto.Login,
UserId = id,
RoleId = ownerrole.RoleId,
HashPassword = HashPassword(dto.Password),
OwnerId = ownerId
};
db.Users.Add(user);
await db.SaveChangesAsync();
}
return(true);
}
public async Task CreateFlat(CreateFlatDTO dto)
{
Guid id = Guid.NewGuid();
var streetId = (await GetStreetEntity(dto.Street)).StreetId;
Building building = await GetBuildingEntity(dto.Building, streetId);
if (building == null)
{
await CreateBuilding(new BuildingDTO { Number = dto.Building }, streetId);
}
building = await GetBuildingEntity(dto.Building, streetId);
var DontCreate = await Exist(building.BuildingId, dto.Number);
if (DontCreate != Guid.Empty)
{
return;
}
using (MUEContext db = new MUEContext())
{
Flat flat = new Flat {
Square = dto.Square,
Rooms = dto.Rooms,
CountResidents = dto.CountResidents,
FlatId = id,
Number = dto.Number,
BuildingId = building.BuildingId
};
db.Flats.Add(flat);
await db.SaveChangesAsync();
}
}
public async Task Create(MeterReadingDTO dto)
{
//var flats = await buildingService.GetFlatDTO(dto.FlatId);
//var period = await periodService.GetPeriodDTO(dto.PeriodId);
Guid id = Guid.NewGuid();
using (MUEContext db = new MUEContext())
{
var mr = await GetEntity(dto.FlatId, dto.PeriodId, dto.TypeofServiceId);
if (mr != null)
{
await Delete(mr.MeterReadingId);
}
MeterReading meterReading = new MeterReading {
FlatId = dto.FlatId,
MeterReadingId = id,
PeriodId = dto.PeriodId,
TypeofServiceId = dto.TypeofServiceId,
Value = dto.Value,
};
db.MeterReadings.Add(meterReading);
await db.SaveChangesAsync();
}
}
public async Task DeleteStreet(Guid id)
{
using (MUEContext db = new MUEContext())
{
Street street = await GetStreetEntity(id);
db.Entry(street).State = EntityState.Deleted;
db.Streets.Remove(street);
await db.SaveChangesAsync();
}
}
public async Task DeleteFlat(Guid id)
{
using (MUEContext db = new MUEContext())
{
Flat flat = await GetFlatEntity(id);
db.Entry(flat).State = EntityState.Deleted;
db.Flats.Remove(flat);
await db.SaveChangesAsync();
}
}
public async Task Delete(Guid id)
{
using (MUEContext db = new MUEContext())
{
SettlementSheet SettlementSheet = await GetEntity(id);
db.Entry(SettlementSheet).State = EntityState.Deleted;
db.SettlementSheets.Remove(SettlementSheet);
await db.SaveChangesAsync();
}
}
public async Task DeletePeriod(Guid id)
{
using (MUEContext db = new MUEContext())
{
Period period = await GetPeriodEntity(id);
db.Entry(period).State = EntityState.Deleted;
db.Periods.Remove(period);
await db.SaveChangesAsync();
}
}
public async Task Delete(Guid id)
{
using (MUEContext db = new MUEContext())
{
ServiceBill ServiceBill = await GetEntity(id);
db.Entry(ServiceBill).State = EntityState.Deleted;
db.ServiceBills.Remove(ServiceBill);
await db.SaveChangesAsync();
}
}
public async Task Delete(Guid id)
{
using (MUEContext db = new MUEContext())
{
var mr = await GetEntity(id);
db.Entry(mr).State = EntityState.Deleted;
db.MeterReadings.Remove(mr);
await db.SaveChangesAsync();
}
}
public async Task DeleteTariff(Guid id)
{
using (MUEContext db = new MUEContext())
{
Tariff tariff = await GetTariffEntity(id);
db.Entry(tariff).State = EntityState.Deleted;
db.Tariffs.Remove(tariff);
await db.SaveChangesAsync();
}
}
public async Task Delete(Guid id)
{
using (MUEContext db = new MUEContext())
{
Owner owner = await GetEntity(id);
db.Entry(owner).State = EntityState.Deleted;
db.Owners.Remove(owner);
await db.SaveChangesAsync();
}
}
public async Task DeleteBuilding(Guid id)
{
using (MUEContext db = new MUEContext())
{
Building building = await GetBuildingEntity(id);
db.Entry(building).State = EntityState.Deleted;
db.Buildings.Remove(building);
await db.SaveChangesAsync();
}
}
public async Task DeleteTypeOfService(Guid id)
{
using (MUEContext db = new MUEContext())
{
TypeOfService typeOfService = await GetTypeOfServiceEntity(id);
db.Entry(typeOfService).State = EntityState.Deleted;
db.TypeOfServices.Remove(typeOfService);
await db.SaveChangesAsync();
}
}
public async Task SetCurrent(Guid id, bool Current)
{
var periodentity = await GetPeriodEntity(id);
using (MUEContext db = new MUEContext())
{
periodentity.IsCurrent = Current;
db.Entry(periodentity).State = EntityState.Modified;
await db.SaveChangesAsync();
}
}
public async Task SetFlatOwner(Guid FlatId, Guid?OwnerId)
{
using (MUEContext db = new MUEContext())
{
Flat flat = await GetFlatEntity(FlatId);
flat.OwnersId = OwnerId;
db.Entry(flat).State = EntityState.Modified;
await db.SaveChangesAsync();
}
}
public async Task Update(OwnerDTO dto)
{
var owner = await GetEntity(dto.OwnerId);
using (MUEContext db = new MUEContext())
{
owner.FirstName = dto.FirstName;
owner.LastName = dto.LastName;
owner.MiddlleName = dto.MiddlleName;
owner.Status = dto.Status;
db.Entry(owner).State = EntityState.Modified;
await db.SaveChangesAsync();
}
}
public async Task CreateStreet(StreetDTO dto)
{
Guid id = Guid.NewGuid();
using (MUEContext db = new MUEContext())
{
Street street = new Street {
StreetId = id,
Name = dto.Name,
Description = dto.Description
};
db.Streets.Add(street);
await db.SaveChangesAsync();
}
}
public async Task CreateBuilding(BuildingDTO dto, Guid StreetId)
{
Guid id = Guid.NewGuid();
using (MUEContext db = new MUEContext())
{
Building building = new Building
{
BuildingId = id,
Description = dto.Description,
Number = dto.Number,
StreetId = StreetId
};
db.Buildings.Add(building);
await db.SaveChangesAsync();
}
}
public async Task CreateTariff(TariffDTO dto)
{
Guid id = Guid.NewGuid();
using (MUEContext db = new MUEContext())
{
Tariff tariff = new Tariff
{
Value = dto.Value,
TypeOfServiceId = dto.TypeOfServiceId,
TariffId = id,
FlatId = dto.FlatId
};
db.Tariffs.Add(tariff);
await db.SaveChangesAsync();
}
}
public async Task CreateTypeOfService(TypeOfServiceDTO dto)
{
Guid id = Guid.NewGuid();
using (MUEContext db = new MUEContext())
{
TypeOfService typeOfService = new TypeOfService
{
Name = dto.Name,
Description = dto.Description,
IsMeter = dto.IsMeter,
UnitOfMeasurment = dto.UnitOfMeasurment,
TypeOfServiceId = id
};
db.TypeOfServices.Add(typeOfService);
await db.SaveChangesAsync();
}
}
public async Task CreateBuilding(BuildingDTO dto)
{
Guid id = Guid.NewGuid();
Guid streetId = (await GetStreetEntity(dto.StreetName)).StreetId;
using (MUEContext db = new MUEContext())
{
Building building = new Building
{
BuildingId = id,
Description = dto.Description,
Number = dto.Number,
StreetId = streetId
};
db.Buildings.Add(building);
await db.SaveChangesAsync();
}
}
public async Task CreatePeriod(PeriodDTO dto)
{
Guid id = Guid.NewGuid();
using (MUEContext db = new MUEContext())
{
//TODO: AutoName - low priority
Period period = new Period
{
StartDate = dto.StartDate,
EndDate = dto.EndDate,
IsCurrent = dto.IsCurrent,
Name = dto.Name,
PeriodId = id
};
db.Periods.Add(period);
await db.SaveChangesAsync();
}
}
public async Task <Guid> Create(OwnerDTO dto)
{
Guid id = Guid.NewGuid();
using (MUEContext db = new MUEContext())
{
Owner owner = new Owner
{
FirstName = dto.FirstName,
LastName = dto.LastName,
MiddlleName = dto.MiddlleName,
OwnerId = id,
Status = dto.Status
};
db.Owners.Add(owner);
await db.SaveChangesAsync();
return(id);
}
}
public async Task Create(SettlementSheetDTO dto)
{
Guid id = Guid.NewGuid();
var ReCreate = await Exist(dto.FlatId, dto.PeriodId);
if (ReCreate != Guid.Empty)
{
await Delete(ReCreate);
}
using (MUEContext db = new MUEContext())
{
db.SettlementSheets.Add(new SettlementSheet {
SettlementSheetId = id,
FlatId = dto.FlatId,
PeriodId = dto.PeriodId,
AmmountToBePaid = dto.AmmountToBePaid,
Description = dto.Description,
Status = 0,
});
await db.SaveChangesAsync();
}
}
public async Task <bool> Register(CreateUserDTO dto)
{
if (await LoginExist(dto.Login))
{
return(false);
}
Guid id = Guid.NewGuid();
Role defaultrole = await GetRole("Default");
using (MUEContext db = new MUEContext())
{
User user = new User {
Login = dto.Login,
UserId = id,
RoleId = defaultrole.RoleId,
HashPassword = HashPassword(dto.Password)
};
db.Users.Add(user);
await db.SaveChangesAsync();
}
return(true);
}
public async Task Create(ServiceBillDTO dto)
{
Guid id = Guid.NewGuid();
var ReCreate = await Exist(dto);
if (ReCreate != Guid.Empty)
{
await Delete(ReCreate);
}
using (MUEContext db = new MUEContext())
{
ServiceBill serviceBill = new ServiceBill {
ServiceBillId = id,
Status = 0,
FlatId = dto.FlatId,
PeriodId = dto.PeriodId,
TypeOfServiceId = dto.TypeOfServiceId,
Summ = dto.Summ
};
db.ServiceBills.Add(serviceBill);
await db.SaveChangesAsync();
}
}
