public List <Approver> GetAllApprover(ApproverAdvanceSearch approverAdvanceSearch) { return(_approverRepository.GetAllApprover(approverAdvanceSearch)); }
/// <summary> /// To Get List of All Approver /// </summary> /// <param name="approverAdvanceSearch"></param> /// <returns>List</returns> public List <Approver> GetAllApprover(ApproverAdvanceSearch approverAdvanceSearch) { List <Approver> approverList = null; try { using (SqlConnection con = _databaseFactory.GetDBConnection()) { using (SqlCommand cmd = new SqlCommand()) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Connection = con; cmd.CommandText = "[PSA].[GetAllApprover]"; cmd.Parameters.Add("@SearchValue", SqlDbType.NVarChar, -1).Value = string.IsNullOrEmpty(approverAdvanceSearch.SearchTerm) ? "" : approverAdvanceSearch.SearchTerm.Trim(); cmd.Parameters.Add("@RowStart", SqlDbType.Int).Value = approverAdvanceSearch.DataTablePaging.Start; if (approverAdvanceSearch.DataTablePaging.Length == -1) { cmd.Parameters.AddWithValue("@Length", DBNull.Value); } else { cmd.Parameters.Add("@Length", SqlDbType.Int).Value = approverAdvanceSearch.DataTablePaging.Length; } //cmd.Parameters.Add("@OrderDir", SqlDbType.NVarChar, 5).Value = model.order[0].dir; //cmd.Parameters.Add("@OrderColumn", SqlDbType.NVarChar, -1).Value = model.order[0].column; cmd.Parameters.Add("@DocumentTypeCode", SqlDbType.VarChar, 5).Value = approverAdvanceSearch.AdvDocumentTypeCode; //cmd.Parameters.Add("@Level", SqlDbType.Int).Value = approverAdvanceSearch.Approver.Level; cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { approverList = new List <Approver>(); while (sdr.Read()) { Approver approver = new Approver(); { approver.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : approver.ID); approver.DocumentTypeCode = (sdr["DocumentTypeCode"].ToString() != "" ? sdr["DocumentTypeCode"].ToString() : approver.DocumentTypeCode); approver.DocumentType = new DocumentType(); approver.DocumentType.Description = (sdr["DocumentDescription"].ToString() != "" ? sdr["DocumentDescription"].ToString() : approver.DocumentType.Description); approver.Level = (sdr["Level"].ToString() != "" ? int.Parse(sdr["Level"].ToString()) : approver.Level); approver.UserID = (sdr["UserID"].ToString() != "" ? Guid.Parse(sdr["UserID"].ToString()) : approver.UserID); approver.PSAUser = new PSAUser(); approver.PSAUser.LoginName = (sdr["LoginName"].ToString() != "" ? sdr["LoginName"].ToString() : approver.PSAUser.LoginName); approver.IsDefault = (sdr["IsDefault"].ToString() != "" ? bool.Parse(sdr["IsDefault"].ToString()) : approver.IsDefault); approver.IsActive = (sdr["IsActive"].ToString() != "" ? bool.Parse(sdr["IsActive"].ToString()) : approver.IsActive); approver.FilteredCount = (sdr["FilteredCount"].ToString() != "" ? int.Parse(sdr["FilteredCount"].ToString()) : approver.FilteredCount); approver.TotalCount = (sdr["TotalCount"].ToString() != "" ? int.Parse(sdr["TotalCount"].ToString()) : approver.TotalCount); } approverList.Add(approver); } } } } } } catch (Exception ex) { throw ex; } return(approverList); }