Exemplo n.º 1
0
 protected void btnSubmit_Click(object sender, EventArgs e)
 {
     try
     {
         int id = 0;
         using (deeptiEntities db = new deeptiEntities())
         {
             if (Session["id"] != null)
             {
                 id = Convert.ToInt32(Session["id"].ToString());
             }
             var query = (from r in db.Registrations where r.Id == id select r.Password).FirstOrDefault();
             if (query != null)
             {
                 if (txtOldPwd.Text == query)
                 {
                     var q = (from u in db.Registrations where u.Id == id select u).SingleOrDefault();
                     if (q != null)
                     {
                         q.Password = txtNewPwd.Text;
                         db.SaveChanges();
                         lblMessage.Text = "Password changed successfully! ";
                     }
                 }
             }
         }
     }
     catch (Exception ex)
     {
         lblMessage.Text = ex.Message;
     }
 }
Exemplo n.º 2
0
        protected void gvBooks_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            try
            {
                if (e.CommandName == "Delete")
                {
                    using (deeptiEntities db1 = new deeptiEntities())
                    {
                        //int ncopies = 0;
                        int id = Convert.ToInt32(e.CommandArgument);
                        //var no = (from k in db1.Books where k.Id == id select k.Copies).SingleOrDefault();
                        //ncopies = Convert.ToInt32(no);
                        var copy = from c in db1.Copies where c.BookId == id select c;
                        // List<Copy> cp = copy.ToList();
                        foreach (var cp in copy)
                        {
                            db1.Copies.Remove(cp);
                        }

                        var book = (from b in db1.Books where b.Id == id select b).SingleOrDefault();
                        db1.Books.Remove(book);


                        db1.SaveChanges();
                        BindGrid();
                        lblMessage.Text = "Record deleted !";
                    }
                }
            }
            catch (Exception ex)
            {
                lblMessage.Text = ex.Message;
            }
        }
Exemplo n.º 3
0
        protected void txtSubmit_Click(object sender, EventArgs e)
        {
            try
            {
                using (deeptiEntities db = new deeptiEntities())
                {
                    int memberId = 0;
                    int bookId   = Convert.ToInt32(txtBookId.Text);
                    if (Session["id"] != null)
                    {
                        memberId = Convert.ToInt32(Session["id"].ToString());
                    }

                    var query = (from q in db.Transactions where q.BookId == bookId && q.MemberId == memberId select q).FirstOrDefault();
                    if (query != null)
                    {
                        query.ReturnDate = (Convert.ToDateTime(txtReturnDate.Text)).Date;
                        var iDate = (from i in db.Transactions where i.BookId == bookId && i.MemberId == memberId select i.IssueDate).First();
                        if (iDate != null)
                        {
                            txtIssuedDate.Text = iDate.Date.ToString("yyyy-MM-dd");
                        }
                        var DDate = (from d in db.Transactions where d.BookId == bookId && d.MemberId == memberId select d.DueDate).First();
                        if (DDate != null)
                        {
                            txtDueDate.Text = DDate.Date.ToString("yyyy-MM-dd");
                        }
                        int days = (Convert.ToDateTime(txtDueDate.Text) - Convert.ToDateTime(txtReturnDate.Text)).Days;
                        if (days < 0)
                        {
                            query.Fine   = days / 2;
                            txtFine.Text = (days / 2).ToString();
                        }
                        else if (days == 0 || days > 0)
                        {
                            query.Fine   = 0;
                            txtFine.Text = "0";
                        }
                        var copy = (from c in db.Transactions where c.BookId == bookId && c.MemberId == memberId select c.CopyId).First();
                        if (copy != 0)
                        {
                            var cp = (from k in db.Copies where k.Id == copy select k).SingleOrDefault();

                            if (cp != null)
                            {
                                cp.Status = "available";
                            }
                        }
                        db.SaveChanges();

                        lblMessage.Text = "Book returned successfully . Please check your  details!";
                    }
                }
            }
            catch (Exception ex)
            {
                lblMessage.Text = ex.Message;
            }
        }
Exemplo n.º 4
0
        protected void gvBooks_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            try
            {
                int         copy     = 0;
                GridViewRow row      = gvBooks.Rows[e.RowIndex];
                int         id       = Convert.ToInt32(gvBooks.DataKeys[e.RowIndex].Values[0]);
                string      bTitle   = (row.FindControl("txtBookTitle") as TextBox).Text;
                string      category = (row.FindControl("txtCategory") as TextBox).Text;
                string      authName = (row.FindControl("txtAuthName") as TextBox).Text;
                string      copies   = (row.FindControl("txtCopies") as TextBox).Text;
                copy = Convert.ToInt32(copies);

                using (deeptiEntities db = new deeptiEntities())
                {
                    Book bk = (from b in db.Books
                               where b.Id == id
                               select b).SingleOrDefault();
                    bk.BookTitle  = bTitle;
                    bk.Category   = category;
                    bk.AuthorName = authName;
                    bk.Copies     = copy;
                    db.SaveChanges();
                }
                gvBooks.EditIndex = -1;
                this.BindGrid();



                //Label BId = (Label)gvBooks.Rows[e.RowIndex].FindControl("lblId");
                // id = Convert.ToInt32(BId);
                //TextBox BTitle = (TextBox)gvBooks.Rows[e.RowIndex].FindControl("txtBookTitle");
                //TextBox Category = (TextBox)gvBooks.Rows[e.RowIndex].FindControl("txtCategory");
                //TextBox AuthName = (TextBox)gvBooks.Rows[e.RowIndex].FindControl("txtAuthName");
                //TextBox Copies = (TextBox)gvBooks.Rows[e.RowIndex].FindControl("txtCopies");
                //copy = Convert.ToInt32(Copies.Text);
                //using (deeptiEntities db = new deeptiEntities())
                //{
                //    var bookQuery = (from b in db.Books where b.Id == id select b).SingleOrDefault();
                //    if(bookQuery!=null)
                //    {
                //        bookQuery.BookTitle = BTitle.Text;
                //        bookQuery.Category = Category.Text;
                //        bookQuery.AuthorName = AuthName.Text;
                //        bookQuery.Copies = copy ;
                //        db.SaveChanges();
                //        gvBooks.EditIndex = -1;
                //        BindGrid();
                //        lblMessage.Text = "Record updated!";
                //    }
                //}
            }
            catch (Exception ex)
            {
                lblMessage.Text = ex.Message;
            }
        }
