public void CheckConstraintViolationExceptionIsRecognized2() { // --- Arrange var child = new ChildRecord { Name = "Child", Value = 4 }; using (var ctx = DataAccessFactory.CreateContext <ITestDataOperations>()) { ctx.InsertChild(child); } // --- Act CheckConstraintViolationException exCaught = null; try { using (var ctx = DataAccessFactory.CreateContext <ITestDataOperations>()) { child.Value = 14; ctx.UpdateChild(child); } } catch (CheckConstraintViolationException ex) { exCaught = ex; } // --- Assert // ReSharper disable once PossibleNullReferenceException exCaught.TableName.ShouldEqual("dbo.Child"); exCaught.CheckName.ShouldEqual("CK_Child_Value"); }
public void UniqueKeyExceptionIsRecognized1() { // --- Arrange var child1 = new ChildRecord { Name = "Child1", Value = 1 }; var child2 = new ChildRecord { Name = "Child1", Value = 2 }; // --- Act UniqueKeyViolationException exCaught = null; try { using (var ctx = DataAccessFactory.CreateContext <ITestDataOperations>()) { ctx.InsertChild(child1); ctx.InsertChild(child2); } } catch (UniqueKeyViolationException ex) { exCaught = ex; } // --- Assert // ReSharper disable once PossibleNullReferenceException exCaught.TableName.ShouldEqual("dbo.Child"); exCaught.KeyName.ShouldEqual("AK_Child_Name"); }
public void NullValueNotAllowedExceptionIsRecognized2() { // --- Arrange var child = new ChildRecord { Name = "Child", Value = 2 }; using (var ctx = DataAccessFactory.CreateContext <ITestDataOperations>()) { ctx.InsertChild(child); } // --- Act NullValueNotAllowedException exCaught = null; try { using (var ctx = DataAccessFactory.CreateContext <ITestDataOperations>()) { child.Value = null; ctx.UpdateChild(child); } } catch (NullValueNotAllowedException ex) { exCaught = ex; } // --- Assert // ReSharper disable once PossibleNullReferenceException exCaught.TableName.ShouldEqual("Seemplest.Test.dbo.Child"); exCaught.ColumnName.ShouldEqual("Value"); }
public void ForeignKeyExceptionIsRecognized1() { // --- Arrange var parent = new ParentRecord { Name = "Parent", }; var child = new ChildRecord { Name = "Child1", Value = 1, ParentId = -1 }; // --- Act ForeignKeyViolationException exCaught = null; try { using (var ctx = DataAccessFactory.CreateContext <ITestDataOperations>()) { ctx.InsertParent(parent, false); ctx.InsertChild(child); } } catch (ForeignKeyViolationException ex) { exCaught = ex; } // --- Assert // ReSharper disable once PossibleNullReferenceException exCaught.KeyName.ShouldEqual("FK_Child_ToParent"); }
private async void HyperlinkClicked(ChildRecord child) { string firstName = child.FirstName; string lastName = child.LastName; int maxRows = 1000; int pageNo = 1; int pageSize = 25; string sortColumn = "name"; string isortOrder = "ASC"; Application.Current.MainPage = new Views.ChildInformationpageView(child.OfflineStudentId); }
private async void EditChildClicked(ChildRecord childRecord) { if (editIconClicked || actionIconClicked) { return; } editIconClicked = true; await App.Current.MainPage.Navigation.PushModalAsync(new ChildTabbedPage(childRecord.OfflineStudentId)); await Task.Delay(300); editIconClicked = false; }
private async void ActionClicked(ChildRecord child) { if (actionIconClicked || editIconClicked) { return; } FullName = child.FirstName + " " + child.LastName; actionIconClicked = true; await PopupNavigation.Instance.PushAsync(new AssessmentConfigPopupView(child.OfflineStudentId)); await Task.Delay(300); actionIconClicked = false; }
public int UpdateChild(ChildRecord record) { Operation(ctx => ctx.Update(record)); return(record.Id); }
public int InsertChild(ChildRecord record) { Operation(ctx => ctx.Insert(record)); return(record.Id); }