public static BookStoreAdmin.ViewModels.LoginResponse ValidateUser(string user_name, string password)
{
BookStoreAdmin.ViewModels.LoginResponse loginResponse = new LoginResponse();
BookStoreAdmin.Models.user objUser;
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
objUser = context.users.SingleOrDefault(user => user.user_name == user_name && user.password == password);
}
if (objUser == null)
{
loginResponse.fullName = "";
loginResponse.isValidUser = false;
loginResponse.userName = "";
loginResponse.errorMessage = "Invalid User Name / Password ";
}
else
{
loginResponse.fullName = objUser.first_name + " " + objUser.last_name;
loginResponse.isValidUser = true;
loginResponse.userName = objUser.user_name;
loginResponse.errorMessage = "";
}
return(loginResponse);
}
public static List <BookStoreAdmin.ViewModels.Book> GetBookDetails()
{
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
List <BookStoreAdmin.ViewModels.Book> books = context.books.Select(book => new BookStoreAdmin.ViewModels.Book()
{
id = book.id,
title = book.title,
description = book.description,
category = new ViewModels.Category()
{
id = book.category.id, description = book.category.description, name = book.category.name
},
authors = book.authors.Select((author) => new BookStoreAdmin.ViewModels.Author()
{
id = author.id,
description = author.description,
first_name = author.first_name,
last_name = author.last_name
}).ToList(),
price = book.price
}).ToList();
return(books);
}
}
public static BookStoreAdmin.ViewModels.Book AddBook(BookStoreAdmin.ViewModels.BookRequest objBookRequest)
{
BookStoreAdmin.Models.book book = new book();
BookStoreAdmin.ViewModels.Book objBook = new ViewModels.Book();
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
book.title = objBookRequest.title;
book.description = objBookRequest.description;
book.fk_category_id = objBookRequest.category;
book.price = objBookRequest.price;
foreach (int authorId in objBookRequest.authors)
{
book.authors.Add(new Models.author()
{
id = authorId
});
}
book.created_on = new DateTimeOffset();
context.books.Add(book);
foreach (BookStoreAdmin.Models.author author in book.authors)
{
context.Entry(author).State = System.Data.Entity.EntityState.Unchanged;
}
context.SaveChanges();
}
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
objBook = context.books
.Where(b => b.id == book.id)
.Select(book1 => new BookStoreAdmin.ViewModels.Book()
{
id = book1.id,
title = book1.title,
description = book1.description,
category = new ViewModels.Category()
{
id = book1.category.id, description = book1.category.description, name = book1.category.name
},
authors = book1.authors.Select((author) => new BookStoreAdmin.ViewModels.Author()
{
id = author.id,
description = author.description,
first_name = author.first_name,
last_name = author.last_name
}).ToList(),
price = book1.price
}).Single();
}
return(objBook);
}
public static List <BookStoreAdmin.ViewModels.Author> GetAuthors()
{
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
return(context.authors.Select(author => new BookStoreAdmin.ViewModels.Author()
{
id = author.id, first_name = author.first_name, last_name = author.last_name, description = author.description
}).ToList());
}
}
public static List <BookStoreAdmin.ViewModels.Category> GetCategories()
{
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
return(context.categories.Select(category => new BookStoreAdmin.ViewModels.Category()
{
id = category.id, description = category.description, name = category.name
}).ToList());
}
}
public static BookStoreAdmin.ViewModels.Category EditCategory(BookStoreAdmin.ViewModels.Category category)
{
BookStoreAdmin.Models.category objCategory = new Models.category();
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
objCategory = context.categories.Find(category.id);
objCategory.name = category.name;
objCategory.description = category.description;
context.SaveChanges();
}
return(category);
}
public static void AddUser(BookStoreAdmin.ViewModels.UserRequest user)
{
BookStoreAdmin.Models.user objUser = new Models.user();
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
objUser.first_name = user.first_name;
objUser.last_name = user.last_name;
objUser.user_name = user.user_name;
objUser.password = user.password;
context.users.Add(objUser);
context.SaveChanges();
}
}
public static BookStoreAdmin.ViewModels.Author EditAuthor(BookStoreAdmin.ViewModels.Author author)
{
BookStoreAdmin.Models.author objAuthor = new Models.author();
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
objAuthor = context.authors.Find(author.id);
objAuthor.first_name = author.first_name;
objAuthor.last_name = author.last_name;
objAuthor.description = author.description;
context.SaveChanges();
}
return(author);
}
public static List <BookStoreAdmin.ViewModels.UserResponse> GetUsers()
{
List <BookStoreAdmin.ViewModels.UserResponse> users;
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
users = context.users.Select(user => new BookStoreAdmin.ViewModels.UserResponse()
{
id = user.id,
user_name = user.user_name,
first_name = user.first_name,
last_name = user.last_name,
password = ""
}).ToList();
}
return(users);
}
public static BookStoreAdmin.ViewModels.Book EditBook(BookStoreAdmin.ViewModels.BookRequest objBookRequest)
{
BookStoreAdmin.Models.book book = new Models.book();
List <int> intAuthorids = new List <int>();
BookStoreAdmin.ViewModels.Book objBook = new ViewModels.Book();
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
book = context.books.Include("authors").Single(b => b.id == objBookRequest.id);
foreach (var author in book.authors.ToList())
{
if (!objBookRequest.authors.Contains(author.id))
{
book.authors.Remove(author);
}
}
foreach (var newAuthorId in objBookRequest.authors)
{
// Add the roles which are not in the list of user's roles
if (!book.authors.Any(r => r.id == newAuthorId))
{
var newAuthor = new author {
id = newAuthorId
};
context.authors.Attach(newAuthor);
book.authors.Add(newAuthor);
}
}
book.title = objBookRequest.title;
book.description = objBookRequest.description;
book.price = objBookRequest.price;
book.fk_category_id = objBookRequest.category;
context.SaveChanges();
}
using (BookStoreAdmin.Models.BookStoreAdminEntities1 context = new BookStoreAdminEntities1())
{
objBook = context.books
.Where(b => b.id == book.id)
.Select(book1 => new BookStoreAdmin.ViewModels.Book()
{
id = book1.id,
title = book1.title,
description = book1.description,
category = new ViewModels.Category()
{
id = book1.category.id, description = book1.category.description, name = book1.category.name
},
authors = book1.authors.Select((author) => new BookStoreAdmin.ViewModels.Author()
{
id = author.id,
description = author.description,
first_name = author.first_name,
last_name = author.last_name
}).ToList(),
price = book1.price
}).Single();
}
return(objBook);
}
