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);
}
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 Save(List <SqlParameter> parameters, string sProc, ref int newId)
{
var result = new OperationResult();
try
{
result = Connect();
if (result.Success)
{
var cmd = new SqlCommand(sProc, cn)
{
CommandType = CommandType.StoredProcedure
};
if (parameters != null)
{
foreach (var param in parameters)
{
cmd.Parameters.Add(param);
}
}
var oParam = cmd.Parameters.Add(new SqlParameter("@DBStatus", SqlDbType.Int));
oParam.Direction = ParameterDirection.Output;
oParam = cmd.Parameters.Add(new SqlParameter("@NewID", SqlDbType.Int));
oParam.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if ((Status)cmd.Parameters["@DBStatus"].Value == Status.Success)
{
if (newId == -1)
{
newId = cmd.Parameters["@NewID"].Value.ToInt();
if (newId <= 0)
{
result.Success = false;
result.Add("No ID returned from database after insert");
}
}
}
else
{
result.Success = false;
result.Add("Save Failed");
}
CloseConnection();
}
}
catch (Exception ex)
{
result.Success = false;
result.Add(ex.Message);
}
return(result);
}
public int AddListErrosTest(params string[] errors)
{
var op = new OperationResult();
op.Add(errors.ToList());
return(op.Errors.Count);
}
public OperationResult Save(Entity data)
{
var result = new OperationResult();
try
{
int newId = data.IDNo;
if (data.IDNo == -1)
{
data.GUID = GenerateGuid.Get();
}
var parameter = SetParameter(data);
var mssql = new DBCon();
result = mssql.Save(parameter, "prc_EntitySave", ref newId);
if (result.Success)
{
if (data.IDNo == -1)
{
data.IDNo = newId;
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Add(ex.Message);
}
return(result);
}
public string ToStringTest(params string[] errors)
{
var op = new OperationResult();
foreach (var error in errors)
{
op.Add(error);
}
return(op.ToString());
}
public OperationResult ValidateEmail()
{
var result = new OperationResult
{
Success = true
};
result.Add("Email Successfull");
return(result);
}
public OperationResult IsValidPassword(string Password, UserAccount userAccount)
{
var result = new OperationResult();
if (userAccount.Password != Password)
{
result.Success = false;
result.Add("Invalid Password");
}
return(result);
}
public OperationResult Execute(List <SqlParameter> parameters, string sProc)
{
var result = new OperationResult();
try
{
result = Connect();
if (result.Success)
{
var cmd = new SqlCommand(sProc, cn)
{
CommandType = CommandType.StoredProcedure
};
if (parameters != null)
{
foreach (var param in parameters)
{
cmd.Parameters.Add(param);
}
}
var oParam = cmd.Parameters.Add(new SqlParameter("@DBStatus", SqlDbType.Int));
oParam.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if ((Status)cmd.Parameters["@DBStatus"].Value != Status.Success)
{
result.Success = false;
result.Add("Execute Query Failed");
}
CloseConnection();
}
}
catch (Exception ex)
{
result.Success = false;
result.Add(ex.Message);
}
return(result);
}
public void Add1ErrorTest()
{
// Arrange
var op = new OperationResult();
// Action
op.Add("error1");
// Assert
Assert.AreEqual(1, op.Errors.Count);
Assert.IsTrue(op.IsFail);
Assert.IsFalse(op.IsSuccess);
}
//public override string ToString()
//{
// return Name;
//}
public OperationResult AccountIsExpired(DateTime currentDate, UserAccount userAccount)
{
var result = new OperationResult();
if (!(currentDate >= userAccount.ValidFrom &&
currentDate <= userAccount.ValidTo))
{
result.Success = false;
result.Add("Account is Expired");
}
return(result);
}
public void PlusOperatorTest()
{
// Arrange
var op1 = new OperationResult();
var op2 = new OperationResult();
// Action
op1.Add("error1");
op2.Add("error2");
op1 += op2;
// Assert
Assert.AreEqual(2, op1.Errors.Count);
Assert.IsTrue(op1.IsFail);
Assert.IsFalse(op1.IsSuccess);
}
private OperationResult Connect()
{
OperationResult result = new OperationResult();
try
{
cn = new SqlConnection(ConnectionString);
cn.Open();
result.Success = true;
}
catch (Exception ex)
{
result.Success = false;
result.Add(ex.Message);
}
return(result);
}
public OperationResult DeleteInfoByIDNo(int Id)
{
var result = new OperationResult();
try
{
var mssql = new DBCon();
var parameters = new List <SqlParameter> {
new SqlParameter("@IDNo", Id)
};
result = mssql.Execute(parameters, "prc_EntityDelete");
}
catch (SqlException ex)
{
result.Success = false;
result.Add(ex.Message);
}
return(result);
}
