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());
}
