public FKandNavigationFromModel(T model) { _db = new B2BEntities(); _dbSet = _db.Set <T>(); _model = model; _assem = typeof(MockUpClass).Assembly; }
public int GetuserID(string email) { B2BEntities db = new B2BEntities(); int query = (from x in db.Users where x.email == email select x.Id).FirstOrDefault(); //first or default means its getting the first data which is the ID in this case. return(query); //x.email == email means a column called email in the user data is equals to the variable called email }
public CRUDController() { _db = new B2BEntities(); _dbSet = _db.Set <TEntity>(); _className = this.GetType().Name; _className = _className.Remove(_className.Length - 10); }
public string UpdateProduct(Product prod) { try { using (B2BEntities db = new B2BEntities()) { var result = db.Products.SingleOrDefault(p => p.Id == prod.Id); if (result != null) { result.Id = prod.Id; result.name = prod.name; result.description = prod.description; result.price = prod.price; result.image1 = prod.image1; db.SaveChanges(); return(prod.name + " was successfully saved"); } else { return("error because no result shown"); } } } catch (Exception e) { return("Error:" + e); } }
public bool GetLogin(string email, string password) { B2BEntities db = new B2BEntities(); string query = (from x in db.Users where x.email == email && x.password == password select x.userType).FirstOrDefault(); if (query != null) { HttpContext.Current.Session["userType"] = query; return(true); } return(false); }
public string AddProduct(Product prod) { try { B2BEntities db = new B2BEntities(); db.Products.Add(prod); db.SaveChanges(); return(prod.name + " was successfully added"); } catch (Exception e) { return("Error:" + e); } }
public RepositoryBase() { db = new B2BEntities(); repo = new GenericRepository <TModel>(db); _config1 = new MapperConfiguration(cfg => { cfg.CreateMap <TViewModel, TModel>(); }); _config2 = new MapperConfiguration(cfg => { cfg.CreateMap <TModel, TViewModel>(); }); }
public Payment GetPayment(int id) { try { using (B2BEntities db = new B2BEntities()) { Payment payment = db.Payments.Find(id); return(payment); } } catch (Exception) { return(null); } }
public string AddPayment(Payment payment) { try { B2BEntities db = new B2BEntities(); db.Payments.Add(payment); db.SaveChanges(); return("Product was successfully purchased"); } catch (Exception e) { return("Error:" + e); } }
public Product GetProduct(int id) { try { using (B2BEntities db = new B2BEntities()) { Product prod = db.Products.Find(id); return(prod); } } catch (Exception) { return(null); } }
public Plan GetPlan(int id) { try { using (B2BEntities db = new B2BEntities()) { Plan plan = db.Plans.Find(id); return(plan); } } catch (Exception) { return(null); } }
public User GetUser(int id) { try { using (B2BEntities db = new B2BEntities()) { User user = db.Users.Find(id); return(user); } } catch (Exception) { return(null); } }
public List <Payment> GetAllPayments() { try { using (B2BEntities db = new B2BEntities()) { List <Payment> pay = (from x in db.Payments select x).ToList(); return(pay); } } catch (Exception) { return(null); } }
public List <Payment> getAllPayments(int userid) { try { using (B2BEntities db = new B2BEntities()) { List <Payment> payment = (from x in db.Payments where x.userId == userid select x).ToList(); return(payment); } } catch (Exception) { return(null); } }
public List <User> GetAllUsers() { try { using (B2BEntities db = new B2BEntities()) { List <User> user = (from x in db.Users where x.userType == "Customer" select x).ToList(); return(user); } } catch (Exception) { return(null); } }
public string AddUser(User users) { try { B2BEntities db = new B2BEntities(); db.Users.Add(users); db.SaveChanges(); return(users.email + "was successfully registered"); } catch (Exception e) { return("Error:" + e); } }
public List <Inquiry> GetAllInquiries() { try { using (B2BEntities db = new B2BEntities()) { List <Inquiry> inquiry = (from x in db.Inquiries select x).ToList(); return(inquiry); } } catch (Exception) { return(null); } }
public List <Plan> GetAllPlan() { try { using (B2BEntities db = new B2BEntities()) { List <Plan> plan = (from x in db.Plans select x).ToList(); return(plan); } } catch (Exception) { return(null); } }
public string AddInquiry(Inquiry inquiry) { try { B2BEntities db = new B2BEntities(); db.Inquiries.Add(inquiry); db.SaveChanges(); return(inquiry.email + "was successfully submitted, please wait for our customer service to respond to your inquiries, Thank You."); } catch (Exception e) { return("Error:" + e); } }
public List <Product> GetAllProducts() { try { using (B2BEntities db = new B2BEntities()) { List <Product> prod = (from x in db.Products select x).ToList(); return(prod); } } catch (Exception) { return(null); } }
public void ChangePass(string newpass, int id) { try { using (B2BEntities db = new B2BEntities()) { User currentuser = db.Users.SingleOrDefault(x => x.Id == id); currentuser.password = newpass; db.SaveChanges(); } } catch (Exception) { } }
public IEnumerable <Sponsor> GetSponsorByType(int sponsoryTypeID) { List <Sponsor> sponsorList = new List <Sponsor>(); IEnumerable <spSelectSponsorByType_Result> sponsorEFList; using (var context = new B2BEntities()) { sponsorEFList = context.spSelectSponsorByType(sponsoryTypeID).ToList(); foreach (spSelectSponsorByType_Result item in sponsorEFList) { Sponsor sponsor = new Sponsor(); sponsor.Name = item.Name; sponsor.SponsorID = item.SponsorID; sponsor.Description = item.Description; sponsor.TypeID = item.SponsorTypeID; sponsor.TypeName = item.TypeName; sponsorList.Add(sponsor); } } return(sponsorList); }
public string UpdateUser(User newUser) { try { using (B2BEntities db = new B2BEntities()) { /* * Single or default = returns single object (user) using the ID * */ var currentUser = db.Users.SingleOrDefault(x => x.Id == newUser.Id); if (currentUser != null) { /* * newUser replaces currentUser as it belongs to the object User * which means data is updated in that objected by passing it to the variable newUser * */ currentUser.fullName = newUser.fullName; currentUser.companyName = newUser.companyName; currentUser.email = newUser.email; currentUser.password = newUser.email; currentUser.country = newUser.country; db.SaveChanges(); return("Your profile has been successfully changed"); } else { return("error with id " + newUser.Id); } } } catch (Exception) { return(null); } }