public static void UpdateStatus(TblMetaquery tblMetaquery, StatusMQ newStatus)
{
using (MetaqueriesContext context = new MetaqueriesContext())
{
tblMetaquery.FkStatusId = (int)(newStatus == StatusMQ.ExpandedAndDone ? StatusMQ.Done : newStatus);
if (newStatus == StatusMQ.WaitingToSolver)
{
tblMetaquery.StartTime = DateTime.Now;
}
if (newStatus == StatusMQ.Done || newStatus == StatusMQ.ExpandedAndDone)
{
tblMetaquery.FinishTime = DateTime.Now;
}
if (newStatus == StatusMQ.Expanded || newStatus == StatusMQ.ExpandedAndDone)
{
tblMetaquery.IsExpanded = true;
}
tblMetaquery.TblDatabaseManagement = null;
context.TblMetaqueries.Attach(tblMetaquery);
//context.Entry(tblMetaquery).State = System.Data.Entity.EntityState.Modified;
context.MarkAsModified(tblMetaquery);
context.SaveChanges();
}
}
public static void Create(TblMetaquery tblMetaquery)
{
using (MetaqueriesContext context = new MetaqueriesContext())
{
context.TblMetaqueries.Add(tblMetaquery);
context.MarkAsCreated(tblMetaquery);
context.SaveChanges();
}
}
public static void Update(TblDatabaseManagement tblDatabaseManagement)
{
using (MetaqueriesContext context = new MetaqueriesContext())
{
context.TblDatabaseManagements.Attach(tblDatabaseManagement);
context.MarkAsModified(tblDatabaseManagement);
context.SaveChanges();
}
}
public static void Create(TblDatabaseManagement tblDatabaseManagement)
{
using (MetaqueriesContext context = new MetaqueriesContext())
{
context.TblDatabaseManagements.Add(tblDatabaseManagement);
context.MarkAsCreated(tblDatabaseManagement);
context.SaveChanges();
}
}
public static void Create(TblProbabilityExperiment tblProbabilityExperiment)
{
using (MetaqueriesContext context = new MetaqueriesContext())
{
context.TblProbabilityExperiments.Add(tblProbabilityExperiment);
context.MarkAsCreated(tblProbabilityExperiment);
context.SaveChanges();
}
}
public static void Update(TblProbabilityExperiment tblProbabilityExperiment)
{
using (MetaqueriesContext context = new MetaqueriesContext())
{
context.TblProbabilityExperiments.Attach(tblProbabilityExperiment);
context.MarkAsModified(tblProbabilityExperiment);
context.SaveChanges();
}
}
public static void UpdateStatus(TblMetaquery tblMetaquery, StatusMQ newStatus)
{
using (MetaqueriesContext context = new MetaqueriesContext())
{
tblMetaquery.FkStatusId = (int)newStatus;
if (newStatus == StatusMQ.WaitingToSolver)
{
tblMetaquery.StartTime = DateTime.Now;
}
if (newStatus == StatusMQ.Done)
{
tblMetaquery.FinishTime = DateTime.Now;
}
context.TblMetaqueries.Attach(tblMetaquery);
//context.Entry(tblMetaquery).State = System.Data.Entity.EntityState.Modified;
context.MarkAsModified(tblMetaquery);
context.SaveChanges();
}
}
