public List <TelephoneNumber> GetAll()
{
var numberServices = new TelephoneNumberDbOperations();
var number = numberServices.GetAll();
return(number);
}
public void When_Update_Is_Called_After_Inserting_Valid_Data_It_Should_Update()
{
var telephoneDbOperation = new TelephoneNumberDbOperations();
var telephone = new TelephoneNumber()
{
UId = 2, PhoneNumber = "+91 9930774145", NumberType = "Work"
};
var pid = telephoneDbOperation.Create(telephone);
telephone.UId = 3;
telephone.PhoneNumber = "+91 9820175604";
telephone.NumberType = "Home";
telephone.PId = pid;
telephoneDbOperation.Update(telephone);
using (var con = new SqlConnection(TelephoneNumberDbOperations.ConnectionString))
{
var createdNumber = con.Query <TelephoneNumber>($"SELECT * FROM TelephoneNumbers WHERE PId = {pid}")
.FirstOrDefault();
Assert.AreEqual(createdNumber.PhoneNumber, telephone.PhoneNumber);
Assert.AreEqual(createdNumber.NumberType, telephone.NumberType);
}
}
public TelephoneNumber GetById(TelephoneNumber telephone)
{
var numberServices = new TelephoneNumberDbOperations();
numberServices.GetById(telephone);
return(telephone);
}
public void When_GetAll_Is_Called_It_Should_Return_A_List_Of_TelePhoneNumbers_And_Pass()
{
var telephoneDbOperation = new TelephoneNumberDbOperations();
List <TelephoneNumber> list = telephoneDbOperation.GetAll();
Assert.Pass();
}
public void When_Create_Is_Called_With_Data_Of_Exceeded_Length_It_Should_Throw_A_SqlException(int uid, string number, string type)
{
var telephoneDbOperation = new TelephoneNumberDbOperations();
var telephone = new TelephoneNumber()
{
UId = uid, PhoneNumber = number, NumberType = type
};
Assert.Throws <SqlException>(() => telephoneDbOperation.Create(telephone));
}
public bool Create(TelephoneNumber telephone)
{
var numberServices = new TelephoneNumberDbOperations();
if (IsValid(telephone))
{
var pid = numberServices.Create(telephone);
telephone.PId = pid;
return(true);
}
return(false);
}
public void When_GetById_Is_Called_It_Should_Return_The_TelephoneNumber_With_The_Id_And_Pass()
{
var telephoneDbOperation = new TelephoneNumberDbOperations();
var telephone = new TelephoneNumber()
{
UId = 3, PhoneNumber = "+91 9920802227", NumberType = "Office"
};
var pid = telephoneDbOperation.Create(telephone);
telephone.PId = pid;
var person = telephoneDbOperation.GetById(telephone);
Assert.Pass();
}
public void When_Delete_Is_Called_With_Valid_Data_It_Should_Delete()
{
var telephoneDbOperation = new TelephoneNumberDbOperations();
var telephone = new TelephoneNumber()
{
UId = 3, PhoneNumber = "+91 9819935133", NumberType = "Work"
};
var pid = telephoneDbOperation.Create(telephone);
telephone.PId = pid;
telephoneDbOperation.Delete(telephone);
Assert.Pass();
}
public void When_Update_Is_Called_After_Setting_Exceeded_Length_Updated_Values_It_Should_Throw_A_SqlException(int uid, string number, string type,
int updatedUid, string updatedNumber, string updatedType)
{
var telephoneDbOperation = new TelephoneNumberDbOperations();
var telephone = new TelephoneNumber()
{
UId = uid, PhoneNumber = number, NumberType = type
};
var pid = telephoneDbOperation.Create(telephone);
telephone.UId = updatedUid;
telephone.PhoneNumber = updatedNumber;
telephone.NumberType = updatedType;
telephone.PId = pid;
Assert.Throws <SqlException>(() => telephoneDbOperation.Update(telephone));
}
public void When_Create_Is_Called_With_Valid_Data_It_Should_Save()
{
var telephoneDbOperation = new TelephoneNumberDbOperations();
var telephone = new TelephoneNumber()
{
UId = 1, PhoneNumber = "+91 895678268", NumberType = "Office"
};
telephoneDbOperation.Create(telephone);
using (var conn = new SqlConnection(TelephoneNumberDbOperations.ConnectionString))
{
var createdNumber = conn.Query <TelephoneNumber>("SELECT * FROM TelephoneNumbers WHERE UId = '1'").FirstOrDefault();
Assert.IsNotNull(createdNumber);
Assert.AreEqual(telephone.UId, createdNumber.UId);
Assert.AreEqual(telephone.PhoneNumber, createdNumber.PhoneNumber);
Assert.AreEqual(telephone.NumberType, createdNumber.NumberType);
}
}
public void Delete(TelephoneNumber telephone)
{
var numberServices = new TelephoneNumberDbOperations();
numberServices.Delete(telephone);
}
