public static RegisterPM GetRegisterPM(int id)
{
RegisterPM r = new RegisterPM();
string sql = "SELECT Registers.ID, RegisterName, Device, PurchaseDate, ExpiresDate, OrganisationID FROM Registers left join Organisation_Register on Registers.ID=RegisterID WHERE Registers.ID=@id";
DbParameter par1 = Database.AddParameter(CON, "@id", id);
DbDataReader reader = Database.GetData(Database.GetConnection(CON), sql, par1);
reader.Read();
r = CreatePM(reader);
reader.Close();
return(r);
}
public static int InsertRegisterPM(int register, int organisation)
{
string sql;
RegisterPM r = GetRegisterPM(register);
DbParameter par1 = Database.AddParameter(CON, "@RegisterID", register);
DbParameter par2 = Database.AddParameter(CON, "@OrganisationID", organisation);
DbParameter par3 = Database.AddParameter(CON, "@FromDate", DateTime.Now);
DbParameter par4 = Database.AddParameter(CON, "@UntilDate", r.Kassa.ExpiresDate);
int ValidUpdate;
if (r.Vereniging == null)
{
sql = "INSERT INTO Organisation_Register (OrganisationID, RegisterID, FromDate, UntilDate) VALUES (@OrganisationID, @RegisterID, @FromDate, @UntilDate)";
ValidUpdate = Database.InsertData(Database.GetConnection(CON), sql, par1, par2, par3, par4);
}
else
{
sql = "UPDATE Organisation_Register SET OrganisationID=@OrganisationID, FromDate=@FromDate, UntilDate=@UntilDate WHERE RegisterID=@RegisterID";
ValidUpdate = Database.ModifyData(Database.GetConnection(CON), sql, par1, par2, par3, par4);
}
return(ValidUpdate);
}
public ActionResult EditOrganisation(int kassa, int vereniging)
{
RegisterPM r = RegistersDA.GetRegisterPM(kassa);
int OldOrganisation;
if (r.Vereniging != null)
{
OldOrganisation = r.Vereniging.ID;
}
else
{
OldOrganisation = 0;
}
int validUpdate = RegistersDA.InsertRegisterPM(kassa, vereniging);
int validUpdate2 = RegistersDA.UpdateOrganisationDatabase(kassa, vereniging, OldOrganisation);
if (validUpdate > 0 & validUpdate2 > 0)
{
return(RedirectToAction("Index"));
}
return(View());
}
