public OperationResult GetInfo_ByID(int Id, out UserAccount data) { var result = new OperationResult(); data = null; try { var parameters = new List <SqlParameter> { new SqlParameter("@IDNo", Id) }; DataTable dtResult; var mssql = new DBCon(); result = mssql.GetData(parameters, "prc_UserSelect", out dtResult); if (result.Success) { data = extractSingle(dtResult); } else { result.Success = false; result.Add(ErrorMessage.NoRecordFound); } } catch (Exception ex) { result.Success = false; result.Add(ex.Message); } return(result); }
public OperationResult GetAll(UserAccountType userAccountType, out List <UserAccount> datalist) { var result = new OperationResult(); datalist = null; try { var parameters = new List <SqlParameter> { new SqlParameter("@AccountType", userAccountType) }; DataTable dtResult; var mssql = new DBCon(); result = mssql.GetData(parameters, "prc_UserSelect", out dtResult); if (result.Success) { datalist = extractMany(dtResult); } else { result.Success = false; result.Add(ErrorMessage.NoRecordFound); } } catch (Exception ex) { result.Success = false; result.Add(ex.Message); } return(result); }
public OperationResult GetAll(out List <Entity> datalist) { var result = new OperationResult(); datalist = null; try { DataTable dtResult; var mssql = new DBCon(); result = mssql.GetData(parameters: null, sProc: "prc_EntitySelect", dtResult: out dtResult); if (result.Success) { datalist = extractMany(dtResult); } else { result.Success = false; result.Add(ErrorMessage.NoRecordFound); } } catch (Exception ex) { result.Success = false; result.Add(ex.Message); } return(result); }