protected void btnPrivatePreview_Click(object sender, EventArgs e)
{
CrystalReport report = new CrystalReport(Server.MapPath("~/MODULES/LJMS/REPORTS/PrivateLawyerCount.rpt"), "LJMS_ADMIN", "LJMS_ADMIN");
report.SelectionCriteria = " 1 = 1 ";
if (this.ddlUnit.SelectedIndex > 0)
{
report.SelectionCriteria += " and {VW_UNIT_LAWYER_TYPE_WISE_CNT.unit_id} = " + this.ddlUnit.SelectedValue;
}
if (this.ddlPLawyerType.SelectedIndex > 0)
{
report.SelectionCriteria += " and {VW_UNIT_LAWYER_TYPE_WISE_CNT.lawyer_type_id} = " + this.ddlPLawyerType.SelectedValue;
}
Session["LJMSReport"] = report;
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('../ReportForms/CommonReportViewer.aspx', 'popup','width=780,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=yes,toolbar=no');";
script += "</script>";
this.ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
Session["CMS_REPORT"] = null;
CrystalReport objReport = new CrystalReport();
objReport.SelectionCriteria = SetCriteria();
objReport.ReportName = Server.MapPath("~") + "/MODULES/CMS/Reports/SectionWiseCase.rpt";
// objReport.FormulaList.Add(new ReportFormulaFields("OrgName", DDLOrg.SelectedItem.Text.Trim()));
//objReport.FormulaList.Add(new ReportFormulaFields("OrgAddress", "Ram Sah Path"));
objReport.UserID = "CMS_ADMIN";
objReport.Password = "******";
Session["CMS_REPORT"] = objReport;
Session["CMS_REPORT_TITLE"] = "CMS | Section Clerk Case Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
this.ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
void BindReport()
{
CrystalReport report = (CrystalReport)Session["PMSReport"];
ReportDocument mainDoc = new ReportDocument();
mainDoc.Load(report.ReportName);
mainDoc.RecordSelectionFormula = report.SelectionCriteria;
mainDoc.Refresh();
foreach (ReportParameter param in report.ParamList)
{
mainDoc.SetParameterValue(param.ParamName, param.ParamValue);
}
foreach (ReportFormulaFields formula in report.FormulaList)
{
mainDoc.DataDefinition.FormulaFields[formula.FormulaName].Text = "'" + formula.FormulaValue.ToString() + "'";
}
foreach (SubReport sr in report.SubReportList)
{
foreach (ReportParameter param in sr.ParamList)
{
mainDoc.SetParameterValue(param.ParamName, param.ParamValue, sr.SubReportName);
}
}
mainDoc.SetDatabaseLogon(report.UserID, report.Password, "ICTNJDB", "");
this.rptComViewer.ReportSource = mainDoc;
}
protected void btnGenerateRpt_Click(object sender, EventArgs e)
{
try
{
CrystalReport report = new CrystalReport();
report.ReportName = Server.MapPath("~") + "/MODULES/LJMS/Reports/JudgePropertyDetailsReport.rpt";
report.UserID = "PMS_ADMIN";
report.Password = "******";
report.SelectionCriteria = setCriteria();
if (report.SelectionCriteria != "")
{
Session["PMSReport"] = report;
Session["PmsReportTitle"] = null;
Session["PmsReportTitle"] = "LJMS | Property Details Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
else
{
lblSearchResult.Text = " कृपया चेकबक्समा कि्ल्क गर्नुहोस् ... ";
}
}
catch (Exception ex)
{
throw(ex);
}
}
protected void btnGenerateReport_Click(object sender, EventArgs e)
{
try
{
CrystalReport report = new CrystalReport();
report.SelectionCriteria = SelectionCriteria();
//report.SelectionCriteria = "";
report.UserID = "OAS_ADMIN";
report.Password = "******";
report.ReportName = Server.MapPath("~") + "\\MODULES\\OAS\\REPORTS\\Appointment.rpt";
Session["OASReport"] = report;
Session["OASReportTitle"] = null;
Session["OASReportTitle"] = "OAS | Meeting Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
catch (Exception ex)
{
throw (ex);
}
}
void Print(int empid, int desid)
{
try
{
CrystalReport report = new CrystalReport();
report.SelectionCriteria = SelectionCriteria();
report.ReportName = Server.MapPath("~") + "/MODULES/PMS/Reports/EmployeeLeaveDetails.rpt";
report.FormulaList.Add(new ReportFormulaFields("OrgName", ((ATTUserLogin)Session["Login_User_Detail"]).OrgName));
report.FormulaList.Add(new ReportFormulaFields("OrgAddress", ((ATTUserLogin)Session["Login_User_Detail"]).OrgAddress));
report.ParamList.Add(new ReportParameter("P_EMP_ID", null));
//objReport.ParamList.Add(new ReportParameter("Report Name", "Employee Posting Information"));
//report.FormulaList.Add(new ReportFormulaFields("Date", DateTime.Now.ToShortDateString()));
report.UserID = "PMS_ADMIN";
report.Password = "******";
Session["PMSReport"] = report;
Session["PmsReportTitle"] = null;
Session["PmsReportTitle"] = "PMS | Employee Leave Details Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
//Response.Redirect("~/MODULES/PMS/ReportForms/CommonReportViewer.aspx");
}
catch (Exception)
{
this.lblStatusMessage.Text = "Report Cannot be loaded";
this.programmaticModalPopup.Show();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Session["CMS_REPORT"] = null;
CrystalReport objReport = new CrystalReport();
objReport.SelectionCriteria = SetCriteria();
objReport.ReportName = Server.MapPath("~") + "/MODULES/CMS/Reports/A_6_FY.rpt";
string txtFY = this.txtFY_RQD.Text.Trim();
string strFYFrom = txtFY.Substring(0, 2);
objReport.ParamList.Add(new ReportParameter("P_FY", strFYFrom));
objReport.FormulaList.Add(new ReportFormulaFields("FY", txtFY));
objReport.UserID = "CMS_ADMIN";
objReport.Password = "******";
Session["CMS_REPORT"] = objReport;
Session["CMS_REPORT_TITLE"] = "CMS | Registration Type Wise Case Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
this.ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
void Print(int empID)
{
CrystalReport objReport = new CrystalReport();
//Report objReport = new Report();
objReport.SelectionCriteria = "{VW_PERSON_ADDRESS_INFO.P_ID} =" + empID.ToString();
objReport.ReportName = Server.MapPath("~") + "/MODULES/LJMS/Reports/JudgeBioData.rpt";
objReport.UserID = "ICTNJ_OWNER";
objReport.Password = "******";
objReport.ParamList.Add(new ReportParameter("OrgName", "LJMS"));
objReport.ParamList.Add(new ReportParameter("OrgAddress", "PCS"));
objReport.ParamList.Add(new ReportParameter("ReportName", "Bio Data"));
//objReport.ParamList.Add(new ReportParameter("Date", DateTime.Now.ToShortDateString()));
Session["LJMSReport"] = objReport;
Session["LJMSReportTitle"] = null;
Session["LJMSReportTitle"] = "LJMS | Employee Bio-Data";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
protected void btnPrint_Click(object sender, EventArgs e)
{
try
{
CrystalReport report = new CrystalReport();
report.SelectionCriteria = SelectionCriteria();
//report.SelectionCriteria = "";
//report.FormulaList.Add(new ReportFormulaFields("txtDet", HtmlEditor.Text));
//report.ParamList.Add(new ReportParameter("txtDetails", HtmlEditor.Text));
report.UserID = "OAS_ADMIN";
report.Password = "******";
report.ReportName = Server.MapPath("~") + "\\MODULES\\OAS\\REPORTS\\Letter.rpt";
Session["OASReport"] = report;
Session["OASReportTitle"] = null;
Session["OASReportTitle"] = "OAS | Letter Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('../ReportForms/CommonReportViewer.aspx', 'popup','width=790,height=600,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
catch (Exception ex)
{
throw(ex);
}
}
//string SetCriteria()
//{
// string strFormula = "1 = 1";
// if (this.ddlOrgName.SelectedIndex > 0)
// strFormula += " AND {wv_org_designation_status.org_id}=" + int.Parse(this.ddlOrgName.SelectedValue);
// if (this.ddlPost.SelectedIndex > 0)
// strFormula += " AND {wv_org_designation_status.des_id}=" + int.Parse(this.ddlPost.SelectedValue);
// return strFormula;
//}
protected void btnCreate_Click(object sender, EventArgs e)
{
try
{
CrystalReport report = new CrystalReport();
report.ReportName = Server.MapPath("~") + "/MODULES/PMS/Reports/OrgdesignationStatusInfo.rpt";
report.UserID = "PMS_ADMIN";
report.Password = "******";
report.SelectionCriteria = SetCriteria();
if (report.SelectionCriteria != "")
{
Session["PMSReport"] = report;
Session["PmsReportTitle"] = null;
Session["PmsReportTitle"] = "PMS | Designation Status Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
else
{
this.lblStatusMessage.Text = "All Fields Cannot Be Empty.";
this.programmaticModalPopup.Show();
}
}
catch (Exception ex)
{
throw (ex);
}
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
if (RDLTime.SelectedIndex == 1 && txtFromDate_RQD.Text == "____/__/__" && txtToDate_RQD.Text == "____/__/__")
{
lblStatusMessage.Text = "Please Enter From date and To Date First";
programmaticModalPopup.Show();
return;
}
if (RDLTime.SelectedIndex == 0 && txtFromDate_RQD.Text == "____/__/__")
{
lblStatusMessage.Text = "Please Enter From date First";
programmaticModalPopup.Show();
return;
}
if (RDLTime.SelectedIndex == 1)
{
if ((txtFromDate_RQD.Text.Trim().CompareTo(txtToDate_RQD.Text.Trim())) > 0)
{
lblStatusMessage.Text = "From Date must be smaller then To Date";
programmaticModalPopup.Show();
return;
}
DateTime dt1 = DateTime.Parse(txtFromDate_RQD.Text.Trim());
DateTime dt2 = DateTime.Parse(txtToDate_RQD.Text.Trim());
TimeSpan t1 = dt2.Subtract(dt1) + new TimeSpan(1, 0, 0, 0);
if (t1 >= new TimeSpan(7, 0, 0, 0))
{
lblStatusMessage.Text = "Enter Date shouldn't be greater then one week";
programmaticModalPopup.Show();
return;
}
}
Session["CMS_REPORT"] = null;
CrystalReport objReport = new CrystalReport();
objReport.SelectionCriteria = SetCriteria();
objReport.ReportName = Server.MapPath("~") + "/MODULES/CMS/Reports/CauseList.rpt";
objReport.FormulaList.Add(new ReportFormulaFields("OrgName", DDLOrg.SelectedItem.Text.Trim()));
objReport.FormulaList.Add(new ReportFormulaFields("OrgAddress", "Ram Sah Path"));
objReport.UserID = "CMS_ADMIN";
objReport.Password = "******";
Session["CMS_REPORT"] = objReport;
Session["CMS_REPORT_TITLE"] = "CMS | Cause List";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
this.ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
CrystalReport report = new CrystalReport();
report.SelectionCriteria = SetCriteria();
if (ddlReportType.SelectedIndex <= 0)
{
this.lblStatus.Text = "Please Select The Report Type";
this.lblStatusMessage.Text = "Report Type Must Be Selected";
this.programmaticModalPopup.Show();
return;
}
if (ddlReportType.SelectedIndex == 1)
{
report.ReportName = Server.MapPath("~") + "/MODULES/LJMS/Reports/JudgePostingOrganization.rpt";
}
else if (ddlReportType.SelectedIndex == 2)
{
report.ReportName = Server.MapPath("~") + "/MODULES/LJMS/Reports/JudgePostingSewa.rpt";
}
else if (ddlReportType.SelectedIndex == 3)
{
report.ReportName = Server.MapPath("~") + "/MODULES/LJMS/Reports/JudgePostingDesignation.rpt";
}
//ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
report.UserID = "PMS_ADMIN";
report.Password = "******";
report.FormulaList.Add(new ReportFormulaFields("OrgName", "Supreme Court"));
report.FormulaList.Add(new ReportFormulaFields("OrgAddress", "Kathmandu"));
//objReport.ParamList.Add(new ReportParameter("Report Name", "Employee Posting Information"));
report.FormulaList.Add(new ReportFormulaFields("Date", DateTime.Now.ToShortDateString()));
Session["LJMSReport"] = report;
Session["LJMSReportTitle"] = null;
Session["LJMSReportTitle"] = "LJMS | Employee Posting Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
//Response.Redirect("~/MODULES/PMS/ReportForms/CommonReportViewer.aspx");
}
catch (Exception ex)
{
this.lblStatus.Text = "Error Loading Report";
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
return;
}
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
try
{
if (ddlItemsType.SelectedIndex > 0)
{
string orgName = "Supreme Court";
string orgAddress = "Ramshah Path,Kathmandu";
string reportName = "OAS | Inventory Item Transfer Details";
#region date
//if (txtFromDate.Text != "" || txtToDate.Text != "")
//{
// if ((txtFromDate.Text).CompareTo(txtToDate.Text) > 0)
// {
// this.lblStatusMessage.Text = "From Date must be smaller then ToDate";
// this.programmaticModalPopup.Show();
// return;
// }
//}
#endregion
CrystalReport objReport = new CrystalReport();
objReport.SelectionCriteria = SetCriteria();
objReport.UserID = "OAS_OWNER";
objReport.Password = "******";
int itemType = int.Parse(ddlItemsType.SelectedValue);
if (itemType == 1)
{
objReport.ReportName = Server.MapPath("~") + "/MODULES/OAS/Inventory/Reports/InvItemsTransferedKBJ.rpt";
}
else if (itemType == 2)
{
objReport.ReportName = Server.MapPath("~") + "/MODULES/OAS/Inventory/Reports/InvItemsTransferedKNJ.rpt";
}
objReport.ParamList.Add(new ReportParameter("orgName", orgName));
objReport.ParamList.Add(new ReportParameter("orgAddress", orgAddress));
objReport.ParamList.Add(new ReportParameter("ReportName", reportName));
Session["OASReport"] = objReport;
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
this.ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
ClearControls();
}
else
{
this.lblStatusMessage.Text = "Select Items Type";
this.programmaticModalPopup.Show();
}
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
CrystalReport newReport = new CrystalReport();
newReport.SetDataSource(GetDataset(TransactionController.GetTransactions()));
DTReportViewer.ReportSource = newReport;
}
private void button_CrystalReport_Click(object sender, EventArgs e)
{
LocalBikesPlatform_Fall14.Accounting.AccountsReceivable.CrystalReport1
rept = new LocalBikesPlatform_Fall14.Accounting.AccountsReceivable.CrystalReport1();
CrystalReport CR_Form = new CrystalReport();
CR_Form.crystalReportViewer1.ReportSource = rept;
CR_Form.Show();
}
private void button1_Click(object sender, EventArgs e)
{
Form6 f6 = new Form6();
CrystalReport cr = new CrystalReport();
TextObject text = (TextObject)cr.ReportDefinition.Sections["Section3"].ReportObjects["Text1"];
text.Text = textBox1.Text;
f6.crystalReportViewer1.ReportSource = cr;
f6.Show();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Role"] == null || Session["Role"].ToString() != UserHandler.findUserRole("U002").UserRoleId.ToString())
{
Response.Redirect("/View/Login.aspx");
}
CrystalReport tr = new CrystalReport();
CrystalReportViewer1.ReportSource = tr;
tr.SetDataSource(GetData(TransactionRepository.getTransaction()));
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
try
{
CrystalReport report = new CrystalReport();
report.SelectionCriteria = SetCriteria();
if (ddlReportType.SelectedIndex <= 0)
{
this.lblStatus.Text = "Please Select The Report Type";
this.lblStatusMessage.Text = "Report Type Must Be Selected";
this.programmaticModalPopup.Show();
return;
}
if (ddlReportType.SelectedIndex == 1)
{
report.ReportName = Server.MapPath("~") + "/MODULES/PMS/Reports/OrganizationPosts.rpt";
}
else if (ddlReportType.SelectedIndex == 2)
{
report.ReportName = Server.MapPath("~") + "/MODULES/PMS/Reports/OrganizationPosts.rpt";
}
else if (ddlReportType.SelectedIndex == 3)
{
report.ReportName = Server.MapPath("~") + "/MODULES/PMS/Reports/EmployeeVisitCountry.rpt";
}
report.FormulaList.Add(new ReportFormulaFields("OrgName", ((ATTUserLogin)Session["Login_User_Detail"]).OrgName));
report.UserID = "PMS_ADMIN";
report.Password = "******";
Session["PMSReport"] = report;
Session["PmsReportTitle"] = null;
Session["PmsReportTitle"] = "PMS | Employee Current Post Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
catch (Exception ex)
{
this.lblStatus.Text = "Error Loading Report";
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
return;
}
}
void GenerateBioData(double PID)
{
if (this.User.MenuList.ContainsKey("2,36,2") == false)
{
Response.Write("<b>Insufficient previlege to view lawyer bio-data.");
Response.End();
return;
}
CrystalReport report = new CrystalReport(Server.MapPath("~/MODULES/LJMS/REPORTS/LawyerBioData.rpt"), "LJMS_ADMIN", "LJMS_ADMIN");
report.SelectionCriteria = " {VW_PERSON_ADDRESS_INFO.P_ID} = " + PID.ToString();
SubReport Phone = new SubReport();
Phone.SubReportName = "EmpPhone";
Phone.ParamList.Add(new ReportParameter("P_P_ID", PID));
Phone.ParamList.Add(new ReportParameter("P_ACTIVE", "Y"));
report.SubReportList.Add(Phone);
SubReport PermAddress = new SubReport();
PermAddress.SubReportName = "EmpPermAddress";
PermAddress.ParamList.Add(new ReportParameter("P_P_ID", PID));
PermAddress.ParamList.Add(new ReportParameter("P_ACTIVE", "Y"));
report.SubReportList.Add(PermAddress);
SubReport Email = new SubReport();
Email.SubReportName = "EmpEmail";
Email.ParamList.Add(new ReportParameter("P_P_ID", PID));
Email.ParamList.Add(new ReportParameter("P_ACTIVE", "Y"));
report.SubReportList.Add(Email);
SubReport TempAddress = new SubReport();
TempAddress.SubReportName = "EmpTempAddress";
TempAddress.ParamList.Add(new ReportParameter("P_P_ID", PID));
TempAddress.ParamList.Add(new ReportParameter("P_ACTIVE", "Y"));
report.SubReportList.Add(TempAddress);
Session["LJMSReport"] = report;
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('../ReportForms/CommonReportViewer.aspx', 'popup','width=780,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=yes,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
Session["CMS_REPORT"] = null;
if (DDLYear.SelectedIndex == 0)
{
lblStatusMessage.Text = "Please Select Year First";
programmaticModalPopup.Show();
return;
}
if (DDLMonth.SelectedIndex == 0)
{
lblStatusMessage.Text = "Please Select Month First";
programmaticModalPopup.Show();
return;
}
CrystalReport objReport = new CrystalReport();
objReport.ReportName = Server.MapPath("~") + "/MODULES/CMS/Reports/F_11_M.rpt";
objReport.SelectionCriteria = SetCriteria();
string fromDate = "'" + int.Parse(DDLYear.SelectedValue) + "/0" + int.Parse(DDLMonth.SelectedValue) + "/0" + 01 + "'";
string toDate = "'" + int.Parse(DDLYear.SelectedValue) + "/0" + (int.Parse(DDLMonth.SelectedValue) + 1) + "/0" + 01 + "'";
objReport.ParamList.Add(new ReportParameter("P_REG_FROM_DATE", fromDate));
objReport.ParamList.Add(new ReportParameter("P_REG_TO_DATE", toDate));
objReport.FormulaList.Add(new ReportFormulaFields("Year", DDLYear.SelectedValue));
objReport.FormulaList.Add(new ReportFormulaFields("Month", DDLMonth.SelectedItem.Text));
objReport.UserID = "CMS_ADMIN";
objReport.Password = "******";
Session["CMS_REPORT"] = objReport;
Session["CMS_REPORT_TITLE"] = "CMS | Subject Wise Case Summary Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
this.ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
CrystalReport report = new CrystalReport(Server.MapPath("~/MODULES/LIS/REPORTS/Materail Detail Report.rpt"), "LIS_ADMIN", "LIS_ADMIN");
report.SelectionCriteria = " 1 = 1 ";
if (this.ddlOrg.SelectedIndex > 0)
{
report.SelectionCriteria += " and {VW_LIB_MATERIAL_MASTER_INFO.ORG_ID} = " + this.ddlOrg.SelectedValue;
}
if (this.ddlLibrary.SelectedIndex > 0)
{
report.SelectionCriteria += " and {VW_LIB_MATERIAL_MASTER_INFO.library_ID} = " + this.ddlLibrary.SelectedValue;
}
if (this.txtCallNo.Text.Trim() != "")
{
report.SelectionCriteria += " and {VW_LIB_MATERIAL_MASTER_INFO.call_no} = '" + this.txtCallNo.Text.Trim() + "'";
}
if (this.ddlCategory.SelectedIndex > 0)
{
report.SelectionCriteria += " and {VW_LIB_MATERIAL_MASTER_INFO.category_ID} = " + this.ddlCategory.SelectedValue;
}
if (this.ddlType.SelectedIndex > 0)
{
report.SelectionCriteria += " and {VW_LIB_MATERIAL_MASTER_INFO.mt_id} = " + this.ddlType.SelectedValue;
}
if (this.ddlPublisherType.SelectedIndex > 0)
{
//report.SelectionCriteria += " and {VW_LIB_MATERIAL_MASTER_INFO.publisher_ID} = " + this.ddlPublisherType.SelectedValue;
}
Session["LISReport"] = report;
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=1000,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=yes,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
Session["CMS_REPORT"] = null;
if (txtFY_RQD.Text == "__/__")
{
lblStatusMessage.Text = "Please Enter Fysical Year First";
programmaticModalPopup.Show();
return;
}
CrystalReport objReport = new CrystalReport();
objReport.ReportName = Server.MapPath("~") + "/MODULES/CMS/Reports/F_11_FY.rpt";
objReport.SelectionCriteria = SetCriteria();
string txtFY = this.txtFY_RQD.Text.Trim();
string strFYFrom = txtFY.Substring(0, 2);
string strFyTo = txtFY.Substring(3, 2);
string FromDate = "20" + strFYFrom + "/" + "04" + "/" + "01";
string ToDate = "20" + strFyTo + "/" + "04" + "/" + "01";
objReport.ParamList.Add(new ReportParameter("P_REG_FROM_DATE", FromDate));
objReport.ParamList.Add(new ReportParameter("P_REG_TO_DATE", ToDate));
objReport.FormulaList.Add(new ReportFormulaFields("FY", txtFY_RQD.Text.Trim()));
//objReport.FormulaList.Add(new ReportFormulaFields("Month", DDLMonth.SelectedItem.Text));
objReport.UserID = "CMS_ADMIN";
objReport.Password = "******";
Session["CMS_REPORT"] = objReport;
Session["CMS_REPORT_TITLE"] = "CMS | Subject Wise Case Summary Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
this.ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
void BindReport()
{
DateTime t1 = DateTime.Now;
CrystalReport report = (CrystalReport)Session[this.GetReportSessionName()];
ReportDocument mainDoc = new ReportDocument();
mainDoc.Load(report.ReportName, OpenReportMethod.OpenReportByDefault);
mainDoc.RecordSelectionFormula = report.SelectionCriteria;
mainDoc.Refresh();
foreach (ReportParameter param in report.ParamList)
{
mainDoc.SetParameterValue(param.ParamName, param.ParamValue);
}
foreach (ReportFormulaFields formula in report.FormulaList)
{
mainDoc.DataDefinition.FormulaFields[formula.FormulaName].Text = "'" + formula.FormulaValue.ToString() + "'";
}
foreach (SubReport sr in report.SubReportList)
{
foreach (ReportParameter param in sr.ParamList)
{
mainDoc.SetParameterValue(param.ParamName, param.ParamValue, sr.SubReportName);
}
}
mainDoc.SetDatabaseLogon("oas_admin", "oasadm1npa$$", "ICTNJDB", "");
//mainDoc.SetDatabaseLogon("oas_admin", "oas_admin", "ICTNJDB", "");
this.rptComViewer.ReportSource = mainDoc;
Session[this.GetDocumentSessionName()] = mainDoc;
DateTime t2 = DateTime.Now;
TimeSpan s = t2.Subtract(t1);
this.lblEllapsedTime.Text = "Ellapsed time: " + s.TotalMilliseconds.ToString() + " Millisecond(s)";
}
protected void btnView_Click(object sender, EventArgs e)
{
if (grdEmployee.SelectedIndex > -1)
{
try
{
CrystalReport report = new CrystalReport();
report.SelectionCriteria = SelectionCriteria();
report.UserID = "PMS_ADMIN";
report.Password = "******";
report.ReportName = Server.MapPath("~") + "/MODULES/PMS/Reports/EmployeeMedicalExpenses.rpt";
report.FormulaList.Add(new ReportFormulaFields("OrgName", ((ATTUserLogin)Session["Login_User_Detail"]).OrgName));
report.FormulaList.Add(new ReportFormulaFields("OrgAddress", ((ATTUserLogin)Session["Login_User_Detail"]).OrgAddress));
Session["PMSReport"] = report;
Session["PmsReportTitle"] = null;
Session["PmsReportTitle"] = "PMS | Employee Medical Expenses Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
catch (Exception ex)
{
this.lblStatusMessage.Text = "Error Loading Report";
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
return;
}
}
else
{
this.lblStatusMessage.Text = "कर्मचारी छान्नुहोस्";
this.programmaticModalPopup.Show();
}
}
void BindReport()
{
try
{
if (Session["OASReport"] != null)
{
CrystalReport report = (CrystalReport)Session["OASReport"];
ReportDocument mainDoc = new ReportDocument();
mainDoc.Load(report.ReportName);
mainDoc.RecordSelectionFormula = report.SelectionCriteria;
mainDoc.Refresh();
foreach (ReportParameter param in report.ParamList)
{
mainDoc.SetParameterValue(param.ParamName, param.ParamValue);
}
foreach (ReportFormulaFields formula in report.FormulaList)
{
mainDoc.DataDefinition.FormulaFields[formula.FormulaName].Text = "'" + formula.FormulaValue.ToString() + "'";
}
foreach (SubReport sr in report.SubReportList)
{
foreach (ReportParameter param in sr.ParamList)
{
mainDoc.SetParameterValue(param.ParamName, param.ParamValue, sr.SubReportName);
}
}
mainDoc.SetDatabaseLogon("oas_admin", "oasadm1npa$$", "ICTNJDB", "");
this.rptComViewer.ReportSource = mainDoc;
}
}
catch (Exception ex)
{
throw(ex);
}
}
protected void btnCreate_Click(object sender, EventArgs e)
{
CrystalReport objReport = new CrystalReport();
objReport.ReportName = Server.MapPath("~") + "/MODULES/OAS/Inventory/Reports/AuctionDetailsReport.rpt";
objReport.SelectionCriteria = SetCriteria();
objReport.UserID = "OAS_ADMIN";
objReport.Password = "******";
Session["OASReport"] = objReport;
Session["OASReportTitle"] = null;
Session["OASReportTitle"] = "OAS |Auction Details";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += " var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "OAS", script);
}
protected void btnView_Click(object sender, EventArgs e)
{
CrystalReport report = new CrystalReport();
report.SelectionCriteria = SelectionCriteria();
if (this.grdEmployee.SelectedIndex > -1)
{
report.ReportName = Server.MapPath("~") + "/MODULES/PMS/Reports/EmployeeWorkDistributionEmp.rpt";
}
else if (this.ddlOrganization.SelectedIndex > 0 || this.ddlOrgUnit.SelectedIndex > 0 || txtFromDate.Text != "" || txtToDate.Text != "")
{
report.ReportName = Server.MapPath("~") + "/MODULES/PMS/Reports/EmployeeWorkDistributionOrg.rpt";
}
else
{
report.ReportName = Server.MapPath("~") + "/MODULES/PMS/Reports/EmployeeWorkDistributionOrg.rpt";
}
report.FormulaList.Add(new ReportFormulaFields("OrgName", ((ATTUserLogin)Session["Login_User_Detail"]).OrgName));
report.FormulaList.Add(new ReportFormulaFields("OrgAddress", ((ATTUserLogin)Session["Login_User_Detail"]).OrgAddress));
report.UserID = "PMS_ADMIN";
report.Password = "******";
Session["PMSReport"] = report;
Session["PmsReportTitle"] = null;
Session["PmsReportTitle"] = "PMS | EmployeeWorkDistribution Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
this.ddlOrganization.Enabled = true;
this.ddlOrgUnit.Enabled = true;
this.txtFromDate.Enabled = true;
this.txtToDate.Enabled = true;
}
protected void viewDeputationRpt_Btn_Click(object sender, EventArgs e)
{
CrystalReport report = new CrystalReport();
report.ReportName = Server.MapPath("~") + "/MODULES/PMS/REPORTS/EmployeeDeputationHistory.rpt";
report.SelectionCriteria = GetSelectionFormula();
if (count == 0)
{
this.lblStatusMessage.Text = "No data selected";
this.programmaticModalPopup.Show();
return;
}
report.UserID = "PMS_ADMIN";
report.Password = "******";
Session["PMSReport"] = report;
Session["PmsReportTitle"] = null;
Session["PmsReportTitle"] = "PMS | Employee Deputation History Report";
report.ParamList.Add(new ReportParameter("OrgName", ((ATTUserLogin)Session["Login_User_Detail"]).OrgName));
report.ParamList.Add(new ReportParameter("OrgAddress", ((ATTUserLogin)Session["Login_User_Detail"]).OrgAddress));
//report.ParamList.Add(new ReportParameter("Date", Session["NepDate"].ToString()));
Session["PMSReport"] = report;
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
void Print(int EmpID, int DesID)
{
CrystalReport report = new CrystalReport();
//report.SelectionCriteria = "{vw_emp_posting.EMP_ID}=1";
report.SelectionCriteria = "{vw_emp_posting.EMP_ID}=" + EmpID.ToString() + " AND {vw_emp_posting.DES_ID}=" + DesID.ToString();
report.ReportName = Server.MapPath("~") + "/MODULES/PMS/Reports/EmployeeWiseApplicableLeave.rpt";
report.UserID = "PMS_ADMIN";
report.Password = "******";
SubReport sub1 = new SubReport();
sub1.SubReportName = "By Designation";
sub1.ParamList.Add(new ReportParameter("p_des_id", System.DBNull.Value));
sub1.ParamList.Add(new ReportParameter("p_leave_type_id", System.DBNull.Value));
SubReport sub2 = new SubReport();
sub2.SubReportName = "By Employee";
sub2.ParamList.Add(new ReportParameter("p_emp_id", System.DBNull.Value));
sub2.ParamList.Add(new ReportParameter("p_leave_type_id", System.DBNull.Value));
report.SubReportList.Add(sub1);
report.SubReportList.Add(sub2);
Session["PMSReport"] = report;
Session["PmsReportTitle"] = null;
Session["PmsReportTitle"] = "PMS |Leave For Employee Report";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
void Print(int empID)
{
CrystalReport objReport = new CrystalReport();
//Report objReport = new Report();
objReport.SelectionCriteria = "{VW_PERSON_ADDRESS_INFO.P_ID} =" + empID.ToString();
objReport.ReportName = Server.MapPath("~") + "/MODULES/PMS/Reports/EmployeeBioData.rpt";
objReport.UserID = "PMS_ADMIN";
objReport.Password = "******";
Session["PMSReport"] = objReport;
Session["PmsReportTitle"] = null;
Session["PmsReportTitle"] = "PMS | Employee Bio-Data";
//objReport.ParamList.Add(new ReportParameter("OrgName", "PMS"));
//objReport.ParamList.Add(new ReportParameter("OrgAddress", "PCS"));
//objReport.ParamList.Add(new ReportParameter("ReportName", "Bio Data"));
////objReport.ParamList.Add(new ReportParameter("Date", DateTime.Now.ToShortDateString()));
SubReport Qualification = new SubReport();
Qualification.SubReportName = "EmpQualification";
Qualification.ParamList.Add(new ReportParameter("P_PID", empID));
SubReport Training = new SubReport();
Training.SubReportName = "EmpTraining";
Training.ParamList.Add(new ReportParameter("P_PID", empID));
SubReport PermAddress = new SubReport();
PermAddress.SubReportName = "EmpPermAddress";
PermAddress.ParamList.Add(new ReportParameter("P_P_ID", empID));
PermAddress.ParamList.Add(new ReportParameter("P_ACTIVE", "Y"));
SubReport TempAddress = new SubReport();
TempAddress.SubReportName = "EmpTempAddress";
TempAddress.ParamList.Add(new ReportParameter("P_P_ID", empID));
TempAddress.ParamList.Add(new ReportParameter("P_ACTIVE", "Y"));
SubReport Phone = new SubReport();
Phone.SubReportName = "EmpPhone";
Phone.ParamList.Add(new ReportParameter("P_P_ID", empID));
Phone.ParamList.Add(new ReportParameter("P_ACTIVE", "Y"));
SubReport Email = new SubReport();
Email.SubReportName = "EmpEmail";
Email.ParamList.Add(new ReportParameter("P_P_ID", empID));
Email.ParamList.Add(new ReportParameter("P_ACTIVE", "Y"));
SubReport Visit = new SubReport();
Visit.SubReportName = "EmpVisit";
Visit.ParamList.Add(new ReportParameter("P_EMP_ID", empID));
objReport.SubReportList.Add(Qualification);
objReport.SubReportList.Add(Training);
objReport.SubReportList.Add(PermAddress);
objReport.SubReportList.Add(TempAddress);
objReport.SubReportList.Add(Phone);
objReport.SubReportList.Add(Email);
objReport.SubReportList.Add(Visit);
Session["PMSBioData"] = objReport;
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('./CommonReportViewer.aspx', 'popup','width=802,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=no,toolbar=no');";
script += "</script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
protected void btnGenerateReport_Click(object sender, EventArgs e)
{
if (this.txtStartYear.Text.Trim() == "")
{
this.lblStatus.Text = "Error:: Please enter start year for renew data comparision.";
return;
}
if (this.txtEndYear.Text.Trim() == "")
{
this.lblStatus.Text = "Error:: Please enter end year for renew data comparision.";
return;
}
CrystalReport report = new CrystalReport(Server.MapPath("~/MODULES/LJMS/REPORTS/RenewalComparision_New.rpt"), "LJMS_ADMIN", "LJMS_ADMIN");
//report.SelectionCriteria = " 1 = 1 ";
//if (this.txtLisenceNo.Text.Trim() != "")
//{
// report.SelectionCriteria += "and {VW_PL_RENEW_DATE_COMPARE.LICENSE_NO} = '" + this.txtLisenceNo.Text.Trim() + "'";
// //report.SelectionCriteria += "and ({VW_PL_RENEW_DATE_COMPARE.LICENSE_NO} = '" + this.txtLisenceNo.Text.Trim() + "' or isnull({VW_PL_RENEW_DATE_COMPARE.LICENSE_NO}) = true)";
//}
//if (this.ddlLawyerType.SelectedIndex > 0)
//{
// report.SelectionCriteria += "and {VW_PL_RENEW_DATE_COMPARE.LAWYER_TYPE_ID} = " + this.ddlLawyerType.SelectedValue;
// //report.SelectionCriteria += "and ({VW_PL_RENEW_DATE_COMPARE.LAWYER_TYPE_ID} = " + this.ddlLawyerType.SelectedValue + " or isnull({VW_PL_RENEW_DATE_COMPARE.LAWYER_TYPE_ID}) = true)";
//}
//if (this.ddlUnit.SelectedIndex > 0)
//{
// report.SelectionCriteria += "and {VW_PL_RENEW_DATE_COMPARE.UNIT_ID} = " + this.ddlUnit.SelectedValue;
// //report.SelectionCriteria += "and ({VW_PL_RENEW_DATE_COMPARE.UNIT_ID} = " + this.ddlUnit.SelectedValue + " or isnull({VW_PL_RENEW_DATE_COMPARE.UNIT_ID}) = true)";
//}
ReportParameter stYear = new ReportParameter("st_numb", this.txtStartYear.Text.Trim());
ReportParameter endYear = new ReportParameter("end_numb", this.txtEndYear.Text.Trim());
report.ParamList.Add(stYear);
report.ParamList.Add(endYear);
if (this.txtLisenceNo.Text.Trim() != "")
{
report.ParamList.Add(new ReportParameter("P_LICENSE_NO", this.txtLisenceNo.Text.Trim()));
}
else
{
report.ParamList.Add(new ReportParameter("P_LICENSE_NO", null));
}
if (this.ddlLawyerType.SelectedIndex > 0)
{
report.ParamList.Add(new ReportParameter("P_LAWYER_TYPE_ID", int.Parse(this.ddlLawyerType.SelectedValue)));
}
else
{
report.ParamList.Add(new ReportParameter("P_LAWYER_TYPE_ID", null));
}
if (this.ddlUnit.SelectedIndex > 0)
{
report.ParamList.Add(new ReportParameter("P_UNIT_ID", int.Parse(this.ddlUnit.SelectedValue)));
}
else
{
report.ParamList.Add(new ReportParameter("P_UNIT_ID", null));
}
Session["LJMSReport"] = report;
this.lblStatus.Text = "";
string script = "";
script += "<script language='javascript' type='text/javascript'>";
script += "var win=window.open('../ReportForms/CommonReportViewer.aspx', 'popup','width=780,height=500,directories=no,location=no,menubar=no,resizable=1,scrollbars=1,status=yes,toolbar=no');";
script += "</script>";
this.ClientScript.RegisterClientScriptBlock(this.GetType(), "PCS", script);
}
