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