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"));
}
