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