protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
RouteConfig.RegisterRoutes(RouteTable.Routes);
var roleAdmin = dbEnt.Roles.Select(r => r.Name);
if (!roleAdmin.Contains("Admin"))
{
Roles role = new Roles {
Name = "Admin"
};
Users usr = new Users {
FirstName = "Керимов", SecondName = "Алихан", Email = "*****@*****.**", EmailConfirm = true
};
dbEnt.Roles.Add(role);
dbEnt.Users.Add(usr);
dbEnt.SaveChanges();
dbEnt.Accounts.Add(new Accounts {
user_id = usr.id, password = "******"
});
dbEnt.UserRoles.Add(new UserRoles {
user_id = usr.id, role_id = role.id
});
dbEnt.SaveChanges();
}
}
public ActionResult NewRequest(UserRequestModel usrReq)
{
var _acc = (from a in dbEnt.Accounts where a.Users.Email == User.Identity.Name select a.Users).FirstOrDefault();
dbEnt.UserRequests.Add(new UserRequests {
mangeCompany_id = usrReq.Category, Message = usrReq.Message, DateOfCreate = DateTime.Now, Closed = false, user_id = _acc.id
});
dbEnt.SaveChanges();
return(View("MyRequestList"));
}
public ActionResult ConsolidateSubCompany(int id_request, int subCompany_id)
{
var _requests = dbEnt.UserRequests.Where(r => r.id == id_request).Select(r => r).FirstOrDefault();
_requests.subCompany_id = subCompany_id;
dbEnt.SaveChanges();
return(RedirectToAction("DetailsRequest", new { id = id_request }));
}
public ActionResult Login(LogInModel model)
{
if (ModelState.IsValid)
{
// поиск пользователя в бд
Accounts _acc = null;
using (DBISCityEntities db = new DBISCityEntities())
{
_acc = db.Accounts.FirstOrDefault(u => u.Users.Email == model.Login && u.password == model.Password);
}
if (_acc != null)
{
FormsAuthentication.SetAuthCookie(model.Login, true);
var _usr = (from u in dbEnt.Users
where u.id == _acc.user_id
select u).FirstOrDefault();
var _usrRoles = dbEnt.UserRoles.Where(r => r.user_id == _usr.id).Select(s => s.Roles.Name);
if (_usr.EmailConfirm != true)
{
_usr.EmailConfirm = true;
dbEnt.SaveChanges();
}
if (_usrRoles.Contains("ManageCompany"))
{
return(RedirectToAction("Index", "ManageCompany"));
}
else if (_usrRoles.Contains("SubCompany"))
{
return(RedirectToAction("Index", "SubCompany"));
}
else if (_usrRoles.Contains("Admin"))
{
return(RedirectToAction("Index", "Admin"));
}
else
{
return(RedirectToAction("Index", "User"));
}
}
else
{
ModelState.AddModelError("", "Пользователя с таким логином и паролем нет");
}
}
return(View(model));
}
public ActionResult EditManageCompany(ManageCompanyModel mc, int user_id, int mc_id)
{
var _usr = dbEnt.Users.Where(u => u.id == user_id).Select(u => u).FirstOrDefault();
var _mc = dbEnt.ManageCompany.Where(m => m.id == mc_id).Select(m => m).FirstOrDefault();
_mc.Name = mc.Name;
_mc.Street = mc.Street;
_mc.Category = mc.Category;
_mc.HouseNumber = mc.HouseNumber;
_usr.Email = mc.Email;
_usr.FirstName = mc.FirstName;
_usr.SecondName = mc.SecondName;
_usr.ThirdName = mc.ThirdName;
dbEnt.SaveChanges();
var mcList = dbEnt.ManageCompany.ToList();
return(RedirectToAction("ManageCompanyList", mcList));
}
