protected void lnkSaveLegalActsSettings_Click(object sender, EventArgs e) { try { if (Page.IsValid) { if (fuLegalActsXslt.HasFile && fuLegalActsSchema.HasFile) { string schema = GetLegalActsSchema(fuLegalActsSchema); string xslt = GetLegalActsXslt(fuLegalActsXslt); LegalActsSettingsDTO legalActsSettings = dao.GetLegalActsSettings(); if (legalActsSettings != null) { dao.SaveLegalActSettings(legalActsSettings.ID, schema, xslt); } else { dao.AddLegalActSettings("1.0", schema, xslt); } LoadLegalActsSettings(); } else { lblMessage.Text = "W celu zapisania ustawieñ aktów prawnych nale¿y podaæ pliki XSD oraz XSL."; } } } catch (Exception ex) { lblMessage.Text = ex.Message; } }
private void LoadLegalActsSettings() { LegalActsSettingsDTO legalActsSettings = dao.GetLegalActsSettings(); if (legalActsSettings != null) { lblLegalActsSettingsVersion.Text = "Wersja: " + legalActsSettings.Version; lnkCurrentSchema.Visible = true; lnkCurrentXslt.Visible = true; } else { lblLegalActsSettingsVersion.Text = "Brak bie¿¹cych ustawieñ."; lnkCurrentSchema.Visible = false; lnkCurrentXslt.Visible = false; } }
protected void lnkCurrentSchema_Click(object sender, EventArgs e) { LegalActsSettingsDTO legalActsSettings = dao.GetLegalActsSettings(); if (legalActsSettings != null) { byte[] buff = Encoding.UTF8.GetBytes(legalActsSettings.Schema); Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("Content-Length", buff.Length.ToString()); Response.AddHeader("Content-Disposition", "attachment; filename=\"akt-prawny.xsd\""); Response.ContentType = "text/xml"; Response.OutputStream.Write(buff, 0, buff.Length); Response.Flush(); Response.Close(); } }
public LegalActsSettingsDTO GetLegalActsSettings() { SqlDatabase db = DatabaseFactory.CreateDatabase() as SqlDatabase; if (db == null) { throw new Exception("Do poprawnego działania wymagany jest SQL Server 2005!"); } LegalActsSettingsDTO settings = null; DbCommand cmd = db.GetStoredProcCommand("Dokumenty.pobierzUstawieniaAktuPrawnego"); using (IDataReader dr = db.ExecuteReader(cmd)) { if (dr.Read()) { settings = new LegalActsSettingsDTO(int.Parse(dr["id"].ToString()), dr["numerWersji"].ToString(), (DateTime)dr["dataUtworzenia"], dr["xsd"].ToString(), dr["xslt"].ToString()); } }; return(settings); }