public RegisterOrganisation Post(RegisterOrganisation r)
{
int id = RegistersOrganisation.Insert(Claims.GetConnectionString(User), r);
r.ID = id;
return(r);
}
public static void EditRegistersOrganisation(RegistersOrganisation or)
{
string sql = "UPDATE Organisation_Register SET OrganisationID=@OrganisationID, RegisterID=@RegisterID, FromDate=@FromDate, UntilDate=@UntilDate WHERE OrganisationID=@OrganisationID";
DbParameter par1 = Database.addParameter(ConnectionString, "@OrganisationID", or.Organisationid);
DbParameter par2 = Database.addParameter(ConnectionString, "@RegisterID", or.RegisterId);
DbParameter par3 = Database.addParameter(ConnectionString, "@FromDate", or.From);
DbParameter par4 = Database.addParameter(ConnectionString, "@UntilDate", or.Untill);
Database.ModifyData(Database.GetConnection(ConnectionString), sql, par1, par2, par3, par4);
}
public static RegistersOrganisation GetRegisters_Organisation(int ID)
{
RegistersOrganisation or = new RegistersOrganisation();
string sql = "SELECT OrganisationID, RegisterID, FromDate, UntilDate FROM Organisation_Register WHERE RegisterID=@RegisterID";
DbParameter par1 = Database.addParameter(ConnectionString, "@RegisterID", ID);
DbDataReader reader = Database.GetData(Database.GetConnection(ConnectionString), sql, par1);
while (reader.Read())
{
or = Create(reader);
}
reader.Close();
return(or);
}
public static int InsertOrganisation_Register(RegistersOrganisation or)
{
try
{
string sql = "INSERT INTO Organisation_Register VALUES(@OrganisationID, @RegisterID, @FromDate, @UntilDate)";
DbParameter par1 = Database.addParameter(ConnectionString, "@OrganisationID", or.Organisationid);
DbParameter par2 = Database.addParameter(ConnectionString, "@RegisterID", or.RegisterId);
DbParameter par3 = Database.addParameter(ConnectionString, "@FromDate", or.From.ToString("yyyy-MM-dd"));
DbParameter par4 = Database.addParameter(ConnectionString, "@UntilDate", or.Untill.ToString("yyyy-MM-dd"));
return(Database.InsertData(Database.GetConnection(ConnectionString), sql, par1, par2, par3, par4));
}
catch (Exception)
{
return(0);
}
}
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"));
}
public HttpStatusCode Delete(long id)
{
RegistersOrganisation.Delete(Claims.GetConnectionString(User), id);
return(HttpStatusCode.OK);
}
public HttpStatusCode Put(long id, RegisterOrganisation r)
{
RegistersOrganisation.Update(Claims.GetConnectionString(User), id, r);
return(HttpStatusCode.OK);
}
public List <RegisterOrganisation> Get()
{
return(RegistersOrganisation.Get(Claims.GetConnectionString(User)));
}
