/// <summary>
/// User To Partner
/// </summary>
/// <param name="userToPartner"></param>
/// <returns></returns>
public ForgotPasswordViewModel UserToPartner(ForgotPasswordViewModel userToPartner)
{
ForgotPasswordViewModel logModel = new ForgotPasswordViewModel();
try
{
if (userToPartner != null)
{
using (var db = new Orchard9Entities())
{
var v = db.tblUsers.Where(a => a.EmailId == userToPartner.EmailId && a.UserType != "External").FirstOrDefault();
var v1 = db.tblUsers.Where(a => a.EmailId == userToPartner.EmailId && a.IsActive == false).FirstOrDefault();
var v2 = db.tblUsers.Where(a => a.EmailId == userToPartner.EmailId && a.Role == 5).FirstOrDefault();
if (v1 != null)
{
logModel.StatusMessage = "You are Blocked by Admin";
return(logModel);
}
if (v != null)
{
if (string.Compare(userToPartner.Password, v.Password) == 0)
{
if (v2 != null)
{
logModel.StatusMessage = "You are already in the Waiting List";
return(logModel);
}
db.tblUsers.Where(u => u.EmailId == userToPartner.EmailId).ToList().ForEach(s => s.Role = 5);
db.SaveChanges();
logModel.StatusMessage = "Successfully Added to Partner waiting list";
return(logModel);
}
else
{
logModel.StatusMessage = "Invalid Password";
return(logModel);
}
}
else
{
logModel.StatusMessage = "External Users Cannot become partner without registration ";
return(logModel);
}
}
}
else
{
logModel.StatusMessage = "Input model is empty";
return(logModel);
}
}
catch (Exception ex)
{
logModel.StatusMessage = ex.Message;
return(logModel);
}
}
public string Buy(int UserId) //This method is change the payment status of the items
{ //in the cart when the user clicks on the buy button.
string str;
try
{
using (var db = new Orchard9Entities())
{
if ((from e in db.tblUsers where e.UserId == UserId && e.IsActive == false select e.UserId).ToList().Count > 0)
{
return("You are Blocked by Admin");
}
else
{
db.tblCarts.Where(u => u.UserId == UserId).ToList().ForEach(s => s.PayStatus = false);
db.SaveChanges();
str = "Payment Successfull";
}
}
}
catch (Exception e)
{
str = e.Message;
}
return(str);
}
//Adds the book from wishlist to cart
public string addToCart(WishListModel wish)
{
string s = "";
try
{
using (var dbcontext = new Orchard9Entities())
{
if ((from e in dbcontext.tblCarts where e.ISBN == wish.ISBN && e.UserId == wish.UserId select e.CartId).ToList().Count > 0)
{
return("Already present");
}
else
{
dbcontext.tblCarts.Add(new tblCart()
{
CartId = wish.id,
ISBN = wish.ISBN,
UserId = wish.UserId,
PayStatus = true,
Quantity = 1
});
dbcontext.SaveChanges();
return("Added to cart");
}
}
}
catch (Exception e)
{
s = e.Message;
}
return(s);
}
/// <summary>
/// Partner Registration
/// </summary>
/// <param name="userTableClass"></param>
/// <returns></returns>
public RegistrationResponseViewModel AddPartner(UserTableClass userTableClass)
{
RegistrationResponseViewModel model = new RegistrationResponseViewModel();
try
{
if (userTableClass != null)
{
using (var db = new Orchard9Entities())
{
//checking whether email already exists in the database or not
var isEmailExist = db.tblUsers.Where(a => a.EmailId == userTableClass.EmailId).FirstOrDefault();
if (isEmailExist == null)
{
db.tblUsers.Add(new tblUser()
{
EmailId = userTableClass.EmailId,
Name = userTableClass.Name,
Password = userTableClass.Password,
ContactNo = userTableClass.ContactNo,
Gender = userTableClass.Gender,
Address = userTableClass.Address,
ReferralId = userTableClass.ReferralId,
DateOfBirth = userTableClass.DateOfBirth,
IsVerified = false,
Role = 5,
IsActive = true,
CreatedDate = DateTime.Now,
UserType = "Normal"
});
//saving changes to database
db.SaveChanges();
var data = (from res in db.tblUsers
where res.EmailId == userTableClass.EmailId
select new { res.EmailId, res.UserId }).FirstOrDefault();
model.UserId = data.UserId;
model.Email = data.EmailId;
model.StatusMessage = "Registration successfully done. Account activation link has been sent to your Email ID " + model.Email;
}
else
{
model.StatusMessage = "Email Already Exist";
}
}
}
else
{
model.StatusMessage = "Input model is empty";
}
}
catch (Exception ex)
{
model.StatusMessage = ex.Message;
}
return(model);
}
/// <summary>
/// Google Login
/// </summary>
/// <param name="googleLogin"></param>
/// <returns></returns>
public LoginResponseViewModel GoogleLogin(GoogleLogin googleLogin)
{
LoginResponseViewModel googleModel = new LoginResponseViewModel();
if (googleLogin != null)
{
using (var db = new Orchard9Entities())
{
var gUser = db.tblUsers.Where(a => a.EmailId == googleLogin.emailaddress).FirstOrDefault();
var gUser1 = db.tblUsers.Where(a => a.EmailId == googleLogin.emailaddress && a.IsActive == true).FirstOrDefault();
if (gUser1 == null)
{
googleModel.StatusMessage = "Account is Blocked";
return(googleModel);
}
if (gUser == null)
{
db.tblUsers.Add(new tblUser()
{
EmailId = googleLogin.emailaddress,
Name = googleLogin.givenname,
IsVerified = true,
UserType = "External",
Role = 1,
IsActive = true,
CreatedDate = DateTime.Now,
DateOfBirth = DateTime.Now.Date
});
db.SaveChanges();
googleModel.StatusMessage = "Login Successful";
}
googleModel.userLogin = (from res in db.tblUsers
where res.EmailId == googleLogin.emailaddress
select new UserLogin()
{
EmailId = res.EmailId,
UserId = res.UserId
}).FirstOrDefault();
googleModel.StatusMessage = "Login Successful";
return(googleModel);
}
}
else
{
googleModel.StatusMessage = "Empty Model";
}
return(googleModel);
}
public string InvoiceTableUpdate()
{
using (var db = new Orchard9Entities())
{
try
{
var query = db.tblUsers.Where(x => x.IsActive == false).Select(r => r.UserId).Distinct().ToList();
db.tblInvoices.Where(y => query.Contains((int)y.UserId)).ToList().ForEach(y => y.InvoiceStatus = false);
db.SaveChanges();
return("Success");
}
catch (Exception e)
{
return(e.Message);
}
}
}
public string RemoveBook(string ISBN)
{
string message;
try
{
using (var db = new Orchard9Entities())
{
db.tblBooks.Where(u => u.ISBN == ISBN).ToList().ForEach(s => s.isactive = false);
db.SaveChanges();
message = ISBN + " removed ";
}
}
catch (Exception e)
{
message = e.Message;
}
return(message);
}
public string AddInvoice(InvoiceView invoiceView)
{
string msg = "";
try
{
using (var db = new Orchard9Entities())
{
if ((from e in db.tblUsers where e.UserId == invoiceView.UserId && e.IsActive == false select e.UserId).ToList().Count > 0)
{
return("You are Blocked by Admin");
}
else
{
if ((from e in db.tblInvoices
where e.UserId == invoiceView.UserId && e.CartId == invoiceView.CartId
select e.InvoiceId).ToList().Count > 0)
{
return("Invoice is generated already");
}
else
{
db.tblInvoices.Add(new tblInvoice()
{
UserId = invoiceView.UserId,
CartId = invoiceView.CartId,
InvoiceStatus = true
});
db.SaveChanges();
return("Invoice Added");
}
}
}
}
catch (Exception e)
{
msg = e.Message;
}
return(msg);
}
//deletes the book from wishlist
public string deleteFromWishList(int wishListId)
{
string s = "";
try
{
using (var dbcontext = new Orchard9Entities())
{
tblWishlist test = dbcontext.tblWishlists.Find(wishListId);
dbcontext.tblWishlists.Remove(test);
dbcontext.SaveChanges();
return("deletion successful");
}
}
catch (Exception e)
{
s = e.Message;
}
return(s);
}
public string Remove(int CartId) //This method is used for removing a book from the cart.
{
string message;
try
{
using (var db = new Orchard9Entities())
{
tblCart a1 = db.tblCarts.Find(CartId);
db.tblCarts.Remove(a1);
db.SaveChanges();
message = CartId + " removed from cart";
}
}
catch (Exception e)
{
message = e.Message;
}
return(message);
}
//adds the book to wishlist
public string addToWishList(WishListModel wish)
{
string s = "";
try
{
using (var dbcontext = new Orchard9Entities())
{
if ((from e in dbcontext.tblUsers where e.UserId == wish.UserId && e.IsActive == false select e.UserId).ToList().Count > 0)
{
return("You are Blocked by Admin");
}
else
{
if ((from e in dbcontext.tblWishlists where e.ISBN == wish.ISBN && e.UserId == wish.UserId select e.id).ToList().Count > 0)
{
return("Already present");
}
else
{
dbcontext.tblWishlists.Add(new tblWishlist()
{
id = wish.id,
ISBN = wish.ISBN,
UserId = wish.UserId,
CurrentPrice = wish.price
});
dbcontext.SaveChanges();
return("added successfully");
}
}
}
}
catch (Exception e)
{
s = e.Message;
}
return(s);
}
public string AddToCart(Cart cart)
{
string msg = "";
try
{
using (var db = new Orchard9Entities())
{
if ((from e in db.tblUsers where e.UserId == cart.UserId && e.IsActive == false select e.UserId).ToList().Count > 0)
{
return("You are Blocked by Admin");
}
else
{
if ((from e in db.tblCarts where e.ISBN == cart.ISBN && e.UserId == cart.UserId && e.PayStatus == true select e.CartId).ToList().Count > 0)
{
return("Already Present");
}
else
{
db.tblCarts.Add(new tblCart()
{
ISBN = cart.ISBN,
UserId = cart.UserId,
PayStatus = true,
Quantity = 1
});
db.SaveChanges();
return("Added to Cart");
}
}
}
}
catch (Exception e)
{
msg = e.Message;
}
return(msg);
}
public string ApprovePartner(int UserId)
{
string msg = "";
try
{
using (var db = new Orchard9Entities())
{
{
db.tblUsers.Where(u => u.UserId == UserId).ToList().ForEach(s => s.Role = 3);
db.SaveChanges();
msg = "Partner Approved";
return(msg);
}
}
}
catch (Exception e)
{
msg = e.Message;
}
return(msg);
}
public string EditBook(BookEditView book)
{
string message = "";
try
{
using (var db = new Orchard9Entities())
{
db.tblBooks.Where(b => b.ISBN == book.ISBN).ToList().ForEach(b =>
{
b.Price = book.Price;
});
db.SaveChanges();
message = book.ISBN + " Price updated";
}
}
catch (Exception e)
{
message = e.Message;
}
return(message);
}
public string UnblockUser(int UserId)
{
string msg = "";
try
{
using (var db = new Orchard9Entities())
{
{
db.tblUsers.Where(u => u.UserId == UserId).ToList().ForEach(s => s.IsActive = true);
db.SaveChanges();
msg = "User Unblocked";
return(msg);
}
}
}
catch (Exception e)
{
msg = e.Message;
}
return(msg);
}
/// <summary>
/// User Verifiction
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public string UserVerification(int UserId)
{
try
{
using (var db = new Orchard9Entities())
{
var verifyUser = db.tblUsers.Where(a => a.UserId == UserId).FirstOrDefault();
if (verifyUser != null)
{
db.tblUsers.Where(a => a.UserId == UserId).ToList().ForEach(i => i.IsVerified = true);
db.SaveChanges();
return("User verified successfully");
}
else
{
return("User verification Error");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AddBook(BookView book)
{
string msg = "";
try
{
using (var db = new Orchard9Entities())
{
if ((from e in db.tblUsers where e.UserId == book.UserId && e.IsActive == false select e.UserId).ToList().Count > 0)
{
return("You are Blocked by Admin");
}
else if ((from e in db.tblBooks where (e.ISBN == book.ISBN && e.isactive == false) select e.ISBN).ToList().Count > 0)
{
db.tblBooks.Where(b => b.ISBN == book.ISBN).ToList().ForEach(b =>
{
b.BookName = book.BookName;
b.Category = book.Category;
b.Price = book.Price;
b.Rating = book.Rating;
b.Author = book.Author;
b.Publisher = book.Publisher;
b.Description = book.Description;
b.BookImageUrl = book.BookImageUrl;
b.isactive = true;
b.createddate = System.DateTime.Now;
});
db.SaveChanges();
return("Book updated");
}
else if ((from e in db.tblBooks where e.ISBN == book.ISBN || (e.BookName == book.BookName && e.Author == book.Author) select e.ISBN).ToList().Count > 0)
{
return("Book Already Exists");
}
else
{
db.tblBooks.Add(new tblBook()
{
ISBN = book.ISBN,
BookName = book.BookName,
Category = book.Category,
Price = book.Price,
Rating = book.Rating,
Author = book.Author,
Publisher = book.Publisher,
Description = book.Description,
BookImageUrl = book.BookImageUrl,
isactive = true,
createddate = System.DateTime.Now
});
db.SaveChanges();
return("New Book Added");
}
}
}
catch (Exception e)
{
msg = e.Message;
}
return(msg);
}
public PriceStatus modifybook(WishListModel wish)
{
string s = "";
PriceStatus pr = new PriceStatus();
try
{
using (var dbcontext = new Orchard9Entities())
{
double?amount = 0;
if ((from d in dbcontext.tblWishlists where d.ISBN == wish.ISBN select d).Count() > 0)
{
amount = (from d in dbcontext.tblWishlists where d.ISBN == wish.ISBN select d.CurrentPrice).FirstOrDefault();
}
else
{
amount = (from d in dbcontext.tblBooks where d.ISBN == wish.ISBN select d.Price).FirstOrDefault();
}
var dis = Convert.ToDouble(wish.price);
var query = (from e in dbcontext.tblWishlists
join d in dbcontext.tblBooks on e.ISBN equals d.ISBN
join x in dbcontext.tblUsers on e.UserId equals x.UserId
where e.UserId == x.UserId && wish.ISBN == d.ISBN
select new PriceModel()
{
mailid = x.EmailId
}).ToList();
if ((from d in dbcontext.tblBooks where d.ISBN == wish.ISBN select d.Price).ToList().Count == 0)
{
pr.statusMessage = "This book does not exist";
return(pr);
}
if (amount == dis)
{
pr.statusMessage = "no changes";
pr.statusList = query;
pr.changedPrice = 0;
pr.bookName = wish.BookName;
}
else if (amount > dis)
{
pr.changedPrice = amount - dis;
pr.statusList = query;
pr.statusMessage = "reduced";
pr.bookName = wish.BookName;
}
else
{
pr.changedPrice = dis - amount;
pr.statusList = query;
pr.bookName = wish.BookName;
pr.statusMessage = "increased";
}
dbcontext.tblBooks.Where(h => h.ISBN == wish.ISBN).ToList().ForEach(h =>
{
h.Price = wish.price;
h.Publisher = wish.Publisher;
h.Author = wish.Author;
h.Rating = wish.rating;
h.BookName = wish.BookName;
h.Description = "jj";
h.Category = "hhh";
h.isactive = true;
h.BookImageUrl = wish.BookImageUrl;
});
dbcontext.tblWishlists.Where(h => h.ISBN == wish.ISBN).ToList().ForEach(h =>
{
h.CurrentPrice = wish.price;
});
dbcontext.SaveChanges();
}
}
catch (Exception e)
{
s = e.Message;
pr.statusMessage = s;
}
return(pr);
}
