public async Task AddMeshAsync(string Title, double MeshSize, int PropertyId)
{
using (DBServerContext db = new DBServerContext())
{
db.PROPERTYANDMESHES.Add(new DBDetailsSet.DBDetail_Created.DBAnalysis.DBPropertyAndMesh {
Title = Title, MeshSize = MeshSize, Property = PropertyId
});
await db.SaveChangesAsync();
}
}
public async Task AddMaterialAsync(string Title, double E, double Nu, double G)
{
using (DBServerContext db = new DBServerContext())
{
db.MATERIALS.Add(new DBDetailsSet.DBDetail_Created.DBAnalysis.DBMaterials {
Title = Title, E = E, G = G, Nu = Nu
});
await db.SaveChangesAsync();
}
}
public async Task LogSQLServerAsync(int DBDetailID)
{
using (DBServerContext db = new DBServerContext())
{
DBDetailsSet detailsSet = new DBDetailsSet {
Name = "Набор деталей: " + DBDetailID
};
db.DETAILS.Add(detailsSet);
await db.SaveChangesAsync();
}
}
public async Task AddSizesAsync(int DBDetailID, string DetailName)
{
using (DBServerContext db = new DBServerContext())
{
switch (DetailName)
{
case "Поршень":
db.DETAILS.Find(DBDetailID).Piston = Sizes.Dictonary().Select(x => new DBDetailsSet.DBPiston {
Key = x.Key, Value = x.Value
}).ToList();
break;
case "Шатун":
db.DETAILS.Find(DBDetailID).Rod = Sizes.Dictonary().Select(x => new DBDetailsSet.DBRod {
Key = x.Key, Value = x.Value
}).ToList();
break;
case "Гильза цилиндра":
db.DETAILS.Find(DBDetailID).SleeveCylinder = Sizes.Dictonary()
.Select(x => new DBDetailsSet.DBSleeveCylinder {
Key = x.Key, Value = x.Value
}).ToList();
break;
case "Крышка шатуна":
db.DETAILS.Find(DBDetailID).CoverRod = Sizes.Dictonary().Select(x => new DBDetailsSet.DBCoverRod {
Key = x.Key, Value = x.Value
}).ToList();
break;
case "Поршневой палец":
db.DETAILS.Find(DBDetailID).Finger = Sizes.Dictonary().Select(x => new DBDetailsSet.DBFinger {
Key = x.Key, Value = x.Value
}).ToList();
break;
case "Коленчатый вал":
db.DETAILS.Find(DBDetailID).Crankshaft = Sizes.Dictonary().Select(x => new DBDetailsSet.DBCrankshaft {
Key = x.Key, Value = x.Value
}).ToList();
break;
}
db.DETAILS.Find(DBDetailID).DetailCreated = new List <DBDetailsSet.DBDetail_Created> {
new DBDetailsSet.DBDetail_Created {
DetailsList = DetailName
}
};
await db.SaveChangesAsync();
}
}
public async Task AddLoadAsync(string Title, List <double> SurfaceId, double Value, zLoadType LoadType, double X, double Y, double Z)
{
using (DBServerContext db = new DBServerContext())
{
foreach (double t in SurfaceId)
{
db.LOADS.Add(new DBDetailsSet.DBDetail_Created.DBAnalysis.DBLoads
{
Title = Title,
SurfaceId = t,
Value = Value,
LoadType = LoadType,
X = X,
Y = Y,
Z = Z
});
}
await db.SaveChangesAsync();
}
}
public async Task AddContraintAsync(string Title, List <double> SurfaceId, bool TX, bool TY, bool TZ, bool RX, bool RY, bool RZ)
{
using (DBServerContext db = new DBServerContext())
{
foreach (double t in SurfaceId)
{
db.CONTRAINTS.Add(new DBDetailsSet.DBDetail_Created.DBAnalysis.DBConstraints
{
Title = Title,
SurfaceId = t,
TX = TX,
TY = TY,
TZ = TZ,
RX = RX,
RY = RY,
RZ = RZ
});
}
await db.SaveChangesAsync();
}
}
public async Task AddAnalysisAsync(string Title, int DBDetailID)
{
using (DBServerContext db = new DBServerContext())
{
db.Configuration.AutoDetectChangesEnabled = false;
db.ANALYSIS.Add(new DBDetailsSet.DBDetail_Created.DBAnalysis
{
Title = Title,
Materials = db.MATERIALS.Where(w => w.Analysis == null).ToList(),
Loads = db.LOADS.Where(w => w.Analysis == null).ToList(),
Contraints = db.CONTRAINTS.Where(w => w.Analysis == null).ToList(),
Results = db.RESULTS.Where(w => w.Analysis == null).ToList(),
PropertyAndMeshes = db.PROPERTYANDMESHES.Where(w => w.Analysis == null).ToList(),
MaxMinStress = db.MAXMINSTRESS.Where(w => w.Analysis == null).ToList(),
MaxMinTranslate = db.MAXMINTRANSLATE.Where(w => w.Analysis == null).ToList()
});
db.Configuration.AutoDetectChangesEnabled = true;
db.SaveChanges();
db.CREATEDETAILS.Find(DBDetailID + 1).Analysis = db.ANALYSIS.Select(s => s).ToList()[db.ANALYSIS.Count() - 1];
await db.SaveChangesAsync();
}
}
