public bool Unit_Add([FromBody] UnitAdd request)
{
return(_unitService.UnitAdd(request));
}
public static async void LoadSampleData()
{
Manager m = new Controllers.Manager();
if (m.UnitGetAll().Count() == 0)
{
var unit = new UnitAdd();
unit.Bedrooms = 2;
unit.Bathrooms = 1;
unit.SquareFeet = 100.5;
unit.MaxOccupants = 3;
unit.Balcony = true;
unit.Dishwasher = true;
unit.Laundry = false;
m.UnitAdd(unit);
unit.Bedrooms = 1;
unit.Bathrooms = 1;
unit.SquareFeet = 87.5;
unit.MaxOccupants = 2;
unit.Balcony = true;
unit.Dishwasher = false;
unit.Laundry = false;
m.UnitAdd(unit);
unit.Bedrooms = 3;
unit.Bathrooms = 2;
unit.SquareFeet = 130.0;
unit.MaxOccupants = 5;
unit.Balcony = true;
unit.Dishwasher = true;
unit.Laundry = true;
m.UnitAdd(unit);
}
if (m.ApartmentGetAll().Count() == 0)
{
var apt = new ApartmentAdd();
apt.ApartmentNumber = 520;
apt.FloorNumber = 5;
apt.Status = "Occupied";
apt.UnitId = 1;
m.ApartmentAdd(apt);
apt.ApartmentNumber = 603;
apt.FloorNumber = 6;
apt.Status = "Occupied";
apt.UnitId = 2;
m.ApartmentAdd(apt);
apt.ApartmentNumber = 1705;
apt.FloorNumber = 17;
apt.Status = "Occupied";
apt.UnitId = 3;
m.ApartmentAdd(apt);
}
if (m.TenantGetAll().Count() == 0)
{
var tenant = new TenantAdd();
tenant.FirstName = "Amanda";
tenant.LastName = "Marques";
tenant.MobilePhone = "647-535-7732";
tenant.HomePhone = "";
tenant.Email = "*****@*****.**";
tenant.BirthDate = new DateTime(1988, 12, 23);
m.TenantAdd(tenant);
tenant.FirstName = "Jonathan";
tenant.LastName = "Desmond";
tenant.MobilePhone = "536-85-96415";
tenant.HomePhone = "365-459-8752";
tenant.Email = "*****@*****.**";
tenant.BirthDate = new DateTime(1990, 10, 18);
m.TenantAdd(tenant);
tenant.FirstName = "Carlos";
tenant.LastName = "Wellinton";
tenant.MobilePhone = "963-125-4789";
tenant.HomePhone = "964-585-3658";
tenant.Email = "*****@*****.**";
tenant.BirthDate = new DateTime(1994, 09, 21);
m.TenantAdd(tenant);
}
if (m.LeaseGetAllWithInformation().Count() == 0)
{
var lease = new LeaseAdd();
lease.StartDate = new DateTime(2016, 01, 01);
lease.EndDate = new DateTime(2018, 01, 01);
lease.SecurityDeposit = 500.00;
lease.MonthlyRent = 1050.60;
lease.ApartmentNumber = 520;
lease.TenantId = 1;
m.LeaseAdd(lease);
lease.StartDate = new DateTime(2017, 08, 20);
lease.EndDate = new DateTime(2018, 08, 19);
lease.SecurityDeposit = 430.00;
lease.MonthlyRent = 1200.50;
lease.ApartmentNumber = 603;
lease.TenantId = 2;
m.LeaseAdd(lease);
lease.StartDate = new DateTime(2016, 04, 01);
lease.EndDate = new DateTime(2017, 04, 01);
lease.SecurityDeposit = 525.00;
lease.MonthlyRent = 1400.80;
lease.ApartmentNumber = 1705;
lease.TenantId = 3;
m.LeaseAdd(lease);
var user = new ApplicationUser
{
UserName = "******",
Email = "*****@*****.**",
GivenName = "Amanda",
Surname = "Marques",
Role = "Tenant"
};
var ds = new ApplicationDbContext();
var userManager = new ApplicationUserManager(new UserStore <ApplicationUser>(ds));
var result = await userManager.CreateAsync(user, "Asdf4321!");
if (result.Succeeded)
{
// Add claims
await userManager.AddClaimAsync(user.Id, new Claim(ClaimTypes.Role, "Tenant"));
}
}
if (m.EmployeeGetAll().Count() == 0)
{
var employee = new EmployeeAdd();
employee.LastName = "Marques";
employee.FirstName = "Amanda";
employee.Title = "Supervisor";
employee.BirthDate = new DateTime(1988, 12, 23);
employee.HireDate = new DateTime(2017, 02, 06);
employee.Address = "Wellesley St";
employee.City = "Toronto";
employee.State = "ON";
employee.Country = "Canada";
employee.PostalCode = "M4X-1G5";
employee.Email = "*****@*****.**";
employee.Phone = "647-589-5357";
m.EmployeeAdd(employee);
employee.LastName = "Desmond";
employee.FirstName = "Jonathan";
employee.Title = "Manager";
employee.BirthDate = new DateTime(1990, 11, 16);
employee.HireDate = new DateTime(2017, 01, 05);
employee.Address = "Pond Rd";
employee.City = "Toronto";
employee.State = "ON";
employee.Country = "Canada";
employee.PostalCode = "M6H 1Y7";
employee.Email = "*****@*****.**";
employee.Phone = "647-896-5236";
m.EmployeeAdd(employee);
employee.LastName = "Capello";
employee.FirstName = "Silvia";
employee.Title = "Clerk";
employee.BirthDate = new DateTime(1958, 01, 09);
employee.HireDate = new DateTime(2016, 04, 28);
employee.Address = "Aluisio St";
employee.City = "Toronto";
employee.State = "ON";
employee.Country = "Canada";
employee.PostalCode = "J7G 1S3";
employee.Email = "*****@*****.**";
employee.Phone = "647-652-3105";
m.EmployeeAdd(employee);
}
if (m.AnnouncementGetAll().Count() == 0)
{
var announce = new AnnouncementAdd();
announce.Title = "Laundry closed";
announce.StartDate = new DateTime(2017, 05, 05);
announce.ExpireDate = new DateTime(2017, 05, 06);
announce.Description = "The laundry room will be closed for maintenance";
m.AnnouncementAdd(announce);
announce.Title = "Cleaning of corridor";
announce.StartDate = new DateTime(2017, 04, 20);
announce.ExpireDate = new DateTime(2017, 04, 22);
announce.Description = "The carpet will be cleaned on the upcoming weekend";
m.AnnouncementAdd(announce);
announce.Title = "New Recycle Bins";
announce.StartDate = new DateTime(2017, 03, 10);
announce.ExpireDate = new DateTime(2017, 03, 11);
announce.Description = "The apartments will be receiving new recycle bins starting next week";
m.AnnouncementAdd(announce);
}
if (m.FacilityGetAll().Count() == 0)
{
var facility = new FacilityAdd();
facility.FacilityName = "Pool";
facility.Description = "Open Pool";
facility.Location = "40th floor";
facility.Status = "Open";
facility.OpenTime = new DateTime(2017, 01, 01, 08, 0, 0);
facility.CloseTime = new DateTime(2017, 02, 01, 18, 0, 0);
m.FacilityAdd(facility);
facility.FacilityName = "Movie Room";
facility.Description = "Movie Theater";
facility.Location = "Lobby";
facility.Status = "Open";
facility.OpenTime = new DateTime(2017, 02, 01, 10, 0, 0);
facility.CloseTime = new DateTime(2017, 02, 01, 20, 30, 0);
m.FacilityAdd(facility);
}
if (m.InventoryGetAll().Count() == 0)
{
var inventory = new InventoryAdd();
inventory.ProductName = "Cleaning";
inventory.Supplier = "Lisol";
inventory.Quantity = 20;
m.InventoryAdd(inventory);
inventory.ProductName = "Garbage Bag";
inventory.Supplier = "My Garbages";
inventory.Quantity = 100;
m.InventoryAdd(inventory);
inventory.ProductName = "Window cleaning";
inventory.Supplier = "Windex";
inventory.Quantity = 87;
m.InventoryAdd(inventory);
}
if (m.ServiceGetAll().Count() == 0)
{
var service = new ServiceAdd();
service.ServiceName = "Gardening";
service.CompanyName = "Gardening Express";
service.PhoneNumber = "416-547-8963";
service.Email = "*****@*****.**";
service.Address = "346 Allen Rd";
m.ServiceAdd(service);
service.ServiceName = "Pest Control";
service.CompanyName = "Pest Rock";
service.PhoneNumber = "647-514-8965";
service.Email = "*****@*****.**";
service.Address = "1549 Dufferin St";
m.ServiceAdd(service);
service.ServiceName = "Cleaning";
service.CompanyName = "Nice Cleaning";
service.PhoneNumber = "907-534-8698";
service.Email = "*****@*****.**";
service.Address = "15 Bloor St";
m.ServiceAdd(service);
}
if (m.WorkOrderGetAll().Count() == 0)
{
var workOrder = new WorkOrderAdd();
workOrder.Description = "Fixing light bulb";
workOrder.Notes = "In the living room";
workOrder.RequestDate = new DateTime(2017, 02, 26);
workOrder.TenantId = 1;
m.WorkOrderAdd(workOrder);
workOrder.Description = "Kill bugs";
workOrder.Notes = "Many bugs in the house";
workOrder.RequestDate = new DateTime(2017, 04, 05);
workOrder.TenantId = 2;
m.WorkOrderAdd(workOrder);
workOrder.Description = "Leaking in the kitchen";
workOrder.Notes = "My sink is full of water";
workOrder.RequestDate = new DateTime(2017, 05, 22);
workOrder.TenantId = 3;
m.WorkOrderAdd(workOrder);
}
if (m.ServiceRequestGetAll().Count() == 0)
{
var request = new ServiceRequestAdd();
request.Description = "Monthly Cleaning";
request.RequestDate = new DateTime(2017, 03, 01);
request.ServiceId = 3;
m.ServiceRequestAdd(request);
request.Description = "Doing gardening";
request.RequestDate = new DateTime(2016, 05, 05);
request.ServiceId = 1;
m.ServiceRequestAdd(request);
request.Description = "Building Pest Control";
request.RequestDate = new DateTime(2017, 04, 23);
request.ServiceId = 2;
m.ServiceRequestAdd(request);
}
if (m.FacilityBookingGetAllWithFacility().Count() == 0)
{
var booking = new FacilityBookingAdd();
booking.BookedDate = new DateTime(2017, 05, 22);
booking.StartTime = new DateTime(2017, 05, 22, 10, 30, 0);
booking.EndTime = new DateTime(2017, 05, 22, 17, 0, 0);
booking.TenantId = 1;
booking.FacilityId = 1;
booking.Notes = "No Notes";
m.FacilityBookingAdd(booking);
booking.BookedDate = new DateTime(2017, 10, 01);
booking.StartTime = new DateTime(2017, 10, 01, 13, 0, 0);
booking.EndTime = new DateTime(2017, 10, 01, 14, 45, 0);
booking.TenantId = 2;
booking.FacilityId = 2;
booking.Notes = "";
m.FacilityBookingAdd(booking);
booking.BookedDate = new DateTime(2017, 10, 01);
booking.StartTime = new DateTime(2017, 10, 01, 15, 0, 0);
booking.EndTime = new DateTime(2017, 10, 01, 18, 0, 0);
booking.TenantId = 3;
booking.FacilityId = 2;
booking.Notes = "";
m.FacilityBookingAdd(booking);
booking.BookedDate = new DateTime(2017, 04, 05);
booking.StartTime = new DateTime(2017, 04, 05, 10, 0, 0);
booking.EndTime = new DateTime(2017, 04, 05, 13, 10, 0);
booking.TenantId = 1;
booking.FacilityId = 2;
booking.Notes = "";
m.FacilityBookingAdd(booking);
}
if (m.OccupantGetAll().Count() == 0)
{
var occupant = new OccupantAdd();
occupant.FirstName = "Silvia";
occupant.LastName = "Capello";
occupant.MobilePhone = "647-415-8957";
occupant.WorkPhone = "416-548-9569";
occupant.Email = "*****@*****.**";
occupant.BirthDate = new DateTime(1958, 01, 09);
occupant.ApartmentNumber = 520;
occupant.TenantId = 1;
m.OccupantAdd(occupant);
occupant.FirstName = "Renan";
occupant.LastName = "Marques";
occupant.MobilePhone = "647-485-9874";
occupant.WorkPhone = "416-123-5647";
occupant.Email = "*****@*****.**";
occupant.BirthDate = new DateTime(1990, 07, 02);
occupant.ApartmentNumber = 520;
occupant.TenantId = 1;
m.OccupantAdd(occupant);
occupant.FirstName = "Jennifer";
occupant.LastName = "Aniston";
occupant.MobilePhone = "905-452-7415";
occupant.WorkPhone = "416-987-4256";
occupant.Email = "*****@*****.**";
occupant.BirthDate = new DateTime(1992, 03, 20);
occupant.ApartmentNumber = 603;
occupant.TenantId = 2;
m.OccupantAdd(occupant);
occupant.FirstName = "Mayra";
occupant.LastName = "Borne";
occupant.MobilePhone = "905-471-3589";
occupant.WorkPhone = "416-416-8526";
occupant.Email = "*****@*****.**";
occupant.BirthDate = new DateTime(2000, 05, 21);
occupant.ApartmentNumber = 603;
occupant.TenantId = 2;
m.OccupantAdd(occupant);
occupant.FirstName = "Tania";
occupant.LastName = "Wellinton";
occupant.MobilePhone = "905-965-7854";
occupant.WorkPhone = "364-654-5984";
occupant.Email = "*****@*****.**";
occupant.BirthDate = new DateTime(1960, 03, 27);
occupant.ApartmentNumber = 1705;
occupant.TenantId = 3;
m.OccupantAdd(occupant);
}
}
public ResSubmit ChinhSuaUnit(UnitAdd unitEdit)
{
tongcuclamnghiepEntities tongcuclamnghiep = new tongcuclamnghiepEntities();
ResSubmit resSubmit = new ResSubmit(true, "Cập nhật thành công");
var _Unit = tongcuclamnghiep.m_unit.Where(a => a.id == unitEdit.id).FirstOrDefault();
if (_Unit == null)
{
resSubmit = new ResSubmit(false, "Không tồn tại đơn vị này");
}
if (resSubmit.success && !(unitEdit.unitname.Length >= 10 && unitEdit.unitname.Length <= 4000))
{
resSubmit = new ResSubmit(false, "Tên đơn vị không hợp lệ");
}
if (resSubmit.success && tongcuclamnghiep.m_unit.Any(a => a.id != unitEdit.id && a.unitname == unitEdit.unitname))
{
resSubmit = new ResSubmit(false, "Tên đơn vị đã tồn tại");
}
if (resSubmit.success)
{
_Unit.address = unitEdit.address;
_Unit.status = unitEdit.status;
_Unit.unitname = unitEdit.unitname;
_Unit.dientich1 = (unitEdit.dientich1 != null ? unitEdit.dientich1 : 0);
_Unit.dientich2 = (unitEdit.dientich2 != null ? unitEdit.dientich2 : 0);
_Unit.ngansachnhannuoc1 = (unitEdit.ngansachnhannuoc1 != null ? unitEdit.ngansachnhannuoc1 : 0);
_Unit.ngansachnhanuoc2 = (unitEdit.ngansachnhanuoc2 != null ? unitEdit.ngansachnhanuoc2 : 0);
_Unit.ngaythanhlap = unitEdit.ngaythanhlap;
_Unit.tongcanbo1 = (unitEdit.tongcanbo1 != null ? unitEdit.tongcanbo1 : 0);
_Unit.tongcanbo2 = (unitEdit.tongcanbo2 != null ? unitEdit.tongcanbo2 : 0);
tongcuclamnghiep.SaveChanges();
int version = 1;
var _UnitVS = tongcuclamnghiep.m_unitversion.Where(a => a.unit_id == _Unit.id && a.status == true).FirstOrDefault();
if (_UnitVS != null)
{
version = _UnitVS.version.Value + 1;
}
m_unitversion _Unitversion = new m_unitversion();
_Unitversion.createdate = DateTime.Now;
_Unitversion.datatext = unitEdit.UnitVersionText;
_Unitversion.unit_id = _Unit.id;
_Unitversion.status = true;
_Unitversion.version = version;
_Unitversion.dientich1 = _Unit.dientich1;
_Unitversion.dientich2 = _Unit.dientich2;
_Unitversion.ngansachnhannuoc1 = _Unit.ngansachnhannuoc1;
_Unitversion.ngansachnhanuoc2 = _Unit.ngansachnhanuoc2;
_Unitversion.ngaythanhlap = _Unit.ngaythanhlap;
_Unitversion.tongcanbo1 = _Unit.tongcanbo1;
_Unitversion.tongcanbo2 = _Unit.tongcanbo2;
tongcuclamnghiep.m_unitversion.Add(_Unitversion);
if (tongcuclamnghiep.SaveChanges() == 1)
{
tongcuclamnghiep.m_unitversion.Where(a => a.unit_id == _Unit.id && a.status == true && a.id != _Unitversion.id).ToList().All(a => {
a.status = false;
return(true);
});
tongcuclamnghiep.SaveChanges();
}
}
return(resSubmit);
}
