public void TestCreateMFIFailure()
{
MFI mfi = new MFI { Name = "MFI", Login = "******", Password = "******" };
_mockMFIManagement.ExpectAndReturn("CreateMFI", false, mfi);
MFIServices mfiServices = _SetMockManager(_mockMFIManagement);
bool result = mfiServices.CreateMFI(mfi);
Assert.IsFalse(result);
}
public void TestCreateAndDeleteMFI()
{
MFI returnedMFI = new MFI();
_mfiManager.CreateMFI(_mfi);
_mfiManager.DeleteMFI();
returnedMFI = _mfiManager.SelectMFI();
Assert.AreEqual(null, returnedMFI.Login);
Assert.AreEqual(null, returnedMFI.Password);
Assert.AreEqual(null, returnedMFI.Name);
}
public bool CreateMFI(MFI pMFI)
{
if (pMFI.Name == String.Empty)
throw new OpenCbsMfiExceptions(OpenCbsMFIExceptionEnum.NameIsEmpty);
if (pMFI.Login == String.Empty)
throw new OpenCbsMfiExceptions(OpenCbsMFIExceptionEnum.LoginIsNotFilled);
if (pMFI.Password == String.Empty)
throw new OpenCbsMfiExceptions(OpenCbsMFIExceptionEnum.PasswordIsNotFilled);
return _MFIManager.CreateMFI(pMFI);
}
public void TestCreateAndUpdateMFISuccess()
{
MFI returnedMFI = new MFI();
MFI newMFI = new MFI { Name = "UpdatedName", Password = "******", Login = "******" };
_mfiManager.CreateMFI(_mfi);
bool result = _mfiManager.UpdateMFI(newMFI);
Assert.IsTrue(result);
returnedMFI = _mfiManager.SelectMFI();
Assert.AreEqual(newMFI.Login, returnedMFI.Login);
Assert.AreEqual(newMFI.Name, returnedMFI.Name);
Assert.AreEqual(newMFI.Password, returnedMFI.Password);
}
public bool CreateMFI(MFI pMFI)
{
if (SelectMFI().Login == null)
{
string sqlText = "INSERT INTO [MFI] ([name], [login], [password]) VALUES(@name,@login,@password)";
using (SqlConnection connection = GetConnection())
using (OpenCbsCommand cmd = new OpenCbsCommand(sqlText, connection))
{
cmd.AddParam("@name", pMFI.Name);
cmd.AddParam("@login", pMFI.Login);
cmd.AddParam("@password", pMFI.Password);
cmd.ExecuteNonQuery();
return true;
}
}
return false;
}
public void TestSelectMFIWhenNoMFI()
{
MFI returnedMFI = new MFI();
returnedMFI = _mfiManager.SelectMFI();
Assert.AreEqual(null, returnedMFI.Login);
Assert.AreEqual(null, returnedMFI.Password);
Assert.AreEqual(null, returnedMFI.Name);
}
public void TestSelectMFI()
{
MFI returnedMFI = new MFI();
_mfiManager.CreateMFI(_mfi);
returnedMFI = _mfiManager.SelectMFI();
Assert.AreEqual(_mfi.Login, returnedMFI.Login);
Assert.AreEqual(_mfi.Name, returnedMFI.Name);
Assert.AreEqual(_mfi.Password, returnedMFI.Password);
}
public void TestFixtureSetUp()
{
_mfiManager = new MFIManager(DataUtil.TESTDB);
_mfi = new MFI();
}
public void SetUp()
{
mfi = new MFI();
}
public MFI SelectMFI()
{
MFI mfi = new MFI();
string sqlText = "SELECT * FROM [MFI]";
using (SqlConnection connection = GetConnection())
using (OpenCbsCommand select = new OpenCbsCommand(sqlText, connection))
using (OpenCbsReader reader = select.ExecuteReader())
{
if (!reader.Empty)
{
reader.Read();
mfi = new MFI();
mfi.Name = reader.GetString("name");
mfi.Login = reader.GetString("login");
mfi.Password = reader.GetString("password");
}
}
return mfi;
}
public bool UpdateMFI(MFI pMFI)
{
if (SelectMFI().Login != null)
{
string sqlText = @"UPDATE [MFI] SET [name]=@name, [login]=@login, [password]=@password";
using (SqlConnection connection = GetConnection())
using (OpenCbsCommand cmd = new OpenCbsCommand(sqlText, connection))
{
cmd.AddParam("@name", pMFI.Name);
cmd.AddParam("@login", pMFI.Login);
cmd.AddParam("@password", pMFI.Password);
cmd.ExecuteNonQuery();
}
return true;
}
return false;
}
public void TestCreateMFILoginIsFilledAndPasswordIsEmpty()
{
MFI mfi = new MFI { Name = "MFI", Login = "******", Password = "" };
_mockMFIManagement.Expect("CreateMFI", mfi);
MFIServices mfiServices = _SetMockManager(_mockMFIManagement);
mfiServices.CreateMFI(mfi);
}
public void TestUpdateMFISuccess()
{
MFI mfi = new MFI { Name = "MFI", Login = "******", Password = "******" };
_mockMFIManagement.ExpectAndReturn("UpdateMFI", true, mfi);
MFIServices mfiServices = _SetMockManager(_mockMFIManagement);
bool result = mfiServices.UpdateMFI(mfi);
Assert.IsTrue(result);
}
public void TestUpdateMFINameIsEmpty()
{
MFI mfi = new MFI { Name = "", Login = "******", Password = "******" };
_mockMFIManagement.Expect("UpdateMFI", mfi);
MFIServices mfiServices = _SetMockManager(_mockMFIManagement);
mfiServices.UpdateMFI(mfi);
}
public void TestSelectMFIWithNoMFI()
{
MFI mfi = new MFI();
MFI returnedMFI = new MFI();
_mockMFIManagement.SetReturnValue("SelectMFI", mfi);
MFIServices mfiServices = _SetMockManager(_mockMFIManagement);
returnedMFI = mfiServices.FindMFI();
Assert.AreEqual(null, returnedMFI.Name);
Assert.AreEqual(null, returnedMFI.Login);
Assert.AreEqual(null, returnedMFI.Password);
}
public void TestSelectMFI()
{
MFI mfi = new MFI { Name = "MFI", Login = "******", Password = "******" };
MFI returnedMFI = new MFI();
_mockMFIManagement.SetReturnValue("SelectMFI", mfi);
MFIServices mfiServices = _SetMockManager(_mockMFIManagement);
returnedMFI = mfiServices.FindMFI();
Assert.AreEqual("MFI", returnedMFI.Name);
Assert.AreEqual("Login", returnedMFI.Login);
Assert.AreEqual("Password", returnedMFI.Password);
}
