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