public double getTotalFineAmount(string dbpath)
{
DbCon con = new DbCon(dbpath);
DataRowCollection dr = con.ExecuteSelectCommand("select sum(fineamount) from student_fine");
return(Convert.ToDouble(dr[0].ItemArray[0]));
}
public bool BookIDExists(string ID)
{
bool res = true;
try
{
//cmd=new OleDbCommand("Select * from books ")
DbCon con = new DbCon();
DataRowCollection ds;
ds = con.ExecuteSelectCommand("select * from Books where BookID='" + ID + "'");
if (ds.Count > 0)
{
res = true;
}
else
{
res = false;
}
}
catch (Exception ex)
{
res = false;
MessageBox.Show(ex.Message);
}
return(res);
}
private void BookIDForAutocomplere()
{
DataRowCollection ds = con.ExecuteSelectCommand("select * from Books");
AutoCompleteStringCollection c = new AutoCompleteStringCollection();
for (int i = 0; i < ds.Count; i++)
{
c.Add(ds[i].ItemArray[0].ToString());
}
}
public bool searchStudentByName(string name, string path)
{
DbCon con = new DbCon(path);
DataRowCollection dr =
con.ExecuteSelectCommand("select * from student where studentName like'%" + name + "%'");
if (dr.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool StudentExists(string ID, string path)
{
DbCon con = new DbCon(path);
DataRowCollection dr =
con.ExecuteSelectCommand("select * from student where studentId='" + ID + "'");
if (dr.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool searchBookbycatagory(string id, string path)
{
bool res;
DbCon con = new DbCon(path);
DataRowCollection dr =
con.ExecuteSelectCommand("select * from books where BookcatName Like '%" + id + "%'");
if (dr.Count > 0)
{
res = true;
}
else
{
res = false;
}
return(res);
}
private void button1_Click(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
string cmdstr = "select * from Books where ";
if (textBox1.Text == "")
{
MessageBox.Show("Provide data in the search field");
return;
}
switch (comboBox1.SelectedIndex)
{
case 0:
cmdstr += " bookID='" + textBox1.Text + "'";
break;
case 1:
cmdstr += " bookname like'%" + textBox1.Text + "%'";
break;
case 2:
cmdstr += " bookpubname like'%" + textBox1.Text + "%'";
break;
case 3:
cmdstr += " bookautname like'%" + textBox1.Text + "%'";
break;
case 4:
cmdstr += " bookcatname like'%" + textBox1.Text + "%'";
break;
default:
break;
}
DbCon db = new DbCon();
DataRowCollection dr = db.ExecuteSelectCommand(cmdstr);
for (int i = 0; i < dr.Count; i++)
{
dataGridView1.Rows.Add(dr[i].ItemArray);
}
//dataGridView1.DataSource = dr;
}
public bool BookIDExists(string ID, string dbpath)
{
bool res = true;
try
{
DbCon con = new DbCon(dbpath);
DataRowCollection ds;
ds = con.ExecuteSelectCommand("select * from Books where BookID='" + ID + "'");
if (ds.Count > 0)
{
res = true;
}
else
{
res = false;
}
}
catch (Exception)
{
return(false);
}
return(res);
}
public DataRowCollection SearchBooks(string search, string dbpath)
{
DbCon con = new DbCon(dbpath);
return(con.ExecuteSelectCommand(search));
}