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