public static int addBorrow(int bookId, int userId)
{
LibararyModel lm = new LibararyModel();
var check = lm.userBook.Where(x => x.userId == userId && x.bookId == bookId &&
x.isDelivered == false && x.status == BookStatus.isborrowking
).Count();
if (check == 0)
{
var book = lm.books.FirstOrDefault(x => x.id == bookId);
book.availableCopies--;
var z = lm.userBook.Add(new userBook
{
employeeId = 2,//session
bookId = bookId,
userId = userId,
startDate = DateTime.Now,
status = BookStatus.isborrowking,
isDelivered = false,
deliveredDate = DateTime.Now.AddDays(7),
});
lm.SaveChanges();
return(z.id);
}
return(-1);
}
public static int addMembers(UserInput user)
{
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var newuser = new user();
newuser.firstLogin = true;
newuser.isDeleted = false;
newuser.JoinDate = DateTime.Now;
//newuser.member=new member();
//newuser.member.isBlock = false;
newuser.email = user.email;
newuser.fName = user.fName;
newuser.lName = user.lName;
newuser.userName = user.userName;
newuser.password = user.userName;
newuser.birthDate = user.birthDate;
newuser.image = Convert.FromBase64String(user.profile);
newuser = lm.users.Add(newuser);
lm.SaveChanges();
newuser.member = new member();
newuser.member.isBlock = false;
lm.SaveChanges();
return(newuser.id);
}
//[ScriptMethod(UseHttpGet = true)]
public static int checkemail(string email)
{
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var count = lm.members.Where(x => x.user.email == email).Count();
return(count);
}
//[ScriptMethod(UseHttpGet = true)]
public static int checkUserName(string userName)
{
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var count = lm.members.Where(x => x.user.userName == userName).Count();
return(count);
}
public static List <string> GetResult(string pre)
{
List <string> res = new List <string>();
using (LibararyModel lb = new LibararyModel())
{
//res = string.Join(lb.users.Where(emp => emp.fName.Contains(pre) && emp.role == Role.Employee).Select(emp => new { Fullname = emp.fName + " " + emp.lName }).ToList());
res = (from a in lb.users where (a.fName.Contains(pre) || a.lName.Contains(pre)) && a.role == Role.Employee select a.fName + " " + a.lName).ToList();
}
return(res);
}
public static string deleteMembers(string userName)
{
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var user = lm.users.Where(x => x.userName == userName).FirstOrDefault();
user.isDeleted = true;
lm.SaveChanges();
return(user.isDeleted.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var ssers = lm.users.Where(x => !x.isDeleted && !x.member.isBlock).ToList();
ddl_users.DataSource = ddl_users2.DataSource = ssers;
ddl_users.DataTextField = ddl_users2.DataTextField = "userName";
ddl_users.DataValueField = ddl_users2.DataValueField = "id";
ddl_users.DataBind(); ddl_users2.DataBind();
}
}
protected void rbtnl_returnType_SelectedIndexChanged(object sender, EventArgs e)
{
var returnStatus = (BookStatus)Convert.ToInt32(rbtnl_returnType.SelectedValue);
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var todayDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
if (returnStatus == BookStatus.isReading)
{
var books = lm.userBook.Where(x => x.status == returnStatus && x.startDate == todayDate &&
x.startDate == todayDate &&
x.isDelivered == false)
.Select(x => new userBookDto {
book = x.book, bookId = x.bookId
}).ToList();
books = books.Distinct().ToList();
ddl_Returnbooks.DataSource = books;
ddl_Returnbooks.DataTextField = "bookTitle";
ddl_Returnbooks.DataValueField = "bookId";
ddl_Returnbooks.DataBind();
if (books.Count() > 0)
{
ddl_Returnbooks_SelectedIndexChanged(null, null);
}
}
else
{
var books = lm.userBook.Where(x => x.status == returnStatus &&
x.isDelivered == false)
.Select(x => new userBookDto {
book = x.book, bookId = x.bookId
}).ToList();
books = books.Distinct().ToList();
ddl_Returnbooks.DataSource = books;
ddl_Returnbooks.DataTextField = "bookTitle";
ddl_Returnbooks.DataValueField = "bookId";
ddl_Returnbooks.DataBind();
if (books.Count() > 0)
{
ddl_Returnbooks_SelectedIndexChanged(null, null);
}
}
}
public static List <UserSearchDto> GetMyResult()
{
var lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
List <UserSearchDto> z = lm.users.Where(x => x.isDeleted == false && x.role == Role.Employee)
.Select(x => new UserSearchDto
{
lName = x.fName + " " + x.lName,
userName = x.userName
}).ToList();
return(z.ToList());
}
public static List <userBookDto> getlatedBooks()
{
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var books = lm.userBook.Where(x => x.status == BookStatus.isborrowking &&
x.isDelivered == false &&
x.deliveredDate < DateTime.Now
)
.Select(x => new userBookDto {
book = x.book, bookId = x.bookId, userId = x.userId, user = x.user
}).ToList();
return(books);
}
public static List <userBookDto> getstoledBooks()
{
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var todayDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
var books = lm.userBook.Where(x => x.status == BookStatus.isReading && x.startDate != todayDate &&
x.isDelivered == false)
.Select(x => new userBookDto {
book = x.book, bookId = x.bookId, userId = x.userId, user = x.user
}).ToList();
return(books);
}
public static string UpdateData(string fname)//, string lname, string email, string add, string id)
{
using (LibararyModel db = new LibararyModel())
{
int eid = 0; //int.Parse(id); // will come from login session
var q1 = db.users.Single(emp => emp.id == eid);
q1.fName = fname;
//q1.lName = lname;
//q1.email = email;
//q1.address = add;
db.SaveChanges();
}
return("submit");
}
public static string blockMembers(string userName)
{
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var member = lm.members.Where(x => x.user.userName == userName).FirstOrDefault();
if (member.isBlock)
{
member.isBlock = false;
member.endDate = null;
}
else
{
member.isBlock = true;
member.endDate = DateTime.Now.AddDays(7);
}
lm.SaveChanges();
return(member.isBlock.ToString());
}
protected void ddl_Returnbooks_SelectedIndexChanged(object sender, EventArgs e)
{
var returnStatus = (BookStatus)Convert.ToInt32(rbtnl_returnType.SelectedValue);
var bookId = Convert.ToInt32(ddl_Returnbooks.SelectedValue);
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var todayDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
if (returnStatus == BookStatus.isReading)
{
var users = lm.userBook.Where(x => x.status == returnStatus && x.startDate == todayDate &&
x.startDate == todayDate &&
x.isDelivered == false &&
x.bookId == bookId)
.Select(x => new userBookDto {
user = x.user, userId = x.userId
}).ToList();
ddl_ReturnUsers.DataSource = users;
ddl_ReturnUsers.DataTextField = "userName";
ddl_ReturnUsers.DataValueField = "userId";
ddl_ReturnUsers.DataBind();
}
else
{
var users = lm.userBook.Where(x => x.status == returnStatus &&
x.isDelivered == false &&
x.bookId == bookId)
.Select(x => new userBookDto {
user = x.user, userId = x.userId
}).ToList();
ddl_ReturnUsers.DataSource = users;
ddl_ReturnUsers.DataTextField = "userName";
ddl_ReturnUsers.DataValueField = "userId";
ddl_ReturnUsers.DataBind();
}
}
public static List <booksDto> getbooks()
{
//using Newtonsoft.Json
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var z = lm.books.Where(x => x.isDeleted == false).Select(x =>
new booksDto
{
author = x.author,
availableCopies = x.availableCopies,
categoryName = x.categoryName,
title = x.title,
id = x.id,
publishDate = x.publishDate,
publisher = x.publisher
})
.ToList();
return(z.ToList());
}
public static List <UserDto> getMembers()
{
//using Newtonsoft.Json
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
List <UserDto> z = lm.users.Where(x => x.isDeleted == false && x.role == null).Select(x => new UserDto
{
address = x.address,
birthDate = x.birthDate,
email = x.email,
lName = x.lName,
fName = x.fName,
member = x.member,
image = x.image,
phone = x.phone,
userName = x.userName
}).ToList();
// var list = JsonConvert.SerializeObject(z, Newtonsoft.Json.Formatting.None, new JsonSerializerSettings() { ReferenceLoopHandling = ReferenceLoopHandling.Ignore });
return(z.ToList());
}
protected void btn_return_Click(object sender, EventArgs e)
{
var returnStatus = (BookStatus)Convert.ToInt32(rbtnl_returnType.SelectedValue);
var bookId = 0;
var userId = 0;
if (ddl_Returnbooks.SelectedValue != "" && ddl_ReturnUsers.SelectedValue != "")
{
bookId = Convert.ToInt32(ddl_Returnbooks.SelectedValue);
userId = Convert.ToInt32(ddl_ReturnUsers.SelectedValue);
}
else
{
return;
}
LibararyModel lm = new LibararyModel();
lm.Configuration.ProxyCreationEnabled = false;
var todayDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
if (bookId > 0 & userId > 0)
{
if (returnStatus == BookStatus.isReading)
{
var book = lm.userBook.Where(x => x.status == returnStatus && x.startDate == todayDate &&
x.startDate == todayDate &&
x.isDelivered == false &&
x.bookId == bookId && x.userId == userId)
.FirstOrDefault();
var returnedBook = lm.books.FirstOrDefault(x => x.id == bookId);
returnedBook.availableCopies++;
book.isDelivered = true;
book.returnDate = DateTime.Now;
lm.SaveChanges();
var books = lm.userBook.Where(x => x.status == returnStatus && x.startDate == todayDate &&
x.startDate == todayDate &&
x.isDelivered == false)
.Select(x => new userBookDto {
book = x.book, bookId = x.bookId
}).ToList();
books = books.Distinct().ToList();
ddl_Returnbooks.DataSource = books;
ddl_Returnbooks.DataTextField = "bookTitle";
ddl_Returnbooks.DataValueField = "bookId";
ddl_Returnbooks.DataBind();
ddl_Returnbooks_SelectedIndexChanged(null, null);
}
else
{
var book = lm.userBook.Where(x => x.status == returnStatus &&
x.isDelivered == false &&
x.bookId == bookId && x.userId == userId)
.FirstOrDefault();
book.isDelivered = true;
book.returnDate = DateTime.Now;
var returnedBook = lm.books.FirstOrDefault(x => x.id == bookId);
returnedBook.availableCopies++;
lm.SaveChanges();
var books = lm.userBook.Where(x => x.status == returnStatus &&
x.isDelivered == false)
.Select(x => new userBookDto {
book = x.book, bookId = x.bookId
}).ToList();
books = books.Distinct().ToList();
ddl_Returnbooks.DataSource = books;
ddl_Returnbooks.DataTextField = "bookTitle";
ddl_Returnbooks.DataValueField = "bookId";
ddl_Returnbooks.DataBind();
ddl_Returnbooks_SelectedIndexChanged(null, null);
}
}
}
