public ActionResult ShowAssignedRegisters() { List <Organisation> oList = OrganisationDA.GetOrganisations(); List <RegistersOrganisation> orList = Register_OrganisationDA.GetOrganisation_Registers(); List <Register> registers = new List <Register>(); List <Register>[] rList = new List <Register> [oList.Count]; int i = 0; for (i = 0; i < rList.Length; i++) { rList[i] = new List <Register>(); } i = 0; foreach (Organisation o in oList) { foreach (RegistersOrganisation or in orList) { if (or.Organisationid == o.ID) { rList[i].Add(RegisterDA.GetRegisters(or.RegisterId)); } } i++; } ViewBag.Organisations = oList; ViewBag.Registers = rList; return(View()); }
// GET: OrganisationOverview public ActionResult ListOrganisations() { List <Organisation> lstOrganisations = OrganisationDA.GetOrganisations(); ViewBag.Organisations = lstOrganisations; return(View()); }
public ActionResult Create(OrganisationNewModel org) { Regex rgx = new Regex("[^a-z]"); string db = rgx.Replace(org.OrganisationName.ToLower(), "") + (new Random()).Next(0, 9999).ToString(); if (ModelState.IsValid) { Organisation tempOrg = new Organisation() { Login = org.Login, Password = org.Password, DbLogin = db, DbPassword = (new Regex("[^a-zA-Z0-9]")).Replace(Cryptography.Encrypt((new Random()).Next(999, 999999).ToString()), ""), DbName = db, OrganisationName = org.OrganisationName, Address = org.Address, Email = org.Email, Phone = org.Phone }; int id = OrganisationDA.Save(tempOrg); return(RedirectToAction("Details", new { id = id })); } return(View(org)); }
public Organisation GetOrganisation() { ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal; string dbLogin = p.Claims.ElementAt(1).Value; string dbPassword = p.Claims.ElementAt(2).Value; return(OrganisationDA.getOrganisation(dbLogin, dbPassword)); }
public ActionResult Create(Organisations o) { int validInsert = OrganisationDA.InsertOrganisations(o); if (validInsert != 0) { return(RedirectToAction("Index")); } return(View()); }
public ActionResult Edit(Organisation organisation) { if (ModelState.IsValid) { OrganisationDA.EditOrganisation(organisation); return(View("Details", organisation)); } return(RedirectToAction("Index")); }
public ActionResult EditOrganisation() { List <RegisterPM> AllRegisters = RegistersDA.GetRegisterPM(); List <Organisations> AllOrganisations = OrganisationDA.GetOrganisations(); ViewBag.Registers = AllRegisters; ViewBag.Organisations = AllOrganisations; return(View()); }
public HttpResponseMessage Put(string NewPassword) { ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal; string dbLogin = p.Claims.ElementAt(1).Value; string dbPassword = p.Claims.ElementAt(2).Value; OrganisationDA.UpdatePassword(dbLogin, dbPassword, NewPassword); return(new HttpResponseMessage(HttpStatusCode.OK)); }
public ActionResult Edit(int id) { Organisation o = OrganisationDA.GetOrganisations(id); o.Login = Cryptography.Decrypt(o.Login); o.Password = Cryptography.Decrypt(o.Password); o.DbName = Cryptography.Decrypt(o.DbName); o.DbLogin = Cryptography.Decrypt(o.DbLogin); o.DbPassword = Cryptography.Decrypt(o.DbPassword); return(View(o)); }
// GET: api/Organisation public Boolean GetPasswordCorrect(string oldPassword) { ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal; //string dbDatabase = p.Claims.ElementAt(0).Value; string dbLogin = p.Claims.ElementAt(1).Value; string dbPassword = p.Claims.ElementAt(2).Value; Boolean passwordCorrect = OrganisationDA.checkOldPassword(dbLogin, dbPassword, oldPassword); return(passwordCorrect); }
public ActionResult Edit(int?id) { if (id != null) { Organisations o = OrganisationDA.GetOrganisation(Convert.ToInt32(id)); return(View(o)); } else { return(RedirectToAction("Index")); } }
public ActionResult Edit(Organisation o) { if (!ModelState.IsValid) { return(View("Edit", o)); } else { OrganisationDA.EditOrganisation(o); return(RedirectToAction("ListOrganisations")); } }
public ActionResult Edit(Organisations o) { if (o.Login != null & o.Password != null & o.DbName != null & o.DbLogin != null & o.DbPassword != null & o.OrganisationName != null & o.Address != null & o.Email != null) { int validUpdate = OrganisationDA.UpdateOrganisations(o); if (validUpdate != 0) { return(View("Details", o)); } } return(View()); }
public ActionResult ViewErrorlog(int regid, int orgid) { Organisation o = new Organisation(); o = OrganisationDA.GetOrganisations(orgid); ViewBag.register = regid; ErrorlogDA.ChangeConnectionString("System.Data.SqlClient", "MCT-NIELS" + @"\DATAMANAGEMENT", Cryptography.Decrypt(o.DbName), Cryptography.Decrypt(o.DbLogin), Cryptography.Decrypt(o.DbPassword)); List <Errorlog> errorlist = new List <Errorlog>(); errorlist = ErrorlogDA.GetErrorlogs(regid); return(View(errorlist)); }
public override Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { string mode = context.UserName.Substring(0, 1); Organisation o = null; bool fail = true; string username = context.UserName.Substring(1); switch (mode) { case "m": o = OrganisationDA.CheckCredentials(username, context.Password); if (o != null) { fail = false; } break; case "s": o = OrganisationDA.GetOrganisation(Int32.Parse(username)); Employee employee = EmployeeDA.GetEmployeeByName(context.Password, o); if (o != null && employee != null) { fail = false; } break; case "r": o = OrganisationDA.GetOrganisation(Int32.Parse(username)); Customer customer = CustomerDA.GetCustomerByName(context.Password, o); if (o != null && customer != null) { fail = false; } break; } if (fail) { context.Rejected(); return(Task.FromResult(0)); } var id = new ClaimsIdentity(context.Options.AuthenticationType); id.AddClaim(new Claim("userid", o.ID.ToString())); id.AddClaim(new Claim("dbname", o.DbName)); id.AddClaim(new Claim("dblogin", o.DbLogin)); id.AddClaim(new Claim("dbpass", o.DbPassword)); context.Validated(id); return(Task.FromResult(0)); }
private List <SelectListItem> GetOrganisations() { List <SelectListItem> items = new List <SelectListItem>(); foreach (Organisation org in OrganisationDA.GetOrganisations()) { items.Add(new SelectListItem() { Value = org.ID.ToString(), Text = org.OrganisationName }); } return(items); }
public ActionResult Search(int?id) { if (id != null) { Organisations o = OrganisationDA.GetOrganisation(Convert.ToInt32(id)); ViewBag.Titel = "Kassas voor " + o.OrganisationName; List <RegisterPM> list = RegistersDA.GetRegistersPM(o.ID); return(View(list)); } else { return(RedirectToAction("Index", "Organisations")); } }
public ActionResult Create(PMOrganisationRegister reg) { reg.Organisations = GetOrganisations(); if (ModelState.IsValid) { reg.DataOrganisationRegister.Organisation = OrganisationDA.GetOrganisation(reg.DataOrganisationRegister.OrganisationID); int id = RegisterDA.Save(reg.DataOrganisationRegister); return(RedirectToAction("Index")); } return(View(reg)); }
public ActionResult AssignRegister(int id) { List <Organisation> list = OrganisationDA.GetOrganisations(); foreach (Organisation o in list) { o.Login = Cryptography.Decrypt(o.Login); o.Password = Cryptography.Decrypt(o.Password); o.DbLogin = Cryptography.Decrypt(o.DbLogin); o.DbName = Cryptography.Decrypt(o.DbName); o.DbPassword = Cryptography.Decrypt(o.DbPassword); } ViewBag.Register = id; return(View(list)); }
public ActionResult Create(Organisation organisation) { if (ModelState.IsValid) { organisation.Login = Cryptography.Encrypt(organisation.Login); organisation.Password = Cryptography.Encrypt(organisation.Password); organisation.DbName = Cryptography.Encrypt(organisation.DbName); organisation.DbLogin = Cryptography.Encrypt(organisation.DbLogin); organisation.DbPassword = Cryptography.Encrypt(organisation.DbPassword); CreateDatabaseOrganisation.CreateDatabase(organisation); OrganisationDA.NewOrganisation(organisation); } return(RedirectToAction("Index")); }
public ActionResult Edit(int?id) { if (!id.HasValue) { return(RedirectToAction("Index")); } Organisation organisation = OrganisationDA.GetOrganisationByID(id.Value); if (organisation == null) { return(RedirectToAction("Index")); } return(View(organisation)); }
public HttpResponseMessage Put(Password NewPas) { HttpResponseMessage response = null; Organisation org = new Organisation(); org = OrganisationDA.CheckCredentials(NewPas.Login, NewPas.OldPassword); if (org != null) { OrganisationDA.ChangePassword(NewPas); response = Request.CreateResponse(HttpStatusCode.OK); } else { response = new HttpResponseMessage(HttpStatusCode.NotFound); } return(response); }
public HttpResponseMessage Put(Password NewPas) { HttpResponseMessage response = null; Employee emp = new Employee(); emp = OrganisationDA.CheckCredentialsME(NewPas.Login, NewPas.OldPassword); if (emp != null) { EmployeeDA.ChangePassword(NewPas); response = Request.CreateResponse(HttpStatusCode.OK); } else { response = new HttpResponseMessage(HttpStatusCode.NotFound); } return(response); }
public ActionResult Edit(int?id) { if (!id.HasValue) { return(RedirectToAction("Index")); } OrganisationRegister organisationRegister = RegisterDA.GetRegisterByID(id.Value); if (organisationRegister.ID == 0) { return(RedirectToAction("Index")); } ViewBag.Organisations = OrganisationDA.GetOrganisations(); return(View(organisationRegister)); }
public ActionResult Create() { OrganisationRegister organistationRegister = new OrganisationRegister(); //bij het toevoegen van een nieuw register //bij gekocht op: dag van vandaag invullen en bij vervalt op: vijf jaar later RegisterCompany register = new RegisterCompany() { PurchaseDate = DateTime.Today, ExpiresDate = DateTime.Today.AddYears(5) }; organistationRegister.Register = register; ViewBag.Organisations = OrganisationDA.GetOrganisations(); return(View(organistationRegister)); }
public override Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { Employee o = OrganisationDA.CheckCredentialsME(context.UserName, context.Password); if (o == null) { context.Rejected(); return(Task.FromResult(0)); } var id = new ClaimsIdentity(context.Options.AuthenticationType); id.AddClaim(new Claim("dblogin", "Scouts")); id.AddClaim(new Claim("organisatie", "Scouts")); id.AddClaim(new Claim("dbpassword", "Scouts")); id.AddClaim(new Claim("dbname", "Scouts")); context.Validated(id); return(Task.FromResult(0)); }
public override Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { ItOrganisation o = OrganisationDA.GetOrganisationByLoginAndPassword(context.UserName, context.Password); if (o == null) { context.Rejected(); return(Task.FromResult(0)); } var id = new ClaimsIdentity(context.Options.AuthenticationType); id.AddClaim(new Claim("dbname", o.DbName)); id.AddClaim(new Claim("dblogin", o.DbLogin)); id.AddClaim(new Claim("dbpass", o.DBpass)); context.Validated(id); return(Task.FromResult(0)); }
public ActionResult Edit(OrganisationEditModel org) { if (ModelState.IsValid) { OrganisationDA.Save(new Organisation() { ID = org.ID, Login = org.Login, Password = org.Password, OrganisationName = org.OrganisationName, Address = org.Address, Email = org.Email, Phone = org.Phone }); return(RedirectToAction("Index")); } return(View(org)); }
public ActionResult Edit(int id) { Organisation org = OrganisationDA.GetOrganisation(id); if (org == null) { return(HttpNotFound()); } return(View(new OrganisationEditModel() { ID = org.ID, Login = org.Login, Password = org.Password, OrganisationName = org.OrganisationName, Address = org.Address, Email = org.Email, Phone = org.Phone })); }
public ActionResult AssignToOrganisation(int regid, int orgid) { RegistersOrganisation ro = new RegistersOrganisation() { RegisterId = regid, Organisationid = orgid, From = DateTime.Now.Date, Untill = DateTime.Now.Date.AddYears(10) }; Register_OrganisationDA.InsertOrganisation_Register(ro); Register_OrganisationDA.ModifyRegisterAssignValue(regid); Organisation o = OrganisationDA.GetOrganisations(orgid); Register r = RegisterDA.GetRegisters(regid); RegisterClientDAcs.ChangeConnectionString("System.Data.SqlClient", "MCT-NIELS" + @"\DATAMANAGEMENT", Cryptography.Decrypt(o.DbName), Cryptography.Decrypt(o.DbLogin), Cryptography.Decrypt(o.DbPassword)); RegisterClientDAcs.InsertRegister(r); return(View("Succeeded")); }