public static void delete(int id)
{
using (sisEntities2 context = new sisEntities2())
{
student obj = context.students.First(x => x.Id == id);
context.students.Remove(obj);
context.SaveChanges();
}
}
public static List <student> getallusers()
{
List <student> lst = null;
using (sisEntities2 db = new sisEntities2())
{
lst = (from u in db.students select u).ToList();
}
return(lst);
}
public static List <student> getallusers(String uname)
{
List <student> lst = null;
using (sisEntities2 db = new sisEntities2())
{
lst = (from u in db.students select u).Where(x => x.stu_name == uname).ToList();
}
return(lst);
}
public static List <student> getallusers(String uname)
{
List <student> lst = null;
using (sisEntities2 db = new sisEntities2()) // this comment is use for the return and also it show the taht where are you in table //
{
lst = (from u in db.students select u).Where(x => x.stu_name == uname).ToList();
}
return(lst);
}
public static void EditUpdate(int id, String name, String email, String mno)
{
using (sisEntities2 context = new sisEntities2())
{
student obj = context.students.First(x => x.Id == id);
obj.stu_name = name;
obj.stu_email = email;
obj.stu_mno = mno;
obj.stu_batch = obj.stu_batch;
obj.stu_stream = obj.stu_stream;
context.SaveChanges();
}
}
public static void registernew(String uname, String upass)
{
using (sisEntities2 context = new sisEntities2())
{
student_register obj = new student_register();
obj.username = uname;
obj.password = upass;
context.student_register.Add(obj);
context.SaveChanges();
}
}
public static bool adminlogin(String uname, String password)
{
using (sisEntities2 context = new sisEntities2())
{
admin obj = (admin)context.admins.Where(x => x.username == uname).Where(x => x.password == password).FirstOrDefault();
if (obj == null)
{
return(false);
}
else
{
return(true);
}
}
}
public static bool userlogin(String uname, String password)
{
using (sisEntities2 context = new sisEntities2())
{
student_register obj = (student_register)context.student_register.Where(x => x.username == uname).Where(x => x.password == password).FirstOrDefault();
if (obj == null)
{
return(false);
}
else
{
return(true);
}
}
}
