// Gets list of clients internal List <MasterClientsEntity> GetClientPaging(int SortOrder, int PageNumber, int PageSize, out int TotalCount) { TotalCount = 0; List <MasterClientsEntity> results = new List <MasterClientsEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "mapp.GetClientPaging"; sproc.StoredProceduresParameter.Add(GetParam("@SortOrder", SortOrder.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@PageNumber", PageNumber.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@PageSize", PageSize.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@TotalRecords", TotalCount.ToString(), SQLServerDatatype.IntDataType, ParameterDirection.Output)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); if (dt != null && dt.Rows.Count > 0) { results = new MasterClientsAdapter().Adapt(dt); } } catch (Exception) { throw; } return(results); }
internal MasterClientsEntity GetClientById(int ClientId) { List <MasterClientsEntity> results = new List <MasterClientsEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "mapp.GetClientById"; sproc.StoredProceduresParameter.Add(GetParam("@ClientId", ClientId.ToString().Trim(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); if (dt != null && dt.Rows.Count > 0) { results = new MasterClientsAdapter().Adapt(dt); foreach (MasterClientsEntity comp in results) { results = new MasterClientsAdapter().Adapt(dt); } } } catch (Exception) { //Put log to db here throw; } return(results.FirstOrDefault()); }