public string GenHash()
{
string opthash = "";
opthash += Mode;
opthash += Build;
opthash += Duration;
opthash += Leaver + Army + Kills + Income;
opthash += Startdate.ToString("yyyyMMdd");
opthash += Enddate.ToString("yyyyMMdd");
opthash += Interest;
opthash += Vs;
opthash += Player;
opthash += String.Join("", Dataset.OrderBy(o => o));
opthash += String.Join("", Gamemodes.Where(x => x.Value == true).OrderBy(o => o.Key).Select(s => s.Key));
opthash += String.Join("", Players.Where(x => x.Value == true).OrderBy(o => o.Key).Select(s => s.Key));
opthash += Breakpoint;
opthash += MengskPreviewFilter;
Hash = opthash;
return(opthash);
}
protected void BtnConsolidateRpt_Click(object sender, EventArgs e)
{
DateTime start = new DateTime();
DateTime Enddate = new DateTime();
if (txtStrtDate.Text.ToString() != "")
{
string[] date = new string[3];
date = txtStrtDate.Text.Trim().Split('/');
start = new DateTime(Convert.ToInt16(date[2]), Convert.ToInt16(date[1]), Convert.ToInt16(date[0]));
}
if (txtEndDate.Text.ToString() != "")
{
string[] enddate = new string[3];
enddate = txtEndDate.Text.Trim().Split('/');
Enddate = new DateTime(Convert.ToInt16(enddate[2]), Convert.ToInt16(enddate[1]), Convert.ToInt16(enddate[0]));
}
if (ChkExportExcel.Checked == true)
{
DataTable Dtb1 = new DataTable();
ArrayList Pa = new ArrayList();
ArrayList Pv = new ArrayList();
Pa.Add("@StartDate");
Pa.Add("@EndDate");
Pv.Add(txtStrtDate.Text.ToString() != "" ? start.ToString("yyyy/MM/dd") : "");
Pv.Add(txtEndDate.Text.ToString() != "" ? Enddate.ToString("yyyy/MM/dd") : "");
DBH.CreateDataTableCalender(Dtb1, "SP_ConSolidatedCalenderReports1", true, Pa, Pv);
ExportToExcel(Dtb1);
}
else
{
System.IO.MemoryStream stream1 = new System.IO.MemoryStream();
try
{
string Path = Server.MapPath("DeptWiseCalendarConsolidated.rpt");
Path = Path.Substring(0, Path.LastIndexOf('\\'));
Path = Path.Substring(0, Path.LastIndexOf('\\'));
Path = Path + "\\Report\\DeptWiseCalendarConsolidated.rpt";
myReportDocument.Load(Path);
//myReportDocument.SetDatabaseLogon("software", "DelFirMENA$idea", "192.168.167.207", "DB_SkylineCalendarEvents");
myReportDocument.SetDatabaseLogon("software", "DelFirMENA$idea");
if (txtStrtDate.Text.ToString() != "")
{
myReportDocument.SetParameterValue("@StartDate", start.ToString("yyyy/MM/dd"));
}
else
{
myReportDocument.SetParameterValue("@StartDate", "");
}
if (txtStrtDate.Text.ToString() != "")
{
myReportDocument.SetParameterValue("@EndDate", Enddate.ToString("yyyy/MM/dd"));
}
else
{
myReportDocument.SetParameterValue("@EndDate", "");
}
//stream1 = null;
//ExportOptions ex = myReportDocument.ExportOptions;
//ex.ExportFormatType = ExportFormatType.PortableDocFormat;
//ExportRequestContext x = new ExportRequestContext();
//x.ExportInfo = ex;
//stream1 = (System.IO.MemoryStream)myReportDocument.FormatEngine.ExportToStream(x);
//Response.Clear();
//Response.ContentType = "application/pdf";
//Response.BinaryWrite(stream1.ToArray());
//Response.End();
//stream1.Close();
System.IO.Stream oStream = null;
byte[] byteArray = null;
oStream = myReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byteArray = new byte[oStream.Length];
oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1));
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.BinaryWrite(byteArray);
Response.Flush();
Response.Close();
myReportDocument.Close();
myReportDocument.Dispose();
}
catch (Exception Ex)
{
// LogFile L = new LogFile();
// L.LogError("DisplayCalendar.aspx");
// L.LogError(Ex.Message.ToString());
// L.LogError(Session["User"].ToString());
// Response.Write(Ex.Message);
}
finally
{
}
}
}
protected void btnDate_Click(object sender, EventArgs e)
{
DateTime start = new DateTime();
DateTime Enddate = new DateTime();
if (txtStrtDate.Text.ToString() != "")
{
string[] date = new string[3];
date = txtStrtDate.Text.Trim().Split('/');
start = new DateTime(Convert.ToInt16(date[2]), Convert.ToInt16(date[1]), Convert.ToInt16(date[0]));
}
if (txtEndDate.Text.ToString() != "")
{
string[] enddate = new string[3];
enddate = txtEndDate.Text.Trim().Split('/');
Enddate = new DateTime(Convert.ToInt16(enddate[2]), Convert.ToInt16(enddate[1]), Convert.ToInt16(enddate[0]));
}
if (ChkExportExcel.Checked == true)
{
ArrayList pa = new ArrayList();
ArrayList pv = new ArrayList();
pa.Add("@EventTitle");
pa.Add("@Category1");
pa.Add("@Category2");
pa.Add("@Year");
pa.Add("@semester");
pa.Add("@ItemType");
pa.Add("@CalName");
pa.Add("@StartDate");
pa.Add("@EndDate");
pv.Add(drpEvent.SelectedValue);
pv.Add(DrpCat1.SelectedValue);
pv.Add(drpCat2.SelectedValue);
pv.Add(drpYear.SelectedValue);
pv.Add(drpSem.SelectedValue);
pv.Add(DrpType.SelectedValue);
pv.Add(DrpCalendar.SelectedValue);
pv.Add(txtStrtDate.Text.ToString() != "" ? start.ToString("yyyy/MM/dd"): "");
pv.Add(txtStrtDate.Text.ToString() != "" ? Enddate.ToString("yyyy/MM/dd"):"");
DataTable Dtb1 = new DataTable();
DBH.CreateDataTableCalender(Dtb1, "SP_DeptwiseEvent", true, pa, pv);
ExportToExcel(Dtb1);
}
else
{
System.IO.MemoryStream stream1 = new System.IO.MemoryStream();
try
{
string Path = Server.MapPath("DeptWiseCalendar1.rpt");
Path = Path.Substring(0, Path.LastIndexOf('\\'));
Path = Path.Substring(0, Path.LastIndexOf('\\'));
Path = Path + "\\Report\\DeptWiseCalendar1.rpt";
myReportDocument.Load(Path);
//myReportDocument.SetDatabaseLogon("software", "DelFirMENA$idea", "192.168.167.207", "DB_SkylineCalendarEvents");
myReportDocument.SetDatabaseLogon("software", "DelFirMENA$idea");
myReportDocument.SetParameterValue("@DeptName", DrpCalendar.SelectedItem.Text);
if (txtStrtDate.Text.ToString() != "")
{
myReportDocument.SetParameterValue("@StartDate", start.ToString("yyyy/MM/dd"));
}
else
{
myReportDocument.SetParameterValue("@StartDate", "");
}
if (txtStrtDate.Text.ToString() != "")
{
myReportDocument.SetParameterValue("@EndDate", Enddate.ToString("yyyy/MM/dd"));
}
else
{
myReportDocument.SetParameterValue("@EndDate", "");
}
myReportDocument.SetParameterValue("@EventTitle", drpEvent.SelectedValue);
myReportDocument.SetParameterValue("@Category1", DrpCat1.SelectedValue);
myReportDocument.SetParameterValue("@Category2", drpCat2.SelectedValue);
myReportDocument.SetParameterValue("@Year", drpYear.SelectedValue);
myReportDocument.SetParameterValue("@semester", drpSem.SelectedValue);
myReportDocument.SetParameterValue("@ItemType", DrpType.SelectedValue);
myReportDocument.SetParameterValue("@CalName", DrpCalendar.SelectedValue);
System.IO.Stream oStream = null;
byte[] byteArray = null;
oStream = myReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byteArray = new byte[oStream.Length];
oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1));
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.BinaryWrite(byteArray);
Response.Flush();
Response.Close();
myReportDocument.Close();
myReportDocument.Dispose();
}
catch (Exception Ex)
{
Response.Write(Ex.Message);
}
finally
{
}
}
}
