public DataSet getAllCategoryID(clsCategoryWiseSearchReport objCategorywiseSearchReport)
{
try
{
DataSet dsCategoryID = new DataSet();
SqlParameter[] objParam = new SqlParameter[1];
objParam[0] = new SqlParameter("@EmployeeID", SqlDbType.Int);
objParam[0].Value = objCategorywiseSearchReport.EmployeeName;
dsCategoryID = SqlHelper.ExecuteDataset(strConnectionString, CommandType.StoredProcedure, "getDepartment", objParam);
return(dsCategoryID);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLSubCategory.cs", "getAllCategoryID", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
//private void BindActiveSubCategory()
//{
// try
// {
// clsBLSubCategory objclsBLSubCategory = new clsBLSubCategory();
// DataSet dsSubCategory = new DataSet();
// dsSubCategory = objclsBLSubCategory.getSubCategories();
// for (int i = 0; i < dsSubCategory.Tables[0].Rows.Count; i++)
// {
// ddlSubCategory.Items.Add(new ListItem(dsSubCategory.Tables[0].Rows[i]["SubCategory"].ToString(), dsSubCategory.Tables[0].Rows[i]["SubCategoryID"].ToString()));
// }
// ddlSubCategory.Items.Insert(0, "All");
// }
// catch (V2Exceptions ex)
// {
// throw;
// }
// catch (System.Exception ex)
// {
// FileLog objFileLog = FileLog.GetLogger();
// objFileLog.WriteLine(LogType.Error, ex.Message, "CategoryWiseSearchReport.aspx", "BindActiveSubCategory", ex.StackTrace);
// throw new V2Exceptions(ex.ToString(),ex);
// }
//}
private void BindActiveCategory()
{
try
{
ddlCategory.Items.Add(new ListItem("Select Department", "0"));
clsBLSubCategory objClsBLSubCategory = new clsBLSubCategory();
clsCategoryWiseSearchReport objCategorywiseSearchReport = new clsCategoryWiseSearchReport();
objCategorywiseSearchReport.EmployeeName = SAEmployeeID.ToString();
DataSet dsCategoryID = objClsBLSubCategory.getAllCategoryID(objCategorywiseSearchReport);
for (int i = 0; i < dsCategoryID.Tables[0].Rows.Count; i++)
{
if (dsCategoryID.Tables[0].Rows.Count > 0)
{
ddlCategory.Items.Add(new ListItem(dsCategoryID.Tables[0].Rows[i]["Category"].ToString(), dsCategoryID.Tables[0].Rows[i]["CategoryID"].ToString()));;
// ddlCategory.DataSource = dsCategoryID.Tables[0];
// ddlCategory.DataValueField = dsCategoryID.Tables[0].Columns["CategoryID"].ToString();
// ddlCategory.DataTextField = dsCategoryID.Tables[0].Columns["Category"].ToString();
// ddlCategory.DataBind();
}
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "CategoryWiseSearchReport.aspx", "BindActiveCategory", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet GetCategoryWiseReport(clsCategoryWiseSearchReport objCategoryWiseSearchReport)
{
try
{
return(objDLCategoryWiseSearchReport.GetCategoryWiseReport(objCategoryWiseSearchReport));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLCategoryWiseSearchReport.cs", "GetCategoryWiseReport", ex.StackTrace);
throw new V2Exceptions();
}
}
public DataSet getAllCategoryID(clsCategoryWiseSearchReport objCategorywiseSearchReport)
{
try
{
clsDLSubCategory objClsDLSubCategory = new clsDLSubCategory();
return(objClsDLSubCategory.getAllCategoryID(objCategorywiseSearchReport));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLSubCategory.cs", "getAllCategoryID", ex.StackTrace);
throw new V2Exceptions();
}
}
public void GetCategorywiseReport()
{
int StatusID = 0;
int SubCategoryID = 0;
try
{
clsCategoryWiseSearchReport objCategorywiseSearchReport = new clsCategoryWiseSearchReport();
clsBLCategoryWiseSearchReport objBLCategorywiseSearchReport = new clsBLCategoryWiseSearchReport();
objCategorywiseSearchReport.EmployeeID = SAEmployeeID;
clsIssueStatus objIssueStatus = new clsIssueStatus();
int CategoryID = Convert.ToInt32(ddlCategory.SelectedItem.Value);
objCategorywiseSearchReport.CategoryID = CategoryID;
// int StatusID = Convert.ToInt32(ddlStatus.SelectedItem.Value);
if (ddlStatus.SelectedItem.Value != "All")
{
StatusID = Convert.ToInt32(ddlStatus.SelectedValue);
objCategorywiseSearchReport.StatusID = StatusID;
}
else
{
objCategorywiseSearchReport.StatusID = -1;
}
if (ddlSubCategory.SelectedItem.Value != "All")
{
SubCategoryID = Convert.ToInt32(ddlSubCategory.SelectedValue);
objCategorywiseSearchReport.SubCategoryID = SubCategoryID;
}
else
{
objCategorywiseSearchReport.SubCategoryID = -1;
}
objCategorywiseSearchReport.Period = ddlPeriod.SelectedItem.Value;
if (ddlPeriod.SelectedItem.Value.ToLower() == "day")
{
objCategorywiseSearchReport.Date = txtDay.Text.Trim();
objCategorywiseSearchReport.Month = "";
objCategorywiseSearchReport.Year = "";
objCategorywiseSearchReport.FromDate = "";
objCategorywiseSearchReport.ToDate = "";
}
else if (ddlPeriod.SelectedItem.Value.ToLower() == "week")
{
objCategorywiseSearchReport.Date = txtDay.Text.Trim();
objCategorywiseSearchReport.Month = "";
objCategorywiseSearchReport.Year = "";
objCategorywiseSearchReport.FromDate = "";
objCategorywiseSearchReport.ToDate = "";
}
else if (ddlPeriod.SelectedItem.Value.ToLower() == "month")
{
objCategorywiseSearchReport.Date = "";
objCategorywiseSearchReport.Month = ddlMonths.SelectedValue;
objCategorywiseSearchReport.Year = ddlYears.SelectedValue;
objCategorywiseSearchReport.FromDate = "";
objCategorywiseSearchReport.ToDate = "";
}
else if (ddlPeriod.SelectedItem.Value.ToLower() == "year")
{
objCategorywiseSearchReport.Date = "";
objCategorywiseSearchReport.Month = "";
objCategorywiseSearchReport.Year = ddlYears.SelectedValue;
objCategorywiseSearchReport.FromDate = "";
objCategorywiseSearchReport.ToDate = "";
}
else if (ddlPeriod.SelectedItem.Value.ToLower() == "range")
{
objCategorywiseSearchReport.Date = "";
objCategorywiseSearchReport.Month = "";
objCategorywiseSearchReport.Year = "";
objCategorywiseSearchReport.FromDate = txtFromDate.Text.Trim();
objCategorywiseSearchReport.ToDate = txtToDate.Text.Trim();
}
dsGetReport = new DataSet();
dsGetReport = objBLCategorywiseSearchReport.GetCategoryWiseReport(objCategorywiseSearchReport);
if (dsGetReport.Tables[0].Rows.Count > 0)
{
dgReport.DataSource = dsGetReport.Tables[0];
dgReport.DataBind();
if (StatusID != -1)
{
//dgReport.Columns[8].Visible = false;
}
else
{
//dgReport.Columns[8].Visible = true;
}
if (CategoryID != 0)
{
dgReport.Columns[4].Visible = false;
}
else
{
dgReport.Columns[4].Visible = true;
}
if (ddlPeriod.SelectedItem.Value == "day")
{
dgReport.Columns[2].Visible = false;
}
else
{
dgReport.Columns[2].Visible = true;
}
dgReport.Visible = true;
lblError.Visible = false;
lnkbtnPrint.Visible = true;
lnkbtnSendToExcel.Visible = true;
lblSeperator.Visible = true;
}
else
{
lnkbtnPrint.Visible = false;
lnkbtnSendToExcel.Visible = false;
lblSeperator.Visible = false;
dgReport.Visible = false;
lblError.Visible = true;
lblError.Text = "No Records Found.";
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "CategoryWiseSearchReport.aspx", "GetCategorywiseReport", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet GetCategoryWiseReport(clsCategoryWiseSearchReport objCategoryWiseSearchReport)
{
try
{
SqlDateTime sqlNullValue;
sqlNullValue = SqlDateTime.Null;
DataSet dsCategoryWiseList;
dsCategoryWiseList = new DataSet();
SqlParameter[] objParam = new SqlParameter[9];
//objParam[0] = new SqlParameter("@EmployeeID",SqlDbType.Int);
//objParam[0].Value = objCategoryWiseSearchReport.EmployeeID;
objParam[0] = new SqlParameter("@CategoryID", SqlDbType.Int);
objParam[0].Value = objCategoryWiseSearchReport.CategoryID;
objParam[1] = new SqlParameter("@StatusID", SqlDbType.Int);
objParam[1].Value = objCategoryWiseSearchReport.StatusID;
objParam[2] = new SqlParameter("@Date", SqlDbType.DateTime, 20);
if (objCategoryWiseSearchReport.Date == "")
{
objParam[2].Value = sqlNullValue;
}
else
{
objParam[2].Value = objCategoryWiseSearchReport.Date;
}
objParam[3] = new SqlParameter("@Month", SqlDbType.VarChar, 20);
objParam[3].Value = objCategoryWiseSearchReport.Month;
objParam[4] = new SqlParameter("@Year", SqlDbType.VarChar, 20);
objParam[4].Value = objCategoryWiseSearchReport.Year;
objParam[5] = new SqlParameter("@FromDate", SqlDbType.DateTime, 20);
if (objCategoryWiseSearchReport.FromDate == "")
{
objParam[5].Value = sqlNullValue;
}
else
{
objParam[5].Value = objCategoryWiseSearchReport.FromDate;
}
objParam[6] = new SqlParameter("@ToDate", SqlDbType.DateTime, 20);
if (objCategoryWiseSearchReport.ToDate == "")
{
objParam[6].Value = sqlNullValue;
}
else
{
objParam[6].Value = objCategoryWiseSearchReport.ToDate;
}
objParam[7] = new SqlParameter("@Period", SqlDbType.VarChar, 50);
objParam[7].Value = objCategoryWiseSearchReport.Period;
objParam[8] = new SqlParameter("@SubCategoryID", SqlDbType.Int);
objParam[8].Value = objCategoryWiseSearchReport.SubCategoryID;
try
{
dsCategoryWiseList = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_GetCategoryWiseReport", objParam);
return(dsCategoryWiseList);
}
catch (Exception ex)
{
throw ex;
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLCategoryWiseSearchReport.cs", "GetCategoryWiseReport", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
