private void GetEmployeeSalaryHistory(DateTime payrollDate) { try { ReportBAL objReportBal = new ReportBAL(); DataTable dtReportBal = new DataTable(); cr_SalaryHistory objEmployee = new cr_SalaryHistory(); frmReportViewer objReportviewer = new frmReportViewer(); dtReportBal = objReportBal.GetEmployeeSalaryHistory(payrollDate); objEmployee.SetDataSource(dtReportBal); GetCommonInfo(); ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtReport"]).Text = "Salary History For the Month of " + payrollDate.ToString("MMMM-yyyy"); objReportviewer.crvReportViewer.ReportSource = objEmployee; objReportviewer.crvReportViewer.DisplayGroupTree = false; objReportviewer.Text = "Salary Sheet of " + payrollDate.ToString("MMMM,yyyy"); objReportviewer.Show(); } catch (Exception) { throw; } }
public void DisplayUI() { IReportBAL objBal = new ReportBAL(); objBal.GenerateESICReport(); objBal.GeneratePFReport(); }
private void GetEmployeeInfo() { try { ReportBAL objReportBal = new ReportBAL(); DataTable dtReportBal = new DataTable(); cr_EmployeeInfo objEmployee = new cr_EmployeeInfo(); frmReportViewer objReportviewer = new frmReportViewer(); dtReportBal = objReportBal.GetEmployeeInfo(); objEmployee.SetDataSource(dtReportBal); GetCommonInfo(); ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; objReportviewer.crvReportViewer.ReportSource = objEmployee; objReportviewer.crvReportViewer.DisplayGroupTree = false; objReportviewer.Text = "Salary Chat"; objReportviewer.Show(); } catch (Exception) { throw; } }
private void GetEmployeewiseSalaryHistory(string EmployeeCode) { try { ReportBAL objReportBal = new ReportBAL(); DataTable dtReportBal = new DataTable(); cr_EmployeeWiseSalaryHistory objEmployee = new cr_EmployeeWiseSalaryHistory(); frmReportViewer objReportviewer = new frmReportViewer(); dtReportBal = objReportBal.GetEmployeeWiseSalaryHistoy(EmployeeCode); objEmployee.SetDataSource(dtReportBal); GetCommonInfo(); ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtEmployeeCode"]).Text = EmployeeCode; ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtName"]).Text = txtName.Text; ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtDepartment"]).Text = txtDepartment.Text; ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtDesignation"]).Text = txtDesignation.Text; objReportviewer.crvReportViewer.ReportSource = objEmployee; objReportviewer.crvReportViewer.DisplayGroupTree = false; objReportviewer.Text = "Personal Salary Report"; objReportviewer.Show(); } catch (Exception) { throw; } }
protected void gvReport_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditRecord") { if (e.CommandArgument != null) { ViewState["ReportEditActive"] = true; ViewState["ReportID"] = Convert.ToInt32(e.CommandArgument.ToString()); lblModalTitle.Text = "Report Edit"; FillControls(Convert.ToInt32(e.CommandArgument.ToString())); ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "reportAddEditModal();", true); } } if (e.CommandName == "DeleteRecord") { if (e.CommandArgument != null) { ReportBAL balReport = new ReportBAL(); if (balReport.Delete(Convert.ToInt32(e.CommandArgument.ToString()))) { fillGridViewReport(); ClientScript.RegisterStartupScript(GetType(), "SweetAlert", "swal({ type: 'success', title: 'Report Deleted Successfully', showConfirmButton: false, timer: 2000});", true); } else { lblErrorMessage.Text = balReport.Message; } } } }
private void GetEmployeeDatailsInfo(string EmployeeCode) { try { ReportBAL objReportBal = new ReportBAL(); DataTable dtReportBal = new DataTable(); cr_EmployeeDetaisInformation objEmployee = new cr_EmployeeDetaisInformation(); frmReportViewer objReportviewer = new frmReportViewer(); dtReportBal = objReportBal.GetEmployeeDetailsInfo(EmployeeCode); objEmployee.SetDataSource(dtReportBal); GetCommonInfo(); ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)objEmployee.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; objReportviewer.crvReportViewer.ReportSource = objEmployee; objReportviewer.crvReportViewer.DisplayGroupTree = false; DataTable dtList = new DataTable(); dtList = objReportBal.GetEmployeePurposeList(EmployeeCode); objEmployee.Subreports[0].SetDataSource(dtList); objReportviewer.Text = "Personal Profile"; objReportviewer.Show(); } catch (Exception) { throw; } }
public void DisplayUI() { IReportBAL objBal = new ReportBAL(); objBal.GenerateESICReport(); objBal.GeneratePFReport(); objBal.GenerateResourcePerformanceReport(); objBal.GenerateProjectSchedule(); }
protected void btnSave_Click(object sender, EventArgs e) { #region server side validation String strErrorMessage = ""; if (txtReport.Text.Trim() == "") { strErrorMessage += "- Enter Report <br/>"; } if (strErrorMessage.Trim() != "") { lblErrorMessage.Text = strErrorMessage; return; } #endregion server side validation #region Collect Form Data ReportENT entReport = new ReportENT(); if (txtReport.Text.Trim() != "") { entReport.ReportName = txtReport.Text.Trim(); } #endregion Collect Form Data ReportBAL balReport = new ReportBAL(); if (Convert.ToBoolean(ViewState["ReportEditActive"]) == false) { if (balReport.Insert(entReport)) { fillGridViewReport(); ClientScript.RegisterStartupScript(GetType(), "SweetAlert", "swal({ type: 'success', title: 'City Inserted Successfully', showConfirmButton: false, timer: 2000});", true); ClearControls(); } else { lblErrorMessage.Text = balReport.Message; } } else { entReport.ReportID = Convert.ToInt32(ViewState["ReportID"]); if (balReport.Update(entReport)) { fillGridViewReport(); ClientScript.RegisterStartupScript(GetType(), "SweetAlert", "swal({ type: 'success', title: 'Report Edited Successfully', showConfirmButton: false, timer: 2000});", true); ClearControls(); ViewState["ReportEditActive"] = false; lblModalTitle.Text = "Report Add"; } else { lblErrorMessage.Text = balReport.Message; } } }
public static void fillCheckBoxListReport(CheckBoxList Report) { ReportBAL balReport = new ReportBAL(); Report.DataSource = balReport.SelectSelectForDropDownList(); Report.DataValueField = "ReportID"; Report.DataTextField = "ReportName"; Report.DataBind(); }
public void fillGridViewReport() { ReportBAL balReport = new ReportBAL(); DataTable dt = new DataTable(); dt = balReport.SelectAll(); gvReport.DataSource = dt; gvReport.DataBind(); }
public IList <Person> Report_GetALLBAL(IReportBAL objReportBAL) { _ReportBAL = objReportBAL; if (objReportBAL == null) { objReportBAL = new ReportBAL(); _ReportBAL = objReportBAL; } //TrainerDetailReport(_ReportBAL); return(_ReportBAL.Report_GetALLBAL()); }
private void FillControls(SqlInt32 ReportID) { ReportBAL balReport = new ReportBAL(); ReportENT entReport = new ReportENT(); entReport = balReport.SelectByPK(ReportID); if (!entReport.ReportName.IsNull) { txtReport.Text = entReport.ReportName.Value.ToString(); } }
private void GetEmployeeList() { try { ReportBAL objReportBal = new ReportBAL(); DataTable dtEmployeeList = new DataTable(); dtEmployeeList = objReportBal.GetEmployeeCode(); ddlEmoloyeeList.DataSource = dtEmployeeList; ddlEmoloyeeList.DisplayMember = "EmployeeCode"; lblTotalEmployee.Text = "Total Employee : " + dtEmployeeList.Rows.Count.ToString(); } catch (Exception) { throw; } }
private void GetUsedStubNumber() { try { List <Stubbing> stubbing = ReportBAL.GetUsedStubNumber(Request.QueryString); if ((stubbing != null) && stubbing.Count > 0) { Response.Write(stubbing.ToJSON()); } else { Response.Write("No Result"); } } catch (Exception ex) { Response.Write("Error: " + ex.Message); } }
private void subLoadReport() { try { SelectedReport[] reports = ReportBAL.fxGetReportURL(Request.QueryString); if ((reports != null) && reports.Length > 0) { Response.Write(reports.ToJSON()); } else { Response.Write("No Result"); } } catch (Exception ex) { Response.Write("Error: " + ex.Message); } }
private void GetEmployeeInfo(string emoployeeCode) { try { ReportBAL objReportBal = new ReportBAL(); DataTable dtEmployeeInfo = new DataTable(); dtEmployeeInfo = objReportBal.GetEmployeeCommonInfo(emoployeeCode); if (dtEmployeeInfo.Rows.Count > 0) { txtFinalEmployeeCode.Text = emoployeeCode; txtName.Text = dtEmployeeInfo.Rows[0][0].ToString(); txtDepartment.Text = dtEmployeeInfo.Rows[0][1].ToString(); txtDesignation.Text = dtEmployeeInfo.Rows[0][2].ToString(); } } catch (Exception) { throw; } }
private void GetCOA() { Response.Write(ReportBAL.GetCOA(Request.QueryString).ToJSON()); }
private void GetSubsidiary() { Response.Write(ReportBAL.GetSubsidiary(Request.QueryString).ToJSON()); }
private void GetIndividualSupplementary() { Response.Write(ReportBAL.GetIndividualSupplementary(Request.QueryString).ToJSON()); }
private void GetAccountStatus() { Response.Write(ReportBAL.GetAccountStatus(Request.QueryString).ToJSON()); }
private void GetLtoLiaisonName() { Response.Write(ReportBAL.GetLtoLiaisonName().ToJSON()); }