public static void InsertBookDetails(book booksdetails) { using (EntityEntities db = new EntityEntities()) { db.books.Add(booksdetails); db.SaveChanges(); } }
public static void InsertAddress(address insertadd) { using (EntityEntities db = new EntityEntities()) { db.addresses.Add(insertadd); db.SaveChanges(); } }
public static void InsertCheckoutBooks(checkout checkoutdetails) { using (EntityEntities db = new EntityEntities()) { db.checkouts.Add(checkoutdetails); db.SaveChanges(); } }
public static int SaveRegistration(REGISTER insertreg) { using (EntityEntities db = new EntityEntities()) { db.REGISTERs.Add(insertreg); db.SaveChanges(); return(insertreg.ID); } }
public static List <book> GetAllBooks() { List <book> lst = null; using (EntityEntities db = new EntityEntities()) { lst = (from u in db.books select u).ToList(); } return(lst); }
public static List <REGISTER> GetUserDetails(string selectedValue) { List <REGISTER> lst = null; using (EntityEntities db = new EntityEntities()) { lst = (from u in db.REGISTERs where u.ID.ToString() == selectedValue select u).ToList(); } return(lst); }
public static List <checkout> GetAllcheckout() { List <checkout> lst = null; using (EntityEntities db = new EntityEntities()) { var lst1 = (from u in db.checkouts select u).ToList(); return(lst); } }
public static List <address> GetAllAddress() { List <address> lst = null; using (EntityEntities db = new EntityEntities()) { lst = (from u in db.addresses select u).ToList(); return(lst); } }
public static List <REGISTER> GetAllStudents() { List <REGISTER> lst = null; using (EntityEntities db = new EntityEntities()) { lst = (from u in db.REGISTERs select u).ToList(); } return(lst); }
public static void DeleteRecord(string insertreg) { using (EntityEntities db = new EntityEntities()) { REGISTER c = db.REGISTERs.SingleOrDefault(x => x.ID.ToString().Trim() == insertreg.Trim()); if (c != null) { db.REGISTERs.Remove(c); db.SaveChanges(); } } }
public static int UpdateRegistration(REGISTER insertreg) { using (EntityEntities db = new EntityEntities()) { //Lembda expression REGISTER c = db.REGISTERs.SingleOrDefault(x => x.ID == insertreg.ID); c.FNAME = insertreg.FNAME; c.LNAME = insertreg.LNAME; c.EMAILID = insertreg.EMAILID; c.PASSWORD = insertreg.PASSWORD; db.SaveChanges(); return(insertreg.ID); } }
public static List <Login> GetDataTable(string username, string password) { try { List <Login> lst = null; using (EntityEntities db = new EntityEntities()) { lst = (from u in db.Logins where u.username == username && u.password == password select u).ToList(); return(lst); } } catch (Exception ex) { throw ex; } }