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