Exemplo n.º 5
0
        protected void txtSubmit_Click(object sender, EventArgs e)
        {
            // using command temporarily creates a context that accesses our database
            using (deeptiEntities db = new deeptiEntities())
            {
                Book objBook = new Book
                {
                    AuthorName = txtAuthorName.Text,
                    BookTitle  = txtBookTitle.Text,
                    Category   = txtCategory.Text,
                    Copies     = Convert.ToInt32(txtCopies.Text)
                };

                db.Books.Add(objBook);
                db.SaveChanges();
                var query = from b in db.Books where b.BookTitle == txtBookTitle.Text & b.AuthorName == txtAuthorName.Text select b.Id;
                var c     = query.SingleOrDefault();
                if (c != 0)
                {
                    for (int i = 0; i < Convert.ToInt32(txtCopies.Text); i++)
                    {
                        Copy objCopy = new Copy
                        {
                            BookId = c,
                            Status = "available"
                        };
                        db.Copies.Add(objCopy);
                    }
                }


                db.SaveChanges();

                lblMessage.Text = " Book added successfully !";
            }
        }
Exemplo n.º 6
0
 protected void gvUsers_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     try
     {
         if (e.CommandName == "Delete")
         {
             using (deeptiEntities db1 = new deeptiEntities())
             {
                 int id   = Convert.ToInt32(e.CommandArgument);
                 var user = (from u in db1.Registrations where u.Id == id select u).FirstOrDefault();
                 db1.Registrations.Remove(user);
                 db1.SaveChanges();
                 BindGrid();
             }
         }
     }
     catch (Exception ex)
     {
         lblMessage.Text = ex.Message;
     }
 }
Exemplo n.º 7
0
        protected void txtSubmit_Click(object sender, EventArgs e)
        {
            try
            {
                using (deeptiEntities db = new deeptiEntities())
                {
                    int bookId = Convert.ToInt32(txtBookId.Text);

                    var copy = from p in db.Copies where p.BookId == bookId select p;
                    var cid  = from c in db.Copies where c.BookId == bookId select c.Id;
                    var s    = copy.FirstOrDefault();
                    if (s != null)
                    {
                        s.Status = "Unavailable";
                    }

                    var trans = new Transaction();

                    trans.BookId = bookId;
                    if (Session["id"] != null)
                    {
                        trans.MemberId = Convert.ToInt32(Session["id"].ToString());
                    }
                    trans.CopyId    = Convert.ToInt32(cid.First());
                    trans.IssueDate = Convert.ToDateTime(DateTime.Now.Date);
                    DateTime due = trans.IssueDate.AddDays(21);
                    trans.DueDate = due;
                    // adding the transactoin to db collection
                    db.Transactions.Add(trans);
                    // telling the db to save the changes
                    db.SaveChanges();
                    lblMessage.Text = "Book has been issued  and due date is " + due.ToString("d");
                }
            }
            catch (Exception ex)
            {
                lblMessage.Text = ex.Message;
            }
        }
Exemplo n.º 8
0
        protected void btnRegister_Click(object sender, EventArgs e)
        {
            try
            {
                // using command temporarily creates a context that accesses our database
                // creating an object of the object context "deeptiEntities"
                using (deeptiEntities db = new deeptiEntities())
                {
                    //creating an object of the Registration class

                    Registration objreg = new Registration();

                    // set values to the db columns

                    objreg.FirstName      = txtFirstName.Text;
                    objreg.LastName       = txtLastName.Text;
                    objreg.UserName       = txtUserName.Text;
                    objreg.Password       = txtPassword.Text;
                    objreg.MobileNo       = txtMobileNo.Text;
                    objreg.RegisteredDate = DateTime.Now;
                    objreg.Email          = txtEmail.Text;
                    objreg.Role           = ddlRole.SelectedItem.Text;

                    // add registration object to the registrations collection in the object context

                    db.Registrations.Add(objreg);

                    //call savechanges method to insert the record into table

                    db.SaveChanges();
                    lblMessage.Text = " You have registered successfully!";
                }
            }
            catch (Exception ex)
            {
                lblMessage.Text = ex.Message;
            }
        }