public static RegisterPM CreatePM(IDataRecord record)
{
int organisationID;
Int32.TryParse(record["OrganisationID"].ToString(), out organisationID);
Registers r = new Registers()
{
ID = Int32.Parse(record["ID"].ToString()),
RegisterName = record["RegisterName"].ToString(),
Device = record["Device"].ToString(),
PurchaseDate = DateTime.Parse(record["PurchaseDate"].ToString()),
ExpiresDate = DateTime.Parse(record["ExpiresDate"].ToString())
};
Organisations o;
if (organisationID > 0)
{
o = OrganisationDA.GetOrganisation(organisationID);
}
else
{
o = null;
}
return(new RegisterPM()
{
Kassa = r,
Vereniging = o
});
}
public static int UpdateOrganisationDatabase(int rID, int oID, int old_oID)
{
Registers r = GetRegister(rID);
Organisations o = OrganisationDA.GetOrganisation(oID);
Organisations o2 = OrganisationDA.GetOrganisation(old_oID);
ConnectionStringSettings connectionstring = Database.CreateConnectionString("System.Data.SqlClient", "JUSTIJN\\SQLEXPRESS", o.DbName, o.DbLogin, o.DbPassword);
string sql = "INSERT INTO Register VALUES (@RegisterName, @Device)";
DbParameter par1 = Database.AddParameter(CON, "@RegisterName", r.RegisterName);
DbParameter par2 = Database.AddParameter(CON, "@Device", r.Device);
int ValidUpdate = Database.InsertData(Database.GetConnection(connectionstring), sql, par1, par2);
int ValidUpdate2;
if (old_oID > 0)
{
ConnectionStringSettings connectionstring2 = Database.CreateConnectionString("System.Data.SqlClient", "JUSTIJN\\SQLEXPRESS", o2.DbName, o2.DbLogin, o2.DbPassword);
string sql2 = "DELETE FROM Register WHERE RegisterName=@RegisterName";
DbParameter par3 = Database.AddParameter(CON, "@RegisterName", r.RegisterName);
ValidUpdate2 = Database.ModifyData(Database.GetConnection(connectionstring2), sql2, par3);
}
else
{
ValidUpdate2 = 1;
}
if (ValidUpdate > 0 & ValidUpdate2 > 0)
{
return(1);
}
else
{
return(0);
}
}
