public List <tblStudentInfo> GetStudentInfo()
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
var listitemsrecord = (from x in db.tblStudentInfoes orderby x.libid descending select x).ToList <tblStudentInfo>();
return(listitemsrecord);
}
public List <tblTeacherLogin> GetTeacherLogin()
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
var listitemsrecord = (from x in db.tblTeacherLogins orderby x.loginid descending select x).ToList <tblTeacherLogin>();
return(listitemsrecord);
}
public List <tblBook> GetBooksRecord()
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
var listitemsrecord = (from x in db.tblBooks orderby x.code descending select x).ToList <tblBook>();
return(listitemsrecord);
}
public List <tblBooksIssued> GetIssueBooks()
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
var listitemsrecord = (from x in db.tblBooksIssueds orderby x.bookid descending select x).ToList <tblBooksIssued>();
return(listitemsrecord);
}
private void populateIssueBook()
{
using (BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities())
{
gvIssueBook.DataSource = GetIssueBooks();
gvIssueBook.DataBind();
}
}
private void populateBooks()
{
using (BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities())
{
gvBooks.DataSource = GetBooksRecord();
gvBooks.DataBind();
}
}
private void populateTeacherLogin()
{
using (BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities())
{
gvTeacherLogin.DataSource = GetTeacherLogin();
gvTeacherLogin.DataBind();
}
}
private void populateStudentLogin()
{
using (BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities())
{
gvStudentLogin.DataSource = GetStudentLogin();
gvStudentLogin.DataBind();
}
}
protected void btnDeleteBooks_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
tblBook tbl = db.tblBooks.ToList().Where(x => x.code == int.Parse(txtCode.Text)).First();
db.DeleteObject(tbl);
db.SaveChanges();
populateBooks();
}
public void searchBooksByAuthor()
{
using (BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities())
{
dlSearch.DataSource = from Books in db.tblBooks
where Books.author.Contains(author)
select Books;
dlSearch.DataBind();
}
}
protected void btnSearchAuthor_Click(object sender, EventArgs e)
{
using (BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities())
{
dlSearch.DataSource = from Books in db.tblBooks
where Books.author.Contains(txtSearch.Text)
select Books;
dlSearch.DataBind();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
tblBook tbl = db.tblBooks.ToList().Where(x => x.code == int.Parse(txtCode.Text.ToString())).First();
txtTitle.Text = tbl.title;
txtAuthor.Text = tbl.author;
txtPublication.Text = tbl.publication;
txtSubject.Text = tbl.subject;
txtBooksQnty.Text = tbl.no_of_copies.ToString();
}
protected void btnInsertBooks_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
tblBook tbl = new tblBook();
tbl.title = txtTitle.Text;
tbl.author = txtAuthor.Text;
tbl.publication = txtPublication.Text;
tbl.subject = txtSubject.Text;
tbl.no_of_copies = int.Parse(txtBooksQnty.Text);
db.AddTotblBooks(tbl);
db.SaveChanges();
populateBooks();
}
protected void btnUpdateBooks_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
tblBook tbl = db.tblBooks.ToList().Where(x => x.code == int.Parse(txtCode.Text)).First();
tbl.title = txtTitle.Text;
tbl.author = txtAuthor.Text;
tbl.publication = txtPublication.Text;
tbl.subject = txtSubject.Text;
tbl.no_of_copies = int.Parse(txtBooksQnty.Text);
db.SaveChanges();
populateBooks();
}
protected void btnSignupTCHR_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
int result = db.sp_insertTCHRLogin(int.Parse(tid), txtUSernameTCHR.Text, txtPasswordTCHR.Text);
if (result > 0)
{
Response.Write("document.alert('Successfully Submitted....!!!!')");
Response.Redirect("books.aspx");
}
else
{
SetFocus(txtUSernameTCHR);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
var myUser = db.tblStudentLogins
.FirstOrDefault(u => u.username == txtUsername.Text &&
u.password == txtPassword.Text);
if (myUser != null) //User was found
{
Response.Write("alert('Login Succesfull...!!!');");
Response.Redirect("books.aspx");
}
else //User was not found
{
Response.Write("alert('Login Failed...!!!');");
SetFocus(txtUsername);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
var myUser = db.tblTeacherLogins
.FirstOrDefault(u => u.username == txtUsername.Text &&
u.password == txtPassword.Text);
if (myUser != null) //User was found
{
Response.Write("alert('Login Succesfull...!!!')");
Response.Redirect("books.aspx");
}
else //User was not found
{
var clientScript = Page.ClientScript;
clientScript.RegisterClientScriptBlock(this.GetType(), "AlertScript", "alert('ERROR')'", true);
SetFocus(txtUsername);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
int result = db.sp_insertStudentInfo(int.Parse(txtRegNoSTD.Text), txtBranchSTD.Text, txtSectionSTD.Text, txtSemesterSTD.Text, int.Parse(txtYOASTD.Text));
ObjectParameter lib_id = new ObjectParameter("libid", typeof(System.Int32));
db.sp_libraryID(int.Parse(txtRegNoSTD.Text), lib_id);
if (result > 0)
{
Response.Write("document.alert('Successfully Submitted....!!!!')");
libID = lib_id.Value.ToString();
studentsignupbox.Visible = true;
studentsubmitbox.Visible = false;
}
else
{
SetFocus(txtRegNoSTD);
}
}
protected void btnSubmitTCHR_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
int result = db.sp_insertTeacherInfo(txtNameTCHR.Text, txtDesignationTCHR.Text, txtBranchTCHR.Text, txtContactTCHR.Text, txtLecturesTCHR.Text);
ObjectParameter t_id = new ObjectParameter("tid", typeof(System.Int32));
db.sp_teacherID(txtNameTCHR.Text, t_id);
if (result > 0)
{
Response.Write("document.alert('Successfully Submitted....!!!!')");
tid = t_id.Value.ToString();
teachersignupbox.Visible = true;
teachersubmitbox.Visible = false;
}
else
{
SetFocus(txtNameTCHR);
}
}
