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