protected void Button1_Click(object sender, EventArgs e)
{
try
{
Library_ManagementEntities6 db = new Library_ManagementEntities6();
var username = TextBox1.Text;
var password = TextBox2.Text;
var item = (from s in db.User_Details where s.UserName == username && s.PassWord == password select s).FirstOrDefault();
if (item != null)
{
Session["Name"] = TextBox1.Text;
// Server.Transfer("User.aspx");
FormsAuthentication.RedirectFromLoginPage(TextBox1.Text, true);
}
else
{
Label3.Visible = true;
Label3.Text = "Sorry! Invalid username and password.";
}
// throw new Exception();
}
catch (Exception ex)
{
Response.Redirect("LoginError.aspx");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
Library_ManagementEntities6 db = new Library_ManagementEntities6();
int i = Convert.ToInt32(Session["noOfCheck"]);
for (int j = 1; j <= i; j++)
{
var order = (from item in db.Order_Details where item.mode == 1 select item).FirstOrDefault();
order.mode = 0;
db.SaveChanges();
}
Response.Redirect("User.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
// ((Label)Master.FindControl("Label1")).Visible = true;
try
{
int total = 0;
foreach (GridViewRow row in GridView1.Rows)
{
var bookName = Convert.ToString(row.Cells[0].Text);
Library_ManagementEntities6 db = new Library_ManagementEntities6();
var book = (from item in db.Book_Details where item.Book_Title == bookName select item).FirstOrDefault();
if (book.Booked == 0)
{
var checkbox = row.FindControl("chkCtrl") as CheckBox;
checkbox.Visible = false;
}
else
{
row.Cells[4].Text = null;
}
}
foreach (GridViewRow row in GridView1.Rows)
{
var bookName = Convert.ToString(row.Cells[0].Text);
Library_ManagementEntities6 db = new Library_ManagementEntities6();
var book = (from item in db.Book_Details where item.Book_Title == bookName select item).FirstOrDefault();
var checkbox = row.FindControl("chkCtrl") as CheckBox;
int bookamt = Convert.ToInt32(book.Book_Amount);
if (checkbox.Checked)
{
total = total + bookamt;
TextBox1.Text = Convert.ToString(total);
}
}
}
catch (Exception ex)
{
Response.Redirect("ErrorPage.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
using (Library_ManagementEntities6 context = new Library_ManagementEntities6())
{
var user = (from s in context.User_Details where s.UserName == TextBox1.Text select s).FirstOrDefault();
if (user != null)
{
Label3.Visible = true;
Label3.Text = "Username already exist";
TextBox1.Text = " ";
TextBox2.Text = " ";
}
else
{
User_Details obj = new User_Details();
obj.UserName = TextBox1.Text;
obj.PassWord = TextBox2.Text;
Session["Name"] = TextBox1.Text;
context.User_Details.Add(obj);
context.SaveChanges();
// throw new Exception();
FormsAuthentication.RedirectFromLoginPage(TextBox1.Text, true);
}
}
throw new Exception();
}
catch (Exception ex)
{
Response.Redirect("LoginError.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
int countCheck = 0;
foreach (GridViewRow row in GridView1.Rows)
{
var bookName = Convert.ToString(row.Cells[0].Text);
Library_ManagementEntities6 db = new Library_ManagementEntities6();
var uname = Session["Name"].ToString();
var book = (from item in db.Book_Details where item.Book_Title == bookName select item).FirstOrDefault();
var user = (from items in db.User_Details where items.UserName == uname select items).FirstOrDefault();
var checkbox = row.FindControl("chkCtrl") as CheckBox;
if (checkbox.Checked)
{
countCheck = countCheck + 1;
Order_Details obj = new Order_Details();
obj.UserId = user.UserId;
obj.BookId = book.BookId;
obj.mode = 1;
var count = book.Booked;
count = count - 1;
book.Booked = count;
db.Order_Details.Add(obj);
db.SaveChanges();
Session["noOfCheck"] = countCheck;
}
}
throw new Exception();
}
catch (Exception ex)
{
Response.Redirect("Confirm.aspx");
}
}
