public DataTable GetJobListByFilterBAL(jobFiltersBE jobFilters) { DataTable dt = new DataTable(); try { dt = compassDAL.GetJobListByFilterDAL(jobFilters); } catch (Exception ex) { } return(dt); }
public DataTable GetJobListByFilterDAL(jobFiltersBE jobFilters) { DataTable dt = new DataTable(); try { SqlParameter tvpParam = new SqlParameter("@JobStatus", jobFilters.JobStatus); tvpParam.SqlDbType = SqlDbType.Structured; tvpParam.Direction = ParameterDirection.Input; tvpParam.TypeName = "[dbo].[UT_JobStatus]"; SqlParameter[] param = { new SqlParameter("@UserId", jobFilters.Id), new SqlParameter("@TeamId", jobFilters.TeamId), new SqlParameter("@PriorityID", jobFilters.PriorityID), new SqlParameter("@AllocatedToUser", jobFilters.AllocatedToUser), new SqlParameter("@JobTypeId", jobFilters.JobTypeId), new SqlParameter("@BranchId", jobFilters.BranchId), new SqlParameter("@StartDate", jobFilters.FromDate), new SqlParameter("@EndDate", jobFilters.ToDate), new SqlParameter("@JobNumber", jobFilters.JobNumber), new SqlParameter("@SubmitBy", jobFilters.jobDetails.SubmitBy), tvpParam }; if (jobFilters.JobStatus.Count == 0) { param = param.RemoveFromArray(tvpParam); } DataSet ds = SqlHelper.ExecuteDataset(DBConnection.Connection.ToString(), CommandType.StoredProcedure, "spListJobs", param); dt = ds.Tables[0]; } catch (Exception ex) { // LogUtility.SaveErrorLogEntry(ex); } return(dt); }
public void BindMethods() { jobFiltersBE jobFilters = new jobFiltersBE(); jobFilters.jobDetails = new JobDetailsBE(); jobFilters.Id = Convert.ToInt32(Session["UserId"]); jobFilters.TeamId = ddlTeam.SelectedValue != null?Convert.ToInt32(ddlTeam.SelectedValue) : 0; jobFilters.PriorityID = ddlPriority.SelectedValue != null?Convert.ToInt32(ddlPriority.SelectedValue) : 0; jobFilters.FromDate = !string.IsNullOrEmpty(txtFromDate.Text) ? txtFromDate.Text : "01/01/1900"; jobFilters.ToDate = !string.IsNullOrEmpty(txtToDate.Text) ? txtToDate.Text : "01/01/1900";; jobFilters.JobNumber = txtJobNo.Text; if (Convert.ToBoolean(Session["IsServiceCompanyUser"])) { jobFilters.AllocatedToUser = ddlUser.SelectedValue != null?Convert.ToInt32(ddlUser.SelectedValue) : 0; } jobFilters.JobTypeId = ddlJobType.SelectedValue != null?Convert.ToInt32(ddlJobType.SelectedValue) : 0; int UserTypeId = 0; if (int.TryParse(Session["UserTypeId"].ToString(), out UserTypeId)) { if (UserTypeId == 2) // User if of Branch Type { int branchId = 0; if (int.TryParse(Session["BranchId"].ToString(), out branchId)) { jobFilters.BranchId = branchId; } } else { jobFilters.BranchId = ddlBranch.SelectedValue != null?Convert.ToInt32(ddlBranch.SelectedValue) : 0; } } else { jobFilters.BranchId = ddlBranch.SelectedValue != null?Convert.ToInt32(ddlBranch.SelectedValue) : 0; } jobFilters.jobDetails.SubmitBy = ddlUserSubmittedBy.SelectedValue != null?Convert.ToInt32(ddlUserSubmittedBy.SelectedValue) : 0; JobStatusColllection LstJobStatus = new JobStatusColllection(); if (IsResetClicked == false) { foreach (ListItem item in lstStatus.Items) { if (item.Selected) { JobStatusBE jobStatus = new JobStatusBE(); jobStatus.JobStatusId = item.Value != null?Convert.ToInt32(item.Value) : 0; LstJobStatus.Add(jobStatus); } } } else { foreach (ListItem item in lstStatus.Items) { JobStatusBE jobStatus = new JobStatusBE(); jobStatus.JobStatusId = item.Value != null?Convert.ToInt32(item.Value) : 0; LstJobStatus.Add(jobStatus); } } jobFilters.JobStatus = LstJobStatus; DataTable dtJobList = compassBAL.GetJobListByFilterBAL(jobFilters); grdViewJobList.DataSource = dtJobList; grdViewJobList.DataBind(); }