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