// // GET: /Roles/ public void AddRightToDatabase(string label, string controllerName, string vAction) { bool found = false; string myController = ControllerContext.RouteData.Values["Controller"].ToString(); string controllerActionName = controllerName + "." + vAction; if (controllerName != myController && !string.IsNullOrEmpty(label)) { using (SemplestEntities dbContext = new SemplestEntities()) { foreach (Right r in dbContext.Rights) { if (label == r.Label && controllerActionName == r.Controller) { found = true; break; } } if (!found) { dbContext.Rights.Add(new Right { Controller = controllerActionName, Label = label }); dbContext.SaveChanges(); } } } }
public ActionResult Edit(User model) { using (SemplestEntities dbContext = new SemplestEntities()) { dbContext.Users.Add(model); dbContext.SaveChanges(); } return View(model); }
public ActionResult Add(CustomerAccountWithEmployeeModel m) { try { SemplestEntities dbcontext = new SemplestEntities(); BillType bt = dbcontext.BillTypes.First(p => p.BillType1 == "Flat Fee"); // --- feees --- !!! ProductGroupCycleType pgct = dbcontext.ProductGroupCycleTypes.First(p => p.ProductGroupCycleType1 == "Product Group Cycle 30"); Customer c = dbcontext.Customers.Add(new Customer { Name = m.CustomerAccount.Customer, BillType = bt, ProductGroupCycleType = pgct }); User u = dbcontext.Users.Add(new User { Customer = c, Email = m.CustomerAccount.Email, FirstName = m.CustomerAccount.FirstName, LastName = m.CustomerAccount.LastName, MiddleInitial = m.CustomerAccount.MiddleInitial, IsActive=m.CustomerAccount.isActive }); Credential cr = dbcontext.Credentials.Add(new Credential { User = u, UsersFK = u.UserPK, Username = m.CustomerAccount.Email, Password = "******" }); //-- default password --- !! PhoneType pt = dbcontext.PhoneTypes.First(p => p.PhoneType1 == "Business"); // --- phone types --- !!!! Phone ph = dbcontext.Phones.Add(new Phone { Phone1 = m.CustomerAccount.Phone, PhoneType = pt }); CustomerPhoneAssociation cpa = dbcontext.CustomerPhoneAssociations.Add(new CustomerPhoneAssociation { Customer = c, Phone = ph }); StateCode sc = dbcontext.StateCodes.First(p => p.StateAbbrPK == m.SelectedStateID); AddressType at = dbcontext.AddressTypes.First(p => p.AddressType1 == "H"); // --- address types --- !!! Address a = dbcontext.Addresses.Add(new Address { Address1 = m.CustomerAccount.Address1, Address2 = m.CustomerAccount.Address2, City = m.CustomerAccount.City, ZipCode = m.CustomerAccount.Zip, StateCode = sc }); CustomerAddressAssociation caa = dbcontext.CustomerAddressAssociations.Add(new CustomerAddressAssociation { Address = a, Customer = c, AddressType = at }); CustomerNote cn = dbcontext.CustomerNotes.Add(new CustomerNote { Customer=c, Note=m.CustomerAccount.CustomerNote }); EmployeeCustomerAssociation addrep = dbcontext.EmployeeCustomerAssociations.Add(new EmployeeCustomerAssociation { Customer=c, EmployeeFK=m.SelectedRepID }); EmployeeCustomerAssociation addsales = dbcontext.EmployeeCustomerAssociations.Add(new EmployeeCustomerAssociation { Customer = c, EmployeeFK = m.SelectedSalesPersonID }); dbcontext.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.TargetSite); } return RedirectToAction("Index"); }
public ActionResult Edit(CustomerAccountWithEmployeeModel m) { SemplestEntities dbcontext = new SemplestEntities(); var user = dbcontext.Users.ToList().Find(p => p.UserPK == m.CustomerAccount.UserPK); user.FirstName = m.CustomerAccount.FirstName; user.LastName = m.CustomerAccount.LastName; user.MiddleInitial = m.CustomerAccount.MiddleInitial; user.Email = m.CustomerAccount.Email; user.EditedDate = DateTime.Now; user.IsActive = m.CustomerAccount.isActive; UpdateModel(user); var customer = dbcontext.Customers.ToList().Find(p => p.CustomerPK == m.CustomerAccount.AccountNumber); var customeraddressassociation = dbcontext.CustomerAddressAssociations.ToList().Find(p => p.CustomerFK == customer.CustomerPK); var address = dbcontext.Addresses.ToList().Find(p => p.AddressPK == customeraddressassociation.AddressFK); customer.Name = m.CustomerAccount.Customer; address.Address1 = m.CustomerAccount.Address1; address.Address2 = m.CustomerAccount.Address2; address.City = m.CustomerAccount.City; address.ZipCode = m.CustomerAccount.Zip; address.EditedDate = DateTime.Now; address.StateAbbrFK = m.SelectedStateID; var rep = from c in dbcontext.Customers join eca in dbcontext.EmployeeCustomerAssociations on c.CustomerPK equals eca.CustomerFK join e in dbcontext.Employees on eca.EmployeeFK equals e.EmployeePK join et in dbcontext.EmployeeTypes on e.EmployeeTypeFK equals et.EmployeeTypeID where (c.CustomerPK == m.CustomerAccount.AccountNumber && et.EmployeeType1.ToLower() == "rep") select new ECAModel { CustomerPK=c.CustomerPK, EmployeePK = e.EmployeePK }; var sales = from c in dbcontext.Customers join eca in dbcontext.EmployeeCustomerAssociations on c.CustomerPK equals eca.CustomerFK join e in dbcontext.Employees on eca.EmployeeFK equals e.EmployeePK join et in dbcontext.EmployeeTypes on e.EmployeeTypeFK equals et.EmployeeTypeID where (c.CustomerPK == m.CustomerAccount.AccountNumber && et.EmployeeType1.ToLower() == "sales") select new ECAModel { CustomerPK = c.CustomerPK, EmployeePK = e.EmployeePK }; //rep.ToList().First().EmployeePK = m.SelectedRepID; //sales.ToList().First().EmployeePK = m.SelectedSalesPersonID; var employeesales= dbcontext.EmployeeCustomerAssociations.ToList().Find(p => p.CustomerFK==m.CustomerAccount.AccountNumber && p.EmployeeFK==sales.ToList().First().EmployeePK); employeesales.EmployeeFK = m.SelectedSalesPersonID; var employeerep = dbcontext.EmployeeCustomerAssociations.ToList().Find(p => p.CustomerFK == m.CustomerAccount.AccountNumber && p.EmployeeFK == rep.ToList().First().EmployeePK); employeerep.EmployeeFK = m.SelectedRepID; UpdateModel(employeerep); UpdateModel(employeesales); //var employeecustomerassociation = dbcontext.EmployeeCustomerAssociations.ToList().Find(p => p.CustomerFK == customer.CustomerPK && p.EmployeeFK==1); //employeecustomerassociation. //employeecustomerassociation.EmployeeCustomerAssociationPK UpdateModel(address); var customernote=dbcontext.CustomerNotes.ToList().FirstOrDefault(p=>p.CustomerFK==m.CustomerAccount.AccountNumber); customernote.Note = m.CustomerAccount.CustomerNote; UpdateModel(customernote); dbcontext.SaveChanges(); //Role ro = _dbContext.Roles.Add(new Role { RoleName = f["roleName"].ToString() }); //_dbContext.SaveChanges(); //foreach (sp_GetRigtsRolesInteraction_Result s in userRights) //{ // RolesRightsAssociation ra = new RolesRightsAssociation // { // IsReadonly = s.IsReadonly ==null ? false : bool.Parse(s.IsReadonly.ToString()), IsVisible = s.IsVisible == null ? false : bool.Parse(s.IsVisible.ToString()), RightsFK = s.RightsPK, RolesFK = ro.RolePK // }; // _dbContext.RolesRightsAssociations.Add(ra); //} //_dbContext.SaveChanges(); ////repopulate states ddl //var states = (from sc in dbcontext.StateCodes select sc).ToList(); //m.States = states.Select(r => new SelectListItem // { // Value = r.StateAbbrPK.ToString(), // Text = r.StateAbbr.ToString() // }); ////repopulate reps ddl //var allreps = from e in dbcontext.Employees // join eca in dbcontext.EmployeeCustomerAssociations on e.EmployeePK equals eca.EmployeeFK // join et in dbcontext.EmployeeTypes on e.EmployeeTypeFK equals et.EmployeeTypeID // join u in dbcontext.Users on e.UsersFK equals u.UserPK // where (et.EmployeeType1 == "Rep") // select new EmployeeCustomerAssociaitionModel // { // AccountNumber = eca.CustomerFK, // employeePK = e.EmployeePK, // EmployeeType = et.EmployeeType1, // EmployeeUserPK = u.UserPK, // FirstName = u.FirstName, // LastName = u.LastName // }; //List<EmployeeCustomerAssociaitionModel> ll1 = allreps.ToList(); //List<SelectListItem> sl1 = new List<SelectListItem>(); //foreach (EmployeeCustomerAssociaitionModel s in ll1) //{ // SelectListItem mylistitem = new SelectListItem(); // mylistitem.Text = s.FirstName + " " + s.LastName; // mylistitem.Value = s.EmployeeUserPK.ToString(); // sl1.Add(mylistitem); //} //m.Reps = sl1; ////repopulate salepersons ddl ////for reps dropdown //var allsalespersons = from e in dbcontext.Employees // join eca in dbcontext.EmployeeCustomerAssociations on e.EmployeePK equals eca.EmployeeFK // join et in dbcontext.EmployeeTypes on e.EmployeeTypeFK equals et.EmployeeTypeID // join u in dbcontext.Users on e.UsersFK equals u.UserPK // where (et.EmployeeType1 == "Sales") // select new EmployeeCustomerAssociaitionModel // { // AccountNumber = eca.CustomerFK, // employeePK = e.EmployeePK, // EmployeeType = et.EmployeeType1, // EmployeeUserPK = u.UserPK, // FirstName = u.FirstName, // LastName = u.LastName // }; //List<EmployeeCustomerAssociaitionModel> ll2 = allsalespersons.ToList(); //List<SelectListItem> sl2 = new List<SelectListItem>(); //foreach (EmployeeCustomerAssociaitionModel s in ll2) //{ // SelectListItem mylistitem = new SelectListItem(); // mylistitem.Text = s.FirstName + " " + s.LastName; // mylistitem.Value = s.EmployeeUserPK.ToString(); // sl2.Add(mylistitem); //} //m.SalesPersons = sl2; return RedirectToAction("Index"); //return View("index"); //return View(m); }
public ActionResult Add(EmployeeSetupWithRolesModel m) { try { SemplestEntities dbcontext = new SemplestEntities(); User u = dbcontext.Users.Add(new User { Customer = null, Email = m.EmployeeSetup.Email, FirstName = m.EmployeeSetup.FirstName, MiddleInitial = m.EmployeeSetup.MiddleInitial, LastName = m.EmployeeSetup.LastName, CustomerFK=null, IsActive=m.EmployeeSetup.isActive }); Role r= dbcontext.Roles.First(p => p.RolePK == m.SelectedRoleID ); UserRolesAssociation ura = dbcontext.UserRolesAssociations.Add(new UserRolesAssociation { Role = r, User = u }); EmployeeType et = dbcontext.EmployeeTypes.First(p => p.EmployeeTypeID == m.SelectedEmployeeTypeID); Employee e = dbcontext.Employees.Add(new Employee { EmployeeType = et, User = u }); Credential c = dbcontext.Credentials.Add(new Credential { User = u, Username = m.EmployeeSetup.Email, Password = "******" }); //BillType bt = dbcontext.BillTypes.First(p => p.BillType1 == "Flat Fee"); // --- feees --- !!! //ProductGroupCycleType pgct = dbcontext.ProductGroupCycleTypes.First(p => p.ProductGroupCycleType1 == "Product Group Cycle 30"); //Customer c = dbcontext.Customers.Add(new Customer { Name = m.CustomerAccount.Customer, BillType = bt, ProductGroupCycleType = pgct }); //User u = dbcontext.Users.Add(new User //{ // Customer = c, // Email = m.CustomerAccount.Email, // FirstName = m.CustomerAccount.FirstName, // LastName = m.CustomerAccount.LastName //}); //Credential cr = dbcontext.Credentials.Add(new Credential { User = u, UsersFK = u.UserPK, Username = m.CustomerAccount.Email, Password = "******" }); //-- default password --- !! //PhoneType pt = dbcontext.PhoneTypes.First(p => p.PhoneType1 == "Business"); // --- phone types --- !!!! //Phone ph = dbcontext.Phones.Add(new Phone { Phone1 = m.CustomerAccount.Phone, PhoneType = pt }); //CustomerPhoneAssociation cpa = dbcontext.CustomerPhoneAssociations.Add(new CustomerPhoneAssociation { Customer = c, Phone = ph }); //StateCode sc = dbcontext.StateCodes.First(p => p.StateAbbrPK == m.SelectedStateID); //AddressType at = dbcontext.AddressTypes.First(p => p.AddressType1 == "H"); // --- address types --- !!! //Address a = dbcontext.Addresses.Add(new Address { Address1 = m.CustomerAccount.Address1, Address2 = m.CustomerAccount.Address2, City = m.CustomerAccount.City, ZipCode = m.CustomerAccount.Zip, StateCode = sc }); //CustomerAddressAssociation caa = dbcontext.CustomerAddressAssociations.Add(new CustomerAddressAssociation { Address = a, Customer = c, AddressType = at }); dbcontext.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.TargetSite); } return RedirectToAction("Index"); }
public ActionResult Edit(EmployeeSetupWithRolesModel m) { SemplestEntities dbcontext = new SemplestEntities(); var user = dbcontext.Users.ToList().Find(p => p.UserPK == m.EmployeeSetup.UserPK); user.FirstName = m.EmployeeSetup.FirstName; user.MiddleInitial = m.EmployeeSetup.MiddleInitial; user.LastName = m.EmployeeSetup.LastName; user.Email = m.EmployeeSetup.Email; user.EditedDate = DateTime.Now; user.IsActive = m.EmployeeSetup.isActive; UpdateModel(user); //need to add effective date to db ---><><> var employee = dbcontext.Employees.ToList().Find(p => p.UsersFK == m.EmployeeSetup.UserPK); employee.EmployeeTypeFK = m.SelectedEmployeeTypeID; employee.ReportingTo = m.SelectedReportingToID == -1 ? default(int?) : m.SelectedReportingToID; UpdateModel(employee); var userrolesassociation = dbcontext.UserRolesAssociations.ToList().Find(p => p.UsersFK == m.EmployeeSetup.UserPK); userrolesassociation.RolesFK = m.SelectedRoleID; UpdateModel(userrolesassociation); dbcontext.SaveChanges(); ////repopulate states ddl //var states = (from sc in dbcontext.StateCodes select sc).ToList(); //m.States = states.Select(r => new SelectListItem //{ // Value = r.StateAbbrPK.ToString(), // Text = r.StateAbbr.ToString() //}); ////repopulate reps ddl //var allreps = from e in dbcontext.Employees // join eca in dbcontext.EmployeeCustomerAssociations on e.EmployeePK equals eca.EmployeeFK // join et in dbcontext.EmployeeTypes on e.EmployeeTypeFK equals et.EmployeeTypeID // join u in dbcontext.Users on e.UsersFK equals u.UserPK // where (et.EmployeeType1 == "Rep") // select new EmployeeCustomerAssociaitionModel // { // AccountNumber = eca.CustomerFK, // employeePK = e.EmployeePK, // EmployeeType = et.EmployeeType1, // EmployeeUserPK = u.UserPK, // FirstName = u.FirstName, // LastName = u.LastName // }; //List<EmployeeCustomerAssociaitionModel> ll1 = allreps.ToList(); //List<SelectListItem> sl1 = new List<SelectListItem>(); //foreach (EmployeeCustomerAssociaitionModel s in ll1) //{ // SelectListItem mylistitem = new SelectListItem(); // mylistitem.Text = s.FirstName + " " + s.LastName; // mylistitem.Value = s.EmployeeUserPK.ToString(); // sl1.Add(mylistitem); //} //m.Reps = sl1; ////repopulate salepersons ddl ////for reps dropdown //var allsalespersons = from e in dbcontext.Employees // join eca in dbcontext.EmployeeCustomerAssociations on e.EmployeePK equals eca.EmployeeFK // join et in dbcontext.EmployeeTypes on e.EmployeeTypeFK equals et.EmployeeTypeID // join u in dbcontext.Users on e.UsersFK equals u.UserPK // where (et.EmployeeType1 == "Sales") // select new EmployeeCustomerAssociaitionModel // { // AccountNumber = eca.CustomerFK, // employeePK = e.EmployeePK, // EmployeeType = et.EmployeeType1, // EmployeeUserPK = u.UserPK, // FirstName = u.FirstName, // LastName = u.LastName // }; //List<EmployeeCustomerAssociaitionModel> ll2 = allsalespersons.ToList(); //List<SelectListItem> sl2 = new List<SelectListItem>(); //foreach (EmployeeCustomerAssociaitionModel s in ll2) //{ // SelectListItem mylistitem = new SelectListItem(); // mylistitem.Text = s.FirstName + " " + s.LastName; // mylistitem.Value = s.EmployeeUserPK.ToString(); // sl2.Add(mylistitem); //} //m.SalesPersons = sl2; //return View("index"); return RedirectToAction("Index"); }