private void BindEmployeeNames()
{
try
{
clsBLMemberWiseSearchReport objClsBLMemberWiseSearchReport = new clsBLMemberWiseSearchReport();
objClsMemberWiseSearchReport.EmployeeID = SAEmployeeID;
DataSet dsBindEmployeeNames = objClsBLMemberWiseSearchReport.getAllEmployee(objClsMemberWiseSearchReport);
ddlEmployeeName.Items.Add(new ListItem("All", "0"));
for (int i = 0; i < dsBindEmployeeNames.Tables[0].Rows.Count; i++)
{
if (dsBindEmployeeNames.Tables[0].Rows.Count > 0)
{
ddlEmployeeName.Items.Add(new ListItem(dsBindEmployeeNames.Tables[0].Rows[i]["EmployeeName"].ToString(), dsBindEmployeeNames.Tables[0].Rows[i]["EmployeeID"].ToString()));;
}
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "MemberWiseSearchReport.aspx", "BindEmployeeNames", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public void GetStatus()
{
objClsMemberWiseSearchReport = new clsMemberWiseSearchReport();
objClsBLMemberWiseSearchReport = new clsBLMemberWiseSearchReport();
DataSet dsStatus = new DataSet();
dsStatus = objClsBLMemberWiseSearchReport.GetStatus();
for (int i = 0; i < dsStatus.Tables[0].Rows.Count; i++)
{
ddlStatus.Items.Add(new ListItem(dsStatus.Tables[0].Rows[i]["StatusDesc"].ToString(), dsStatus.Tables[0].Rows[i]["StatusID"].ToString()));
}
ddlStatus.Items.Insert(0, "All");
}
private void BindStatus()
{
try
{
clsMemberWiseSearchReport objClsMemberWiseSearchReport = new clsMemberWiseSearchReport();
clsBLMemberWiseSearchReport objClsBLMemberWiseSearchReport = new clsBLMemberWiseSearchReport();
objClsMemberWiseSearchReport = new clsMemberWiseSearchReport();
objClsBLMemberWiseSearchReport = new clsBLMemberWiseSearchReport();
//objViewMyIssues = new Model.clsViewMyIssues();
//objBLViewMyIssues = new BusinessLayer.clsBLViewMyIssues();
DataSet dsStatus = new DataSet();
dsStatus = objClsBLMemberWiseSearchReport.GetStatus();
// ddlStatus.Items.Add(new ListItem(dsStatus.Tables[0].Rows[i]["GroupName"].ToString(), dsStatus.Tables[0].Rows[i]["GroupID"].ToString()))
for (int i = 0; i < dsStatus.Tables[0].Rows.Count; i++)
{
ddlStatus.Items.Add(new ListItem(dsStatus.Tables[0].Rows[i]["StatusDesc"].ToString(), dsStatus.Tables[0].Rows[i]["StatusID"].ToString()));
}
ddlStatus.Items.Insert(0, "All");
//ddlStatus.DataSource = Status.BindStatusEnum(typeof(IssueStatus),"All");
//ddlStatus.DataTextField="Key";
//ddlStatus.DataValueField="Value";
//ddlStatus.DataBind();
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "CategoryWiseSearchReport.aspx", "BindStatus", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
private void GetResults()
{
int StatusID = 0;
try
{
int EmployeeID;
clsMemberWiseSearchReport objClsMemberWiseSearchReport = new clsMemberWiseSearchReport();
clsBLMemberWiseSearchReport objClsBLMemberWiseSearchReport = new clsBLMemberWiseSearchReport();
//added here
int superAdmin;
superAdmin = Convert.ToInt32(Session["SAEmployeeID"]);
//till here
EmployeeID = Convert.ToInt32(ddlEmployeeName.SelectedItem.Value);
objClsMemberWiseSearchReport.EmployeeID = EmployeeID;
if (ddlStatus.SelectedItem.Value != "All")
{
StatusID = Convert.ToInt32(ddlStatus.SelectedItem.Value);
objClsMemberWiseSearchReport.StatusID = StatusID;
}
else
{
objClsMemberWiseSearchReport.StatusID = -1;
}
objClsMemberWiseSearchReport.Period = ddlPeriod.SelectedItem.Value;
if (ddlPeriod.SelectedItem.Value.ToLower() == "day" || ddlPeriod.SelectedItem.Value.ToLower() == "week")
{
objClsMemberWiseSearchReport.Date = txtDay.Text.Trim();
objClsMemberWiseSearchReport.Month = "";
objClsMemberWiseSearchReport.Year = "";
objClsMemberWiseSearchReport.FromDate = "";
objClsMemberWiseSearchReport.ToDate = "";
}
else if (ddlPeriod.SelectedItem.Value.ToLower() == "month")
{
objClsMemberWiseSearchReport.Date = "";
objClsMemberWiseSearchReport.Month = ddlMonths.SelectedValue;
objClsMemberWiseSearchReport.Year = ddlYears.SelectedValue;
objClsMemberWiseSearchReport.FromDate = "";
objClsMemberWiseSearchReport.ToDate = "";
}
else if (ddlPeriod.SelectedItem.Value.ToLower() == "year")
{
objClsMemberWiseSearchReport.Date = "";
objClsMemberWiseSearchReport.Month = "";
objClsMemberWiseSearchReport.Year = ddlYears.SelectedValue;
objClsMemberWiseSearchReport.FromDate = "";
objClsMemberWiseSearchReport.ToDate = "";
}
else if (ddlPeriod.SelectedItem.Value.ToLower() == "range")
{
objClsMemberWiseSearchReport.Date = "";
objClsMemberWiseSearchReport.Month = "";
objClsMemberWiseSearchReport.Year = "";
objClsMemberWiseSearchReport.FromDate = txtFromDate.Text.Trim();
objClsMemberWiseSearchReport.ToDate = txtToDate.Text.Trim();
}
dsGetReport = new DataSet();
dsGetReport = objClsBLMemberWiseSearchReport.GetMemberWiseReport(objClsMemberWiseSearchReport, superAdmin);
if (dsGetReport.Tables[0].Rows.Count > 0)
{
dgReport.DataSource = dsGetReport.Tables[0];
dgReport.DataBind();
if (dgReport.PageCount > 1)
{
dgReport.PagerStyle.Visible = true;
}
else
{
dgReport.PagerStyle.Visible = false;
}
if (StatusID != -1)
{
dgReport.Columns[7].Visible = false;
}
else
{
dgReport.Columns[7].Visible = true;
}
if (EmployeeID != 0)
{
dgReport.Columns[5].Visible = false;
}
else
{
dgReport.Columns[5].Visible = true;
}
if (ddlPeriod.SelectedItem.Value == "day")
{
dgReport.Columns[2].Visible = false;
}
else
{
dgReport.Columns[2].Visible = true;
}
dgReport.Visible = true;
lblError.Visible = false;
lBtnPrint.Visible = true;
lblSeparator.Visible = true;
lBtnExcel.Visible = true;
}
else
{
dgReport.Visible = false;
lblError.Visible = true;
lblError.Text = "No Records Found.";
lBtnPrint.Visible = false;
lblSeparator.Visible = false;
lBtnExcel.Visible = false;
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "MemberWiseSearchReport.aspx", "GetResults", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
