protected void btnExportToExcel_Click(object sender, EventArgs e)
{
sDataSource = System.Configuration.ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString();
int empNO = 0;
int managerID = 0;
string empName = string.Empty;
string managerName = string.Empty;
string sWeekID = string.Empty;
string dTSEDateRange = string.Empty;
string sApproved = string.Empty;
if (ddlEmployee.Text.Trim() != string.Empty)
{
empNO = Convert.ToInt32(ddlEmployee.Text.Trim());
lblEmployeeNumber.Text = empNO.ToString();
}
if (ddlApprover.Text.Trim() != string.Empty)
{
managerID = Convert.ToInt32(ddlApprover.Text.Trim());
}
if (txtDateRange.Text.Trim() != string.Empty)
{
dTSEDateRange = txtDateRange.Text.Trim();
sWeekID = DateTimeExtension.CurrentWeekwithYear(Convert.ToDateTime(txtDateRange.Text));
lblSelectedWeek.Text = DateTimeExtension.GetFormatWeekForGivenWeekID(sWeekID);
}
if (drpsApproved.Text.Trim() != string.Empty)
{
sApproved = drpsApproved.Text.Trim();
lblApprovedStatus.Text = sApproved.ToString();
}
BusinessLogic bl = new BusinessLogic(sDataSource);
bl.GetEmployeeMangerName(empNO, out empName, managerID, out managerName);
lblEmployeeName.Text = empName;
lblArroverName.Text = managerName;
if (bl.IsManagerForThisEmployee(empNO, managerID))
{
DataSet ds = bl.generateTSEReportDSNew(sWeekID, empNO, managerID, sApproved, sDataSource);
gvTSE.DataSource = ds;
gvTSE.DataBind();
ExportToExcel();
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Selected Employee is not reporting to this Approver. Report cannot be generated.');", true);
}
}
protected void btnGenerateReport_Click(object sender, EventArgs e)
{
sDataSource = System.Configuration.ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString();
int empNO = 0;
int managerID = 0;
string dTSEDateRange = string.Empty;
string sApproved = string.Empty;
string sWeekID = string.Empty;
if (ddlEmployee.Text.Trim() != string.Empty)
{
empNO = Convert.ToInt32(ddlEmployee.Text.Trim());
lblEmployeeNumber.Text = empNO.ToString();
}
if (ddlApprover.Text.Trim() != string.Empty)
{
managerID = Convert.ToInt32(ddlApprover.Text.Trim());
}
if (txtDateRange.Text.Trim() != string.Empty)
{
dTSEDateRange = txtDateRange.Text.Trim();
sWeekID = DateTimeExtension.CurrentWeekwithYear(Convert.ToDateTime(dTSEDateRange));
lblSelectedWeek.Text = dTSEDateRange.ToString();
}
if (drpsApproved.Text.Trim() != string.Empty)
{
sApproved = drpsApproved.Text.Trim();
lblApprovedStatus.Text = sApproved.ToString();
}
div1.Visible = true;
divmain.Visible = false;
BusinessLogic bl = new BusinessLogic(sDataSource);
if (bl.IsManagerForThisEmployee(empNO, managerID))
{
Response.Write("<script language='javascript'> window.open('TimeSheetReports1.aspx?empNO=" + empNO + "&sApproved=" + sApproved + "&smanagerID= " + managerID + "&sWeekID=" + sWeekID + " ' , 'window','height=700,width=1000,left=172,top=10,toolbar=yes,scrollbars=yes,resizable=yes');</script>");
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Selected Employee is not reporting to this Approver. Report cannot be generated.');", true);
}
}