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