protected void Page_Load(object sender, EventArgs e) { if (!Base.IsAdmin(Session[Base.SESSION.ADMIN_LOGIN], Session[Base.SESSION.ADMIN_ID])) { Response.Redirect("./"); } if (!string.IsNullOrEmpty(Request["ID"]) && Base.GetGuid(Request["ID"]) != Guid.Empty) { SQLInterface SI = new SQLInterface(Base.DSN.ADMIN); A = Base.GetAnlass(Base.GetGuid(Request["ID"]), SI); if (A != null) { A.Soldaten = Base.GetAnswers(Base.GetSoldaten(A.AnlassID, SI), SI); } else { //Nice try Response.Redirect("./"); } SI.Dispose(); } else { //Nice try Response.Redirect("./"); } }
protected void Page_Load(object sender, EventArgs e) { if (!Base.IsAdmin(Session[Base.SESSION.ADMIN_LOGIN], Session[Base.SESSION.ADMIN_ID])) { Response.Redirect("./"); } Liste = new List <Base.Anlass>(); SQLInterface SI = new SQLInterface(Base.DSN.ADMIN); SQLRow[] RR = SI.ExecReader("SELECT AnlassID FROM Anlass ORDER BY Datum DESC, Zeit DESC"); foreach (SQLRow R in RR) { Base.Anlass A = Base.GetAnlass((Guid)R["AnlassID"], SI); A.Soldaten = Base.GetAnswers(Base.GetSoldaten(A.AnlassID, SI), SI); Liste.Add(A); } SI.Dispose(); Base.DelExcel(Server.MapPath("/temp/")); }
protected void Page_Load(object sender, EventArgs e) { if (!Base.IsAdmin(Session[Base.SESSION.ADMIN_LOGIN], Session[Base.SESSION.ADMIN_ID])) { Response.Redirect("./"); } if (!string.IsNullOrEmpty(Request["ID"]) && Base.GetGuid(Request["ID"]) != Guid.Empty) { string P = "/temp/" + Guid.NewGuid().ToString() + ".xls"; SQLInterface SI = new SQLInterface(Base.DSN.ADMIN); Base.Anlass A = Base.GetAnlass(Base.GetGuid(Request["ID"]), SI); Base.Frage[] FF = Base.GetFragen(SI); A.Soldaten = Base.GetAnswers(Base.GetSoldaten(A.AnlassID, SI), SI); string insertFormat = string.Join(",", string.Empty.PadLeft(FF.Length, '?').ToCharArray()); ExcelInterface EI = new ExcelInterface(Server.MapPath(P)); Response.Clear(); EI.Exec(string.Format("CREATE TABLE [Export](SVNummer varchar(255),Vorname varchar(255),Nachname varchar(255),Problematic varchar(255),{0})", Fragen2Cols(FF))); EI.Exec(string.Format("INSERT INTO [Export] VALUES(NULL,NULL,NULL,NULL,{0})", insertFormat), Fragen2Insert(FF)); foreach (Base.Soldat S in A.Soldaten) { EI.Exec(string.Format("INSERT INTO [Export] VALUES(?,?,?,?,{0})", insertFormat), S.SVNummer, S.Vorname, S.Nachname, S.Problematic?"Ja":"Nein", Poll2Values(S.Antworten)); } EI.Dispose(); SI.Dispose(); Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", string.Format("attachment; name=\"{0}.xls\"", A.Name.Replace('"', '\''))); Response.WriteFile(Server.MapPath(P), true); Response.Flush(); try { Base.DelExcel(Server.MapPath("/temp/")); } catch { } } }