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
{
}
}
}
