public DataSet getAllEmployee(clsMemberWiseSearchReport objclsMemberWiseSearchReport)
{
DataSet dsAllEmployees = new DataSet();
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@EmployeeID", SqlDbType.Int);
sqlParams[0].Value = objclsMemberWiseSearchReport.EmployeeID;
sqlParams[0].Direction = ParameterDirection.Input;
try
{
dsAllEmployees = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_Admin_Employees", sqlParams);
return(dsAllEmployees);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLMemberWiseSearchReport.cs", "getAllEmployee", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
private void BindEmployeeNames()
{
try
{
ddlEmployeeName.Items.Add(new ListItem("All", "0"));
clsBLMemberWiseSearchReport objClsBLMemberWiseSearchReport = new clsBLMemberWiseSearchReport();
clsMemberWiseSearchReport objclsMemberWiseSearchReport = new clsMemberWiseSearchReport();
objclsMemberWiseSearchReport.EmployeeID = SAEmployeeID;
DataSet dsBindEmployeeNames = objClsBLMemberWiseSearchReport.getAllEmployee(objclsMemberWiseSearchReport);
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()));;
// ddlEmployeeName.DataSource = dsBindEmployeeNames.Tables[0];
// ddlEmployeeName.DataTextField = dsBindEmployeeNames.Tables[0].Columns["EmployeeName"].ToString();
// ddlEmployeeName.DataValueField = dsBindEmployeeNames.Tables[0].Columns["EmployeeID"].ToString();
// ddlEmployeeName.DataBind();
}
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ResolutionTimeReport.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");
}
public DataSet GetMemberWiseReport(clsMemberWiseSearchReport objClsMemberWiseSearchReport, int superAdmin)
{
try
{
return(objClsDLMemberWiseSearchReport.GetMemberWiseReport(objClsMemberWiseSearchReport, superAdmin));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLMemberWiseSearchReport.cs", "GetMemberWiseReport", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet getAllEmployee(clsMemberWiseSearchReport objclsMemberWiseSearchReport)
{
try
{
//clsDLMemberWiseSearchReport objClsDLMemberWiseSearchReport = new clsDLMemberWiseSearchReport();
return(objClsDLMemberWiseSearchReport.getAllEmployee(objclsMemberWiseSearchReport));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLMemberWiseSearchReport.cs", "getAllEmployee", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
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);
}
}
public DataSet GetMemberWiseReport(clsMemberWiseSearchReport objClsMemberWiseSearchReport, int superAdmin)
{
try
{
SqlDateTime sqlNullValue;
sqlNullValue = SqlDateTime.Null;
//clsMemberWiseSearchReport objClsMemberWiseSearchReport = new clsMemberWiseSearchReport();
SqlParameter[] sqlParams = new SqlParameter[9];
sqlParams[0] = new SqlParameter("@EmployeeID", SqlDbType.Int, 100);
sqlParams[0].Value = objClsMemberWiseSearchReport.EmployeeID;
sqlParams[0].Direction = ParameterDirection.Input;
sqlParams[1] = new SqlParameter("@StatusID", SqlDbType.VarChar, 50);
sqlParams[1].Value = objClsMemberWiseSearchReport.StatusID;
sqlParams[1].Direction = ParameterDirection.Input;
sqlParams[2] = new SqlParameter("@Date", SqlDbType.DateTime, 20);
if (objClsMemberWiseSearchReport.Date == "")
{
sqlParams[2].Value = sqlNullValue;
}
else
{
sqlParams[2].Value = objClsMemberWiseSearchReport.Date;
}
sqlParams[2].Direction = ParameterDirection.Input;
sqlParams[3] = new SqlParameter("@Month", SqlDbType.VarChar, 20);
sqlParams[3].Value = objClsMemberWiseSearchReport.Month;
sqlParams[3].Direction = ParameterDirection.Input;
sqlParams[4] = new SqlParameter("@Year", SqlDbType.VarChar, 20);
sqlParams[4].Value = objClsMemberWiseSearchReport.Year;
sqlParams[4].Direction = ParameterDirection.Input;
sqlParams[5] = new SqlParameter("@FromDate", SqlDbType.DateTime, 20);
if (objClsMemberWiseSearchReport.FromDate == "")
{
sqlParams[5].Value = sqlNullValue;
}
else
{
sqlParams[5].Value = objClsMemberWiseSearchReport.FromDate;
}
sqlParams[5].Direction = ParameterDirection.Input;
sqlParams[6] = new SqlParameter("@ToDate", SqlDbType.DateTime, 20);
if (objClsMemberWiseSearchReport.ToDate == "")
{
sqlParams[6].Value = sqlNullValue;
}
else
{
sqlParams[6].Value = objClsMemberWiseSearchReport.ToDate;
}
sqlParams[6].Direction = ParameterDirection.Input;
sqlParams[7] = new SqlParameter("@Period", SqlDbType.VarChar, 50);
sqlParams[7].Value = objClsMemberWiseSearchReport.Period;
sqlParams[7].Direction = ParameterDirection.Input;
sqlParams[8] = new SqlParameter("@superAdmin", SqlDbType.Int);
sqlParams[8].Value = superAdmin;
sqlParams[8].Direction = ParameterDirection.Input;
//superAdmin
DataSet dsMemberWiseReport = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_GetMemberWiseReport_New", sqlParams);
return(dsMemberWiseReport);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLMemberWiseSearchReport.cs", "GetMemberWiseReport", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
