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 Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.Cookies["Company"] != null)
{
sDataSource = System.Configuration.ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString();
}
else
{
Response.Redirect("~/Login.aspx");
}
int empNO = 0;
int managerID = 0;
string empName = string.Empty;
string managerName = string.Empty;
string sWeekID = string.Empty;
string sApproved = string.Empty;
BusinessLogic bl = new BusinessLogic(sDataSource);
if (Request.QueryString["sWeekID"] != null)
{
sWeekID = Request.QueryString["sWeekID"].ToString();
lblSelectedWeek.Text = DateTimeExtension.GetFormatWeekForGivenWeekID(sWeekID);
}
if (Request.QueryString["empNO"] != null)
{
empNO = Convert.ToInt32(Request.QueryString["empNO"].ToString());
lblEmployeeNumber.Text = empNO.ToString();
}
if (Request.QueryString["smanagerID"] != null)
{
managerID = Convert.ToInt32(Request.QueryString["smanagerID"].ToString());
}
if (Request.QueryString["sApproved"] != null)
{
sApproved = Request.QueryString["sApproved"].ToString();
lblApprovedStatus.Text = sApproved.ToString();
}
bl.GetEmployeeMangerName(empNO, out empName, managerID, out managerName);
lblEmployeeName.Text = empName;
lblArroverName.Text = managerName;
DataSet ds = bl.generateTSEReportDSNew(sWeekID, empNO, managerID, sApproved, sDataSource);
gvTSE.DataSource = ds;
gvTSE.DataBind();
}
}