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); } }