public void clear()
{
try {
clsDB DB = new clsDB();
DB.executeSQL("UPDATE tblUserSession SET SessionEnd = GETDATE() WHERE SessionEnd IS NULL AND User_PK=" + User_PK);
}
catch { }
HttpContext.Current.Session.Clear();
var sessionCookie = new HttpCookie("Advance_SessionID", lib.CompressString(HttpContext.Current.Session.SessionID));
sessionCookie.Domain = config.PortalURL();
sessionCookie.HttpOnly = true;
HttpContext.Current.Response.SetCookie(sessionCookie);
}
public static string[] getExportHeader(clsDB DB, string channel, string project, string projectGroup, string states, string status1, string status2, bool isIncludeStatus)
{
string sReturn = "";
DataSet ds = DB.getDS("rdb_getHeader '" + channel + "','" + project + "','" + projectGroup + "','" + states + "','" + status1 + "','" + status2 + "'", true);
DataTable dt;
dt = ds.Tables[2];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "Chase List~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Project~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[1];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^LOB~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[3];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^States~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
if (isIncludeStatus)
{
dt = ds.Tables[4];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Retrieval Chase Status~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[5];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Retrieval Chase Detail~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
///////////////////////
dt = ds.Tables[6];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Invoice Chase Status~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[7];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Invoice Chase Detail~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
///////////////////////
dt = ds.Tables[8];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Coding Chase Status~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[9];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Coding Chase Detail~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
///////////////////////
dt = ds.Tables[10];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^QA Coding Chase Status~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[11];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^QA Coding Chase Detail~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
}
return(sReturn.Split('^'));
}
