public string GetWellId() { if (WellTable != null) { SqlParameter param1 = new SqlParameter("@param1", this.WellTable.TableName); BaseModelContext <WellModel> db = new BaseModelContext <WellModel>(); var query = db.Database.SqlQuery <WellModel>("GetWellID @param1", param1); foreach (var item in query) { return(item.NewId); } } return(null); }
/// <summary> /// Increments Position property then calls base.SaveChanges() /// </summary> /// <returns></returns> public override int SaveChanges() { var entries = ChangeTracker.Entries().Where(x => x.Entity is AppFieldModel && (x.State == EntityState.Added || x.State == EntityState.Modified)); foreach (var entry in entries) { if (((AppFieldModel)entry.Entity).Position == 0) { BaseModelContext <AppFieldModel> db = new BaseModelContext <AppFieldModel>(); int nextPosition = db.Models.Where(m => m.AppId == ((AppFieldModel)entry.Entity).AppId).Count(); ((AppFieldModel)entry.Entity).Position = nextPosition + 1; } } return(base.SaveChanges()); }