public bool SetAdress(AdressModel adressModel)
{
var database = new DatabaseContextEngine();
var adress = database.Adresses.FirstOrDefault(x => x.City == adressModel.City &&
x.Apartement == adressModel.Apartement &&
x.House == adressModel.House &&
x.Street == adressModel.Street);
if (adress == null)
{
return(false);
}
int deliverID = -1;
var delivers = database.Transactions.GroupBy(x => x.DeliveryMan).Where(x => x.Key != null);
if (delivers.Count() == 0)
{
deliverID = database.Users.FirstOrDefault(x => x.UserType == UserType.Delivery).ID;
}
else
{
deliverID = delivers.OrderBy(x => x.Count()).First().Key.ID;
}
var transaction = database.Transactions.Find(adressModel.Transaction);
transaction.Adress = adress;
transaction.TimeDelivery = DateTime.Now.AddDays(adress.Days);
transaction.IsClose = true;
transaction.DeliveryMan = database.Users.Find(deliverID);
database.Update(transaction);
database.SaveChanges();
return(true);
}
public ActionResult DeleteConfirmed(int id)
{
AdressModel adressModel = db.adresy.Find(id);
db.adresy.Remove(adressModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID_adress,City,ZipCode,Street,BuildingNo,FlatNo")] AdressModel adressModel)
{
if (ModelState.IsValid)
{
db.Entry(adressModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adressModel));
}
public void Init()
{
IdentificatorModel = new IdentificatorModel(this, _idControl);
NameModel = new NameModel(this);
RelationshipModel = GetRelationshipModel2(Model, new FamilyModel(this));
RegstatusModel = new RegstatusModel(this);
AdressModel = new AdressModel(this);
SivilstatusModel = new SivilstatusModel(this);
_randomizer = new Randomizer();
}
public ActionResult Create([Bind(Include = "ID_adress,City,ZipCode,Street,BuildingNo,FlatNo")] AdressModel adressModel)
{
if (ModelState.IsValid)
{
db.adresy.Add(adressModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adressModel));
}
private void btSave_Click(object sender, EventArgs e)
{
AdressModel adressModel = new AdressModel
{
StreetAdress = tbStreetAdress.Text,
City = tbCity.Text,
State = tbState.Text,
ZipCode = tbZipCode.Text
};
_parent.SaveAdress(adressModel);
this.Close();
}
// GET: AdressModels/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AdressModel adressModel = db.adresy.Find(id);
if (adressModel == null)
{
return(HttpNotFound());
}
return(View(adressModel));
}
public IActionResult Adress(AdressModel adressModel)
{
if (ModelState.IsValid)
{
ShopEngine.ShopEngineService shopEngineService = new ShopEngine.ShopEngineService();
var result = shopEngineService.SetAdress(adressModel);
if (!result)
{
ViewBag.Error = "Incorrect adress";
return(View(adressModel));
}
return(RedirectToAction("Index", "Home"));
}
return(View(adressModel));
}
public static async Task Initialize(ApplicationDbContext context, UserManager <AppUser> usermanager, RoleManager <IdentityRole> rolemanager)
{
//context.Database.EnsureCreated();
string[] roleNames = { "Admin", "Manager", "Dispatcher" };
context.Database.Migrate();
context.Database.EnsureCreated();
foreach (var roleName in roleNames)
{
var roleExist = await rolemanager.RoleExistsAsync(roleName);
if (!roleExist)
{
//create the roles and seed them to the database: Question 1
await rolemanager.CreateAsync(new IdentityRole(roleName));
}
}
/* -- Админ -- */
var admin = await usermanager.FindByNameAsync("admin");
if (admin == null)
{
var _admin = new AppUser
{
UserName = "******",
Email = "*****@*****.**",
FirstName = "admin",
LastName = ""
};
var result = await usermanager.CreateAsync(_admin, "1234567890");
if (result.Succeeded)
{
await usermanager.AddToRoleAsync(_admin, "Admin");
await usermanager.AddToRoleAsync(_admin, "Manager");
}
}
else
{
if (!await usermanager.IsInRoleAsync(admin, "Admin"))
{
await usermanager.AddToRoleAsync(admin, "Admin");
}
if (!await usermanager.IsInRoleAsync(admin, "Manager"))
{
await usermanager.AddToRoleAsync(admin, "Manager");
}
}
/* -- Менеджер -- */
var manager = await usermanager.FindByNameAsync("manager");
if (manager == null)
{
var _manager = new AppUser
{
UserName = "******",
Email = "*****@*****.**",
FirstName = "manager",
LastName = ""
};
var result = await usermanager.CreateAsync(_manager, "1234567891");
if (result.Succeeded)
{
await usermanager.AddToRoleAsync(_manager, "Manager");
}
}
else
{
if (!await usermanager.IsInRoleAsync(manager, "Manager"))
{
await usermanager.AddToRoleAsync(manager, "Manager");
}
}
/* -- Диспетчер -- */
var dispatcher = await usermanager.FindByNameAsync("dispatcher");
if (dispatcher == null)
{
var _dispatcher = new AppUser
{
UserName = "******",
Email = "*****@*****.**",
FirstName = "dispatcher",
LastName = ""
};
var result = await usermanager.CreateAsync(_dispatcher, "1234567892");
if (result.Succeeded)
{
await usermanager.AddToRoleAsync(_dispatcher, "Dispatcher");
}
}
else
{
if (!await usermanager.IsInRoleAsync(dispatcher, "Dispatcher"))
{
await usermanager.AddToRoleAsync(dispatcher, "Dispatcher");
}
}
if (!context.Companies.Any())
{
/* -- Компании -- */
context.Companies.Add(new CompanyModel
{
Name = "ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ 'Управляющая компания 'ПОЛЁТ''",
ShortName = "Управляющая компания 'ПОЛЁТ'",
Phone = "8 (903) 147-35-97",
LegalAddress = "142407, Московская область, город Ногинск, улица Аэроклубная, д.15",
ActualAddress = "142407, Московская область, город Ногинск, улица Дмитрия Михайлова, дом 1 ",
MailingAddress = "142407, Московская область, город Ногинск, улица Дмитрия Михайлова, дом 1 ",
OGRN = "1155031003269",
INN = "5031116124",
KPP = "503101001",
Description = "Тест 1",
});
context.Companies.Add(new CompanyModel
{
Name = "ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ 'ТЕПЛОВОДОСЕРВИС'",
ShortName = "ООО 'ТВС'",
Phone = "8 (496) 514-14-94",
LegalAddress = "142400, Россия, МО, г.Ногинск, ул.Рабочая, д.142",
ActualAddress = "142400, Россия, МО, г.Ногинск, ул.Рабочая, д.142",
MailingAddress = "142400, Россия, МО, г.Ногинск, ул.Рабочая, д.142",
OGRN = "1055005902115",
INN = "5031060930",
KPP = "503101001",
Description = "Тест 2",
});
context.SaveChanges();
}
/* -- Регионы -- */
Region region1 = null;
Region region2 = null;
if (!context.Regions.Any())
{
var r1 = context.Regions.Add(new Region {
Name = "Ногинский район"
});
var r2 = context.Regions.Add(new Region {
Name = "Раменкий район"
});
context.SaveChanges();
region1 = r1.Entity;
region2 = r2.Entity;
}
/* -- Города -- */
City city1 = null;
City city2 = null;
City city3 = null;
City city4 = null;
if (!context.Cities.Any())
{
var c1 = context.Cities.Add(new City {
Name = "Ногинск", RegionId = region1.Id
});
var c2 = context.Cities.Add(new City {
Name = "Старая Купавна", RegionId = region1.Id
});
var c3 = context.Cities.Add(new City {
Name = "Электроугли", RegionId = region1.Id
});
var c4 = context.Cities.Add(new City {
Name = "Кратово", RegionId = region2.Id
});
context.SaveChanges();
city1 = c1.Entity;
city2 = c2.Entity;
city3 = c3.Entity;
city4 = c4.Entity;
}
/* -- Улицы -- */
Street street1 = null;
Street street2 = null;
Street street3 = null;
Street street4 = null;
Street street5 = null;
Street street6 = null;
if (!context.Streets.Any())
{
var s1 = context.Streets.Add(new Street {
Name = "Дмитрия Михайлова", CityId = city1.Id
});
var s2 = context.Streets.Add(new Street {
Name = "Климова", CityId = city1.Id
});
var s3 = context.Streets.Add(new Street {
Name = "Тестилей", CityId = city1.Id
});
var s4 = context.Streets.Add(new Street {
Name = "Советской конституции", CityId = city1.Id
});
var s5 = context.Streets.Add(new Street {
Name = "Матросова", CityId = city2.Id
});
var s6 = context.Streets.Add(new Street {
Name = "Школьная", CityId = city3.Id
});
context.SaveChanges();
street1 = s1.Entity;
street2 = s2.Entity;
street3 = s3.Entity;
street4 = s4.Entity;
street5 = s5.Entity;
street6 = s6.Entity;
}
/* -- Дома -- */
House house1 = null;
House house2 = null;
House house3 = null;
House house4 = null;
House house5 = null;
House house6 = null;
House house7 = null;
House house8 = null;
if (!context.Houses.Any())
{
var h1 = context.Houses.Add(new House {
Name = "1", StreetId = street1.Id
});
var h2 = context.Houses.Add(new House {
Name = "2", StreetId = street1.Id
});
var h3 = context.Houses.Add(new House {
Name = "3", StreetId = street1.Id
});
var h4 = context.Houses.Add(new House {
Name = "4", StreetId = street1.Id
});
var h5 = context.Houses.Add(new House {
Name = "1", StreetId = street2.Id
});
var h6 = context.Houses.Add(new House {
Name = "2", StreetId = street2.Id
});
var h7 = context.Houses.Add(new House {
Name = "5", StreetId = street4.Id
});
var h8 = context.Houses.Add(new House {
Name = "45", StreetId = street6.Id
});
context.SaveChanges();
house1 = h1.Entity;
house2 = h2.Entity;
house3 = h3.Entity;
house4 = h4.Entity;
house5 = h5.Entity;
house6 = h6.Entity;
house7 = h7.Entity;
house8 = h8.Entity;
}
/* -- Квартиры -- */
Room room1 = null;
Room room2 = null;
Room room3 = null;
Room room4 = null;
Room room5 = null;
Room room6 = null;
Room room7 = null;
Room room8 = null;
Room room9 = null;
Room room10 = null;
if (!context.Rooms.Any())
{
var r1 = context.Rooms.Add(new Room {
Name = "1", HouseId = house1.Id
});
var r2 = context.Rooms.Add(new Room {
Name = "2", HouseId = house1.Id
});
var r3 = context.Rooms.Add(new Room {
Name = "3", HouseId = house1.Id
});
var r4 = context.Rooms.Add(new Room {
Name = "4", HouseId = house1.Id
});
var r5 = context.Rooms.Add(new Room {
Name = "5", HouseId = house1.Id
});
var r6 = context.Rooms.Add(new Room {
Name = "6", HouseId = house1.Id
});
var r7 = context.Rooms.Add(new Room {
Name = "1", HouseId = house2.Id
});
var r8 = context.Rooms.Add(new Room {
Name = "2", HouseId = house2.Id
});
var r9 = context.Rooms.Add(new Room {
Name = "3", HouseId = house5.Id
});
var r10 = context.Rooms.Add(new Room {
Name = "4", HouseId = house8.Id
});
context.SaveChanges();
room1 = r1.Entity;
room2 = r2.Entity;
room3 = r3.Entity;
room4 = r4.Entity;
room5 = r5.Entity;
room6 = r6.Entity;
room7 = r7.Entity;
room8 = r8.Entity;
room9 = r9.Entity;
room10 = r10.Entity;
}
/* -- Адреса -- */
AdressModel adress1 = null;
AdressModel adress2 = null;
AdressModel adress3 = null;
AdressModel adress4 = null;
AdressModel adress5 = null;
if (!context.Adresses.Any())
{
var a1 = context.Adresses.Add(new AdressModel
{
CompanyId = context.Companies.Where(c => c.Name == "ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ 'Управляющая компания 'ПОЛЁТ''").SingleOrDefault().Id,
RegionId = region1.Id,
CityId = city1.Id,
StreetId = street1.Id,
HouseId = house1.Id,
RoomId = room1.Id
});
var a2 = context.Adresses.Add(new AdressModel
{
CompanyId = context.Companies.Where(c => c.Name == "ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ 'Управляющая компания 'ПОЛЁТ''").SingleOrDefault().Id,
RegionId = region1.Id,
CityId = city1.Id,
StreetId = street1.Id,
HouseId = house1.Id,
RoomId = room2.Id
});
var a3 = context.Adresses.Add(new AdressModel
{
CompanyId = context.Companies.Where(c => c.Name == "ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ 'Управляющая компания 'ПОЛЁТ''").SingleOrDefault().Id,
RegionId = region1.Id,
CityId = city1.Id,
StreetId = street1.Id,
HouseId = house1.Id,
RoomId = room3.Id
});
var a4 = context.Adresses.Add(new AdressModel
{
CompanyId = context.Companies.Where(c => c.Name == "ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ 'ТЕПЛОВОДОСЕРВИС'").SingleOrDefault().Id,
RegionId = region1.Id,
CityId = city3.Id,
StreetId = street6.Id,
HouseId = house8.Id,
RoomId = room10.Id
});
var a5 = context.Adresses.Add(new AdressModel
{
CompanyId = context.Companies.Where(c => c.Name == "ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ 'ТЕПЛОВОДОСЕРВИС'").SingleOrDefault().Id,
RegionId = region1.Id,
CityId = city1.Id,
StreetId = street2.Id,
HouseId = house5.Id,
RoomId = room9.Id
});
context.SaveChanges();
adress1 = a1.Entity;
adress2 = a2.Entity;
adress3 = a3.Entity;
adress4 = a4.Entity;
adress5 = a5.Entity;
}
if (!context.RequestStatuses.Any())
{
context.RequestStatuses.Add(new RequestStatusModel {
Name = "Создана"
});
context.RequestStatuses.Add(new RequestStatusModel {
Name = "В работе"
});
context.RequestStatuses.Add(new RequestStatusModel {
Name = "Закрыта"
});
context.SaveChanges();
}
/* -- Типы заявок -- */
if (!context.RequestTypes.Any())
{
context.RequestTypes.Add(new RequestTypeModel {
Name = "Электричество"
});
context.RequestTypes.Add(new RequestTypeModel {
Name = "Вода"
});
context.RequestTypes.Add(new RequestTypeModel {
Name = "Газ"
});
context.RequestTypes.Add(new RequestTypeModel {
Name = "Уличные работы"
});
context.SaveChanges();
}
//
Contact contact1 = null;
if (!context.Contacts.Any())
{
var c1 = context.Contacts.Add(new Contact
{
FirstName = "Марья", LastName = "Иванова", MiddleName = "Ивановна", ContactType = Models.ContactType.Resident, Phone = "+79553451122"
});
context.SaveChanges();
contact1 = c1.Entity;
}
/* -- Заявки -- */
if (!context.Requests.Any())
{
var _manager = await usermanager.FindByNameAsync("manager");
var managerId = _manager.Id;
var request = new Request
{
RequestTypeId = context.RequestTypes.Where(c => c.Name == "Вода").SingleOrDefault().Id,
RequestStatusId = context.RequestStatuses.Where(c => c.Name == "Создана").SingleOrDefault().Id,
StartDate = DateTime.Now,
//Contact = "Дмитрий Владимирович 8(888)728-29-22",
Description = "Прорвало трубу в квартире",
AdressId = adress1.Id,
UserId = managerId,
ContactId = contact1.Id
};
context.Requests.Add(request);
context.SaveChanges();
}
}
public void SaveAdress(AdressModel adressModel)
{
adresses.Add(adressModel);
}
