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());
}
public ActionResult UnAssignRegister(int regid, int orgid)
{
Register_OrganisationDA.DeleteRegistersOrganisation(regid, orgid);
Register_OrganisationDA.ModifyRegisterAssignValueToFalse(regid);
return(RedirectToAction("ShowAssignedRegisters"));
}
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"));
}
