protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Author a = new Author();
a.Name = txtName.Text;
a.Surname = txtSurname.Text;
a.CreatedDate = DateTime.Now;
a.Description = txtDescription.Text;
using (var db = new BookEntities())
{
if (Request.QueryString["Id"] != null)
{
a.Id = Convert.ToInt32(Request.QueryString["Id"]);
db.Entry(a).State = EntityState.Modified;
}
else
{
db.Entry(a).State = EntityState.Added;
}
db.SaveChanges();
}
Response.Redirect("AuthorDetail.aspx");
}catch (Exception)
{
throw;
}
}
//BOOK SAVE UPDATE START
private void InsertNewBook_Click(object sender, EventArgs e)
{
book.BookName = textBoxBookName.Text.Trim();
book.BookAuthor = textBoxAuthor.Text.Trim();
book.BookPublicationName = textBoxPublication.Text.Trim();
book.BookReleaseDate = dateTimePickerBook.Value;
book.BookQuantity = textBoxQuantity.Text.Trim();
book.BookPrice = textBoxPrice.Text.Trim();
using (BookEntities db = new BookEntities())
{
////Checks wether if fields empty or not
if (textBoxBookName.Text == "" || textBoxAuthor.Text == "" || textBoxPublication.Text == "" || textBoxQuantity.Text == "" || textBoxPrice.Text == "")
{
MessageBox.Show("Please fill in all the fields");
}
else
{
if (book.BookID == 0)
{
db.Bookİnfoes.Add(book); //Insert
}
else
{
db.Entry(book).State = EntityState.Modified;
}
db.SaveChanges(); //update
MessageBox.Show("Submit Successfull");
}
}
ClearBook();
FillBookDataGridView();
}
//============================DataGridview=Fill=Start=================================
//Fills DataGridView for Book with Corresponding Values from Database
void FillBookDataGridView()
{
using (BookEntities db = new BookEntities())
{
DGVBooks.DataSource = db.Bookİnfoes.ToList <BookInfo>();
}
}
//Fills DataGridView for Person with Corresponding Values from Database
void FillPersonDataGridView()
{
using (BookEntities db = new BookEntities())
{
DGVPerson.DataSource = db.People.ToList <Person>();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Publisher p = new Publisher();
p.Name = txtName.Text;
p.Address = txtAddress.Text;
p.CreatedDate = DateTime.Now;
p.PhoneNumber = txtPhoneNumber.Text;
using (var db = new BookEntities())
{
if (Request.QueryString["Id"] != null)
{
p.Id = Convert.ToInt32(Request.QueryString["Id"]);
db.Entry(p).State = EntityState.Modified;
}
else db.Entry(p).State = EntityState.Added;
db.SaveChanges();
}
Response.Redirect("PublisherDetail.aspx");
}
catch (Exception)
{
throw;
}
}
private void InsertNewBook_Click(object sender, EventArgs e)
{
book.BookName = textBoxBookName.Text.Trim();
book.BookAuthor = textBoxAuthor.Text.Trim();
book.BookPublicationName = textBoxPublication.Text.Trim();
book.BookPurchaseDate = dateTimePickerBook.Value;
book.BookQuantity = textBoxQuantity.Text.Trim();
book.BookPrice = textBoxPrice.Text.Trim();
using (BookEntities db = new BookEntities())
{
if (book.BookID == 0)
{
db.Bookİnfos.Add(book); //Insert
}
else
{
db.Entry(book).State = EntityState.Modified;
}
db.SaveChanges(); //update
}
Clear();
PopulateDataGridView();
MessageBox.Show("Submit Successfull");
}
//=============================CLİCK-END==============================
//========================SAVE-UPDATE-BUTTON-START===========================
private void SaveOrderS_Click_1(object sender, EventArgs e)
{
//Make Fields Empty
order.PersonOrderName = LabelpersonNameS.Text.Trim();
order.BookOrderName = LabelBookNames.Text.Trim();
order.IssueDate = DateTimePickerIssueDate.Value;
order.Deadline = DateTimePickerDeadline.Value;
//Make Fields Empty
using (BookEntities db = new BookEntities())
{
//Checks wether if fields empty or not
if (LabelpersonNameS.Text == "Name" ||
LabelBookNames.Text == "Name")
{
MessageBox.Show("Please fill fields from List");
}
//Checks wether if fields empty or not
else
//if fieldboxes are not empty it allows operation
{
if (order.OrderID == 0)
{
db.OrderBooks.Add(order); //Insert Operation
}
else
{
db.Entry(order).State = EntityState.Modified;
}
db.SaveChanges(); //update Operation
MessageBox.Show("Submit Successfull");
}
}
FillOrderListDGV();
ClearOrderList();
}
static void Main(string[] args)
{
using (var db = new BookEntities())
{
var newBook = new Book()
{
Id = Guid.NewGuid(),
Name = $"Test - {DateTime.Now.Ticks}",
};
db.Books.Add(newBook);
Guid id = Guid.Parse("9F754B7A-C8E7-4EFF-9134-FF8B0FB8E2F3");
var book = db.Books.Where(x => x.Id == id).FirstOrDefault();
book.Name = "Nazir's book";
db.SaveChanges();
Console.WriteLine("Dnone");
Console.ReadKey();
}
}
//Fills DataGridView for Person with Corresponding Values from Database
void FillPersonDataGridView()
{
using (BookEntities db = new BookEntities())
{
DGVPerson.AutoGenerateColumns = false;
DGVPerson.DataSource = db.People.ToList <Person>();
}
}
//============================DataGridview=Fill=Start=================================
//Fills DataGridView for Book with Corresponding Values from Database
void FillBookDataGridView()
{
using (BookEntities db = new BookEntities())
{
DGVBooks.AutoGenerateColumns = false;
DGVBooks.DataSource = db.Bookİnfoes.ToList <BookInfo>();
}
}
void FillOrderListDGV()
{
using (BookEntities db = new BookEntities())
{
DGVOrderList.DataSource = db.OrderBooks.ToList <OrderBook>();
DGVReport.DataSource = db.OrderBooks.ToList <OrderBook>();
}
}
void PopulateDataGridView()
{
using (BookEntities db = new BookEntities())
{
DGVBooks.DataSource = db.Bookİnfos.ToList <BookInfo>();
}
}
public ActionResult StackWenXue()
{
BookEntities bookEntities = new BookEntities();
var list = from BookDetails in bookEntities.BookDetails select BookDetails;
ViewData.Model = list;
return(View("Stack - WenXue"));
}
protected void Page_Load(object sender, EventArgs e)
{
BookEntities db = new BookEntities();
var results = (from i in db.BookLists
select i).ToList();
booksList.DataSource = results;
booksList.DataBind();
}
// GET: Book
public ActionResult Index()
{
List <Book> m;
using (var r = new BookEntities())
{
m = r.Book.ToList();
}
return(View(m));
}
void FillOrderPersonBookDGV()
{
using (BookEntities db = new BookEntities())
{
DGVFindOrderS.AutoGenerateColumns = false;
DGVFindBook.AutoGenerateColumns = false;
DGVFindOrderS.DataSource = db.People.ToList <Person>();
DGVFindBook.DataSource = db.Bookİnfoes.ToList <BookInfo>();
}
}
public IEnumerable <Book> GetBooks(BookQueryViewModel bookQueryViewModel)
{
using (var dbcontext = new BookEntities())
{
var books = dbcontext.Books
.Where(x => x.Name == bookQueryViewModel.Name)
.ToList();
return(books);
}
}
public void Add(BookViewMoel model)
{
using (var dbcontext = new BookEntities())
{
var book = new Book {
ISBN = model.ISBN, Name = model.Name
};
dbcontext.Books.Add(book);
dbcontext.SaveChanges();
}
}
private void GetPublisher()
{
int publisher = Convert.ToInt32(Request.QueryString["Id"]);
using (var db = new BookEntities())
{
var mypublisher = (from p in db.Publisher where p.Id == publisher select p).FirstOrDefault();
txtName.Text = mypublisher.Name;
txtAddress.Text = mypublisher.Address;
txtPhoneNumber.Text = mypublisher.PhoneNumber;
}
}
public ActionResult Delete_Get(int Id)
{
var bookmodel = new Book();
TryUpdateModel(bookmodel);
using (var r = new BookEntities())
{
bookmodel = r.Book.FirstOrDefault(x => x.Id == Id);
}
return(View(bookmodel));
}
private void GetAuthor()
{
int author = Convert.ToInt32(Request.QueryString["Id"]);
using (var db = new BookEntities())
{
var myauthor = (from a in db.Author where a.Id == author select a).FirstOrDefault();
txtName.Text = myauthor.Name;
txtSurname.Text = myauthor.Name;
txtDescription.Text = myauthor.Description;
}
}
static void Main(string[] args)
{
using (var db = new BookEntities())
{
var book = new Book()
{
BookName = "Dangerous Murder",
Theme = "Horror",
Price = 399,
};
db.Book
}
}
private void GetPublisherList()
{
using (var db = new BookEntities())
{
var publisherList = from p in db.Publisher
select new PublisherDetailList {
Id = p.Id, Name = p.Name
};
grv.DataSource = publisherList.ToList();
grv.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string fileName = string.Empty;
if (flUpload.HasFile)
{
flUpload.SaveAs(Server.MapPath("~/BookCover/") + flUpload.FileName);
fileName = flUpload.FileName;
}
using (var db = new BookEntities())
{
Book b = new Book();
b.Title = txtTitle.Text;
b.Isbn = txtIsbn.Text;
b.PublisId = Convert.ToInt32(ddlPublisher.SelectedValue);
b.PublishedDate = clDate.SelectedDate;
b.NumberOfPages = Convert.ToInt32(txtNumberOfPages.Text);
b.Edition = txtEdition.Text;
b.FormatId = Convert.ToInt32(ddlFormat.SelectedValue);
b.Description = txtDescription.Text;
b.ContentId = Convert.ToInt32(ddlContent.SelectedValue);
b.AuthorId_ = Convert.ToInt32(ddlAuthor.SelectedValue);
if (!String.IsNullOrEmpty(fileName))
{
b.BookCoverPath = "~/BookCover/" + fileName;
}
if (Request.QueryString["Id"] != null)
{
b.Id = Convert.ToInt64(Request.QueryString["Id"]);
db.Entry(b).State = EntityState.Modified;
}
else
{
db.Entry(b).State = EntityState.Added;
}
db.SaveChanges();
}
Response.Redirect("BookDetail.aspx");
}
catch (Exception)
{
throw;
}
}
private void GetAuthorList()
{
using (var db = new BookEntities())
{
var authorList = from a in db.Author
select new AuthorDetailList {
Id = a.Id, Name = a.Name + " " + a.Surname
};
grv.DataSource = authorList.ToList();
grv.DataBind();
}
}
private void GetBookList()
{
using (var db = new BookEntities())
{
var bookList = from b in db.Book
join a in db.Author on b.AuthorId_ equals a.Id
select new BookDetailList {
Id = b.Id, AuthorName = a.Name + " " + a.Surname, Title = b.Title
};
grv.DataSource = bookList.ToList();
grv.DataBind();
}
}
public ActionResult Create_Post()
{
var bookmodel = new Book();
TryUpdateModel(bookmodel);
using (var r = new BookEntities())
{
r.Book.Add(bookmodel);
r.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit_Post(int Id)
{
var bookmodel = new Book();
TryUpdateModel(bookmodel);
using (var r = new BookEntities())
{
var m = r.Book.Where(x => x.Id == Id).FirstOrDefault();
TryUpdateModel(m);
r.SaveChanges();
}
return(RedirectToAction("Index"));
}
//==============================CLEAR=TEXTBOX=START==========================
//=============================CLİCK-START============================
//Double Clicking Fills Empty Textboxes therefore makes Updating possible
//BOOK DOUBLE-CLICK START
private void DGVFindBook_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (DGVFindBook.CurrentRow.Index != -1)
{
book.BookID = Convert.ToInt32(DGVFindBook.CurrentRow.Cells["dataGridViewTextBoxColumn10"].Value);
using (BookEntities db = new BookEntities())
{
book = db.Bookİnfoes.Where(x => x.BookID == book.BookID).FirstOrDefault();
LabelBookNames.Text = book.BookName;
}
BTNSave.Text = ("Update");
//Delete Button becomes available once you double click to Rows/Cells
BTNBookDelete.Enabled = true;
}
}
//BOOK DOUBLE-CLICK END
private void DGVOrderList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (DGVOrderList.CurrentRow.Index != -1)
{
order.OrderID = Convert.ToInt32(DGVOrderList.CurrentRow.Cells["OrderID"].Value);
using (BookEntities db = new BookEntities())
{
order = db.OrderBooks.Where(x => x.OrderID == order.OrderID).FirstOrDefault();
LabelBookNames.Text = order.BookOrderName;
LabelpersonNameS.Text = order.PersonOrderName;
}
SaveOrderS.Text = ("Update");
//Delete Button becomes available once you double click to Rows/Cells
DeleteOrderS.Enabled = true;
}
}
