public void Save(Student user)
{
using (hadafDBEntities DC = conn.GetContext())
{
// ==== INSERT ====
DC.Students.Add(user);
DC.SaveChanges();
}
}
public void Savestatus(enter user)
{
using (hadafDBEntities DC = conn.GetContext())
{
//==== UPDATE ====
DC.enters.Attach(user);
DC.Entry(user).State = EntityState.Modified;
DC.SaveChanges();
}
}
public enter FindByUserName(string username)
{
enter result = null;
using (hadafDBEntities DC = conn.GetContext())
{
//-- SELECT * FROM vPhoneList WHERE PhobeID = phoneID
result = (from r in DC.enters
where r.Username == username
select r).FirstOrDefault();
}
return(result);
}
public Counter FindBystdid(Int64 username)
{
Counter result = null;
using (hadafDBEntities DC = conn.GetContext())
{
//-- SELECT * FROM vPhoneList WHERE PhobeID = phoneID
result = (from r in DC.Counters
where r.stdid == username
select r).FirstOrDefault();
}
return(result);
}
public DataTable GetAllKarGList()
{
List <KarG> result = new List <KarG>();
using (hadafDBEntities DC = conn.GetContext())
{
IEnumerable <KarG> pl =
from r in DC.KarGs
orderby r.id
select r;
result = pl.ToList();
}
return(HadafTools.ToDataTable(result));
}
public DataTable Getstatus()
{
List <enter> result = new List <enter>();
using (hadafDBEntities DC = conn.GetContext())
{
IEnumerable <enter> pl =
from r in DC.enters
where r.Status == 0
orderby r.id
select r;
result = pl.ToList();
}
return(HadafTools.ToDataTable(result));
}
public DataTable GetStdList(string reshte)
{
List <Student> result = new List <Student>();
using (hadafDBEntities pb = conn.GetContext())
{
IEnumerable <Student> pl =
from r in pb.Students
where
r.Reshte == reshte
select r;
result = pl.ToList();
}
return(HadafTools.ToDataTable(result));
}
public DataTable GetLinkUrl(Int64 StdID)
{
List <Counter> result = new List <Counter>();
using (hadafDBEntities pb = conn.GetContext())
{
IEnumerable <Counter> pl =
from r in pb.Counters
where
r.stdid == StdID
select r;
result = pl.ToList();
}
return(HadafTools.ToDataTable(result));
}
//public void SaveAdmin(enter user)
//{
// using (hadafDBEntities DC = conn.GetContext())
// {
// //==== UPDATE ====
// DC.enters.Attach(user);
// DC.Entry(user).State = EntityState.Modified;
// DC.SaveChanges();
// }
//}
public void Saveuser(enter user)
{
using (hadafDBEntities DC = conn.GetContext())
{
//if (enter. > 0)
//{
// //==== UPDATE ====
// DC.enters.Attach(enter);
// DC.Entry(enter).State = EntityState.Modified;
//}
//else
//{
//==== INSERT ====
DC.enters.Add(user);
// }
DC.SaveChanges();
}
}
public void Savecourse(Counter counter)
{
using (hadafDBEntities DC = conn.GetContext())
{
if (counter.id > 0)
{
//==== UPDATE ====
DC.Counters.Attach(counter);
DC.Entry(counter).State = EntityState.Modified;
}
else
{
//==== INSERT ====
DC.Counters.Add(counter);
}
DC.SaveChanges();
}
}
