public int Guardar(Air air)
{
int rsp = 0;
using (BDAEntities1 bd = new BDAEntities1())
{
bd.Air.Add(air);
rsp = bd.SaveChanges();
}
return(rsp);
}
public int EliminarDato(Air air)
{
int rsp = 0;
using (BDAEntities1 bd = new BDAEntities1())
{
Air _air = bd.Air.Find(air.a);
bd.Air.Remove(_air);
rsp = bd.SaveChanges();
}
return(rsp);
}
public List <RTS_Result> rts()
{
List <RTS_Result> rtsw = null;
using (var context = new BDAEntities1())
{
var d = context.RTS();
foreach (RTS_Result cs in d)
{
Console.WriteLine(cs.a);
}
}
return(rtsw);
}
public int ModificarDatos(Air air)
{
int rsp = 0;
using (BDAEntities1 bd = new BDAEntities1())
{
Air _air = bd.Air.Where(d => d.a == air.a).First();
_air.b = air.b;
_air.c = air.c;
_air.Fecha = air.Fecha;
bd.Entry(_air).State = System.Data.Entity.EntityState.Modified;
rsp = bd.SaveChanges();
}
return(rsp);
}
public List <FDT_Result> D_EjecutarProc(int id)
{
List <FDT_Result> dt = new List <FDT_Result>();
using (BDAEntities1 bd = new BDAEntities1())
{
var data = bd.FDT(id);
dt = data.ToList();
//dataGridView1.DataSource = a;
//foreach (var item in data)
//{
// MessageBox.Show(item.As);
//}
}
return(dt);
}
public List <RTS_Result> DT()
{
List <RTS_Result> rsp = null;
using (BDAEntities1 db = new BDAEntities1())
{
//rsp = db.Air.ToList(); // (from u in db.Air select u).ToList();
}
using (var context = new BDAEntities1())
{
var d = context.RTS();
foreach (RTS_Result cs in d)
{
// rsp = Convert.ToInt32(cs);
}
}
return(rsp);
}
