public void SaveChanges()
{
LibraryDBDataContext db = new LibraryDBDataContext();
var editStudent = (from B in db.tbl_Students
where B.User_ID == this.ID
select B).FirstOrDefault();
var editUser = (from U in db.tbl_Users
where U.ID == this.ID
select U).FirstOrDefault();
editUser.Username = this.Username;
editUser.Password = this.Password;
editUser.FName = this.FName;
editUser.SName = this.SName;
editUser.Birthdate = this.Birthdate;
editUser.Address = this.Address;
editUser.Email = this.Email;
editUser.PhoneNumber = this.PhoneNumber;
editUser.NationalID = this.NationalID;
editUser.RoleName = this.Rolename.ToString();
editStudent.University = this.University;
editStudent.University_ID = this.University_ID;
editStudent.GPA = this.GPA;
db.SubmitChanges();
}
public void SaveChanges()
{
LibraryDBDataContext db = new LibraryDBDataContext();
var editAdmin = (from B in db.tbl_AdminDetails
where B.UserID == this.ID
select B).FirstOrDefault();
var editUser = (from U in db.tbl_Users
where U.ID == this.ID
select U).FirstOrDefault();
editUser.Username = this.Username;
editUser.Password = this.Password;
editUser.FName = this.FName;
editUser.SName = this.SName;
editUser.Birthdate = this.Birthdate;
editUser.Address = this.Address;
editUser.Email = this.Email;
editUser.PhoneNumber = this.PhoneNumber;
editUser.NationalID = this.NationalID;
editUser.RoleName = this.Rolename.ToString();
editAdmin.Shift = this.Shift;
editAdmin.Salary = this.Salary;
editAdmin.HireDate = this.HireDate;
db.SubmitChanges();
}
private void UserInfo_Load(object sender, EventArgs e)
{
//DateTime now = DateTime.Now;
//string date =string.Format("{0}.{1}.{2}", now.Year, now.Month, now.Day);
string date = DateTime.Now.ToLongDateString();
dateLabel.Text = date;
//User user=new User();
LibraryDBDataContext cntx = new LibraryDBDataContext(Library_Managment_System.UI.Properties.Settings.Default.librarydbConnectionString);
var q = from a in cntx.Users// where user.UserId.Contains("1232")
select a;
try
{
User user = q.Where(obj => obj.UserId == this.userId && obj.Password == this.password).First(); // int.Parse(idTextBox.Text)).First();
//titleTxtBox.Text = user.Title;
userIdTxtBox.Text = user.UserId;
userNameTxtBox.Text = user.UserName;;
emailTxtBox.Text = user.Email;
passwordTxtBox.Text = user.Password;
addressTxtBox.Text = user.Address;
dobTxtBox.Text = user.DOB;
}
catch { MessageBox.Show("Wrong login info"); Close(); }
}
public void saveChanges()
{
LibraryDBDataContext db = new LibraryDBDataContext();
var editBook = (from B in db.tbl_Books
where B.ID == this.ID
select B).FirstOrDefault();
var oldEdition = (from E in db.tbl_Editions
where E.BookID == this.ID
select E).FirstOrDefault();
tbl_Edition newEdition = new tbl_Edition();
editBook.ISBN = this.ISBN;
editBook.Name = this.Name;
editBook.PublisherID = this.Publisher.ID;
editBook.AuthorID = this.Author.ID; //l stren dol 7atet feehom l touch bta3y
editBook.Genre = this.Genre;
editBook.Copies = this.Copies;
if (oldEdition != null && this.Version != null)
{
newEdition.BookID = oldEdition.BookID;
newEdition.Pages = this.Pages;
newEdition.Version = this.Version;
db.tbl_Editions.DeleteOnSubmit(oldEdition);
db.tbl_Editions.InsertOnSubmit(newEdition);
}
db.SubmitChanges();
}
public void Delete_Book()
{
LibraryDBDataContext db = new LibraryDBDataContext();
tbl_Borrow temp = (from T in db.tbl_Borrows
where T.BookID == this.ID
select T
).FirstOrDefault();
if (temp != null)
{
MessageBox.Show("Someone has this Book!");
return;
}
else
{
tbl_Book B = (from T in db.tbl_Books
where T.ID == this.ID
select T).FirstOrDefault();
tbl_Edition e = (from E in db.tbl_Editions
where E.BookID == this.ID
select E).FirstOrDefault();
if (e != null)
{
db.tbl_Editions.DeleteOnSubmit(e);
}
db.tbl_Books.DeleteOnSubmit(B);
db.SubmitChanges();
}
}
public static List <Book> LoadALLDistinct()
{
LibraryDBDataContext db = new LibraryDBDataContext();
List <Book> Books = (from B in db.tbl_Books
select new Book(B)
).ToList <Book>();
return(Books);
}
public void AddBookMySelf(BookSelf bookself)
{
//Console.WriteLine(""+user.UserId+""+user.UserName+""+user.Title);
LibraryDBDataContext cntx = new LibraryDBDataContext(Library_Managment_System.Data.Properties.Settings.Default.librarydbConnectionString);
cntx.BookSelfs.InsertOnSubmit(bookself);
cntx.SubmitChanges();
}
public object ViewBook()
{
LibraryDBDataContext cntx = new LibraryDBDataContext(Library_Managment_System.Data.Properties.Settings.Default.librarydbConnectionString);
var q = from a in cntx.BrowseBooks//here user.UserId.Contains("1232")
select a;
return(q);
}
public void ShowGridView()
{
LibraryDBDataContext cntx = new LibraryDBDataContext(Library_Managment_System.UI.Properties.Settings.Default.librarydbConnectionString);
var q = from a in cntx.BrowseBooks// where user.UserId.Contains("1232")
select a;
dgvAdminSite.DataSource = q;
}
public List <string> LoadAllEditions()
{
LibraryDBDataContext db = new LibraryDBDataContext();
List <string> editions = (from E in db.tbl_Editions
where E.BookID == this.ID
select E.Version
).ToList <string>();
return(editions);
}
public void Add()
{
LibraryDBDataContext db = new LibraryDBDataContext();
tbl_Publisher a = new tbl_Publisher();
a.Name = this.Name;
a.Address = this.Address;
db.tbl_Publishers.InsertOnSubmit(a);
db.SubmitChanges();
}
public static List <Author> LoadALL()
{
LibraryDBDataContext db = new LibraryDBDataContext();
List <Author> au = (
from a in db.tbl_Authors
select new Author(a)
).ToList <Author>();
return(au);
}
public static List <Publisher> LoadALL()
{
LibraryDBDataContext db = new LibraryDBDataContext();
List <Publisher> pb = (
from p in db.tbl_Publishers
select new Publisher(p)
).ToList <Publisher>();
return(pb);
}
public static User LoadByID(int ID)
{
LibraryDBDataContext db = new LibraryDBDataContext();
User user = (
from u in db.tbl_Users
where u.ID == ID
select new User(u)
).FirstOrDefault();
return(user);
}
public static Book LoadByISBN(int ISBN)
{
LibraryDBDataContext db = new LibraryDBDataContext();
Book book = (
from b in db.tbl_Books
where b.ISBN == ISBN
select new Book(b)
).FirstOrDefault();
return(book);
}
public static User LoadByUsername(string username)
{
LibraryDBDataContext db = new LibraryDBDataContext();
User user = (
from b in db.tbl_Users
where b.Username == username
select new User(b)
).FirstOrDefault();
return(user);
}
public static Author LoadById(int Id)
{
LibraryDBDataContext db = new LibraryDBDataContext();
Author au = (
from a in db.tbl_Authors
where a.ID == Id
select new Author(a)
).FirstOrDefault();
return(au);
}
public static User Login(string username, string password)
{
LibraryDBDataContext db = new LibraryDBDataContext();
User user = (
from b in db.tbl_Users
where b.Username == username && b.Password == password
select new User(b)
).FirstOrDefault();
return(user);
}
public static new Student LoadByID(int ID)
{
LibraryDBDataContext db = new LibraryDBDataContext();
Student user = (
from u in db.tbl_Students
where u.User_ID == ID
select new Student(u)
).FirstOrDefault();
return(user);
}
public static List <Book> LoadALL()
{
LibraryDBDataContext db = new LibraryDBDataContext();
List <Book> Books = (from B in db.tbl_Books
join E in db.tbl_Editions on B.ID equals E.BookID into joined
from E in joined.DefaultIfEmpty()
select new Book(B, E)
).ToList <Book>();
return(Books);
}
public static Publisher LoadById(int Id)
{
LibraryDBDataContext db = new LibraryDBDataContext();
Publisher pb = (
from p in db.tbl_Publishers
where p.ID == Id
select new Publisher(p)
).FirstOrDefault();
return(pb);
}
public static new Admin LoadByID(int ID)
{
LibraryDBDataContext db = new LibraryDBDataContext();
Admin a = (
from u in db.tbl_AdminDetails
where u.UserID == ID
select new Admin(u)
).FirstOrDefault();
return(a);
}
public void loadAdminDetails()
{
LibraryDBDataContext db = new LibraryDBDataContext();
tbl_AdminDetail a = (from temp in db.tbl_AdminDetails
where temp.UserID == this.ID
select temp
).FirstOrDefault();
this.Salary = a.Salary;
this.HireDate = a.HireDate.Value;
this.Shift = a.Shift;
}
public void Add()
{
LibraryDBDataContext db = new LibraryDBDataContext();
tbl_Author a = new tbl_Author();
a.Name = this.Name;
a.Address = this.Address;
a.Birthdate = this.Birthdate;
db.tbl_Authors.InsertOnSubmit(a);
db.SubmitChanges();
ID = a.ID;
}
public void ReturnBook(string bookname)
{
bookName = bookname;
LibraryDBDataContext cntx = new LibraryDBDataContext(Library_Managment_System.Data.Properties.Settings.Default.librarydbConnectionString);
var q = from a in cntx.BookSelfs
where a.BookName == bookName
select a;
BookSelf bookself = q.First();
cntx.BookSelfs.DeleteOnSubmit(bookself);
cntx.SubmitChanges();
}
public static new Student LoadByUsername(string username)
{
int id = User.LoadByUsername(username).ID;
LibraryDBDataContext db = new LibraryDBDataContext();
Student std = (
from S in db.tbl_Students
where S.User_ID == id
select new Student(S)
).FirstOrDefault();
return(std);
}
public List <Book> LoadAllBorrowedBooks()
{
LibraryDBDataContext db = new LibraryDBDataContext();
List <Book> books = (
from br in db.tbl_Borrows
join B in db.tbl_Books
on br.BookID equals B.ID
where br.UserID == this.ID
select new Book(B)
).ToList <Book>();
return(books);
}
public object ViewBookSelf(string userid)
{
string id = userid;
LibraryDBDataContext cntx = new LibraryDBDataContext(Library_Managment_System.Data.Properties.Settings.Default.librarydbConnectionString);
var q = from a in cntx.BookSelfs
where a.UserId == id
select a;
BookSelf bookself = q.First();
//BookSelf bookself = q.Where(obj => obj.UserId == id ).First();// int.Parse(idTextBox.Text)).First();
return(q);
}
public void add()
{
LibraryDBDataContext db = new LibraryDBDataContext();
tbl_Book b = new tbl_Book();
b.ISBN = this.ISBN;
b.Name = this.Name;
b.PublisherID = this.Publisher.ID;
b.AuthorID = this.Author.ID;
b.Copies = this.Copies;
b.Genre = this.Genre;
db.tbl_Books.InsertOnSubmit(b);
db.SubmitChanges();
}
public new void Add()
{
LibraryDBDataContext db = new LibraryDBDataContext();
base.Add();
tbl_AdminDetail a = new tbl_AdminDetail();
a.UserID = base.ID;
a.Salary = this.Salary;
a.HireDate = this.HireDate;
a.Shift = this.Shift;
db.tbl_AdminDetails.InsertOnSubmit(a);
db.SubmitChanges();
}
