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(); } }