public static string GetTemp(string NameColum)
{
string vall;
Database.SetInitializer<TablesContext>(null);
var db = new TablesContext();
var nfsdf = db.Temp.Where(x => x.NameV == NameColum).Select(x => x.Value).FirstOrDefault();
return nfsdf;
}
public static void ToDisk(string surn, string nam, string secNam,
string DateB, string DateS, int Sal,
string expir, string posit)
{
using (var db = new TablesContext())
{
Database.SetInitializer<TablesContext>(null);
var serm = new Temp();
serm.NameV = "surn";
serm.Value = surn;
db.Temp.Add(serm);
var nem = new Temp();
nem.NameV = "nam";
nem.Value = nam;
db.Temp.Add(nem);
var sec = new Temp();
sec.NameV = "secNam";
sec.Value = secNam;
db.Temp.Add(sec);
var dbirth = new Temp();
dbirth.NameV = "DateB";
dbirth.Value = DateB;
db.Temp.Add(dbirth);
var dstart = new Temp();
dstart.NameV = "DateS";
dstart.Value = DateS;
db.Temp.Add(dstart);
var sala = new Temp();
sala.NameV = "Sal";
sala.Value = Sal.ToString();
db.Temp.Add(sala);
var expr = new Temp();
expr.NameV = "expir";
expr.Value = expir;
db.Temp.Add(expr);
var post = new Temp();
post.NameV = "posit";
post.Value = posit;
db.Temp.Add(post);
db.SaveChanges();
}
}
public static void RefreshTemp()
{
/*
using (var db = new TablesContext())
{
while (db.Temp.Any())
{
db.Temp.Remove(db.Temp.First());
}
db.SaveChanges();
*/
var db = new TablesContext();
db.Database.ExecuteSqlCommand("DELETE FROM Temps WHERE NameV = 'surn'");
db.Database.ExecuteSqlCommand("DELETE FROM Temps WHERE NameV = 'nam'");
db.Database.ExecuteSqlCommand("DELETE FROM Temps WHERE NameV = 'secNam'");
db.Database.ExecuteSqlCommand("DELETE FROM Temps WHERE NameV = 'DateB'");
db.Database.ExecuteSqlCommand("DELETE FROM Temps WHERE NameV = 'DateS'");
db.Database.ExecuteSqlCommand("DELETE FROM Temps WHERE NameV = 'Sal'");
db.Database.ExecuteSqlCommand("DELETE FROM Temps WHERE NameV = 'expir'");
db.Database.ExecuteSqlCommand("DELETE FROM Temps WHERE NameV = 'posit'");
//}
}
private void AddTempValue(string name, string position)
{
using (var db = new TablesContext())
{
var post = new Temp();
post.NameV = name;
post.Value = position;
db.Temp.Add(post);
}
}