//Return book(Member Form)
public void DeleteIssue(MemberDB obj)
{
DBConnection mycon = new DBConnection();
String SQL = "delete from bookissue where IssueID='" + obj.Retunissueid + "'";
mycon.addvalues(SQL);
}
// add issue details
public void addisueinfo(MemberDB obj)
{
String SQL = "insert into bookissue values('" + obj.issueid + "','" + obj.Bookname + "','" + obj.MemberName + "','" + obj.IssueDate + "','" + obj.ReturnDate + "','" + obj.MemberID + "')";
DBConnection mycon = new DBConnection();
mycon.addvalues(SQL);
}
// update avalable quantity
public void Upatebookavalableqty(MemberDB obj)
{
String SQL = "update Book set Avalableqty=Avalableqty-1 where BookName='" + obj.Bookname + "'";
DBConnection mycon = new DBConnection();
mycon.addvalues(SQL);
}
private void dataGridViewReturnbook_CellClick(object sender, DataGridViewCellEventArgs e)
{
// seting return ook table value to lables
try
{
String issueid;
issueid = dataGridViewReturnbook.SelectedCells[0].Value.ToString();
// issueid = labelissueid1.Text;
MemberDB obj = new MemberDB();
SqlDataReader dr = obj.getissuebookdetil(issueid);
DataTable dt = new DataTable();
dt.Columns.Add("IssueID");
dt.Columns.Add("BookName");
dt.Columns.Add("IssueDate");
dt.Columns.Add("ReturnDate");
while (dr.Read())
{
DataRow row = dt.NewRow();
labelissueid1.Text = dr["IssueID"].ToString();
labelbookname.Text = dr["BookName"].ToString();
labelissuedate.Text = dr["IssueDate"].ToString();
labelReturndate.Text = dr["ReturnDate"].ToString();
dt.Rows.Add(row);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ManageIssueBook_Load(object sender, EventArgs e)
{
//get issue table details
try
{
MemberDB obj = new MemberDB();
SqlDataReader dr = obj.getissueBooktable();
DataTable dt = new DataTable();
dt.Columns.Add("IssueID");
dt.Columns.Add("BookName");
dt.Columns.Add("MemberName");
dt.Columns.Add("IssueDate");
dt.Columns.Add("ReturnDate");
dt.Columns.Add("MemberID");
while (dr.Read())
{
DataRow row = dt.NewRow();
row["IssueID"] = dr["IssueID"];
row["BookName"] = dr["BookName"];
row["MemberName"] = dr["MemberName"];
row["IssueDate"] = dr["IssueDate"];
row["ReturnDate"] = dr["ReturnDate"];
row["MemberID"] = dr["MemberID"];
dt.Rows.Add(row);
}
dataGridViewReturnbook.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void dataGridViewReturnbook_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{// in this code use to selected book details(datagird view) set to text filed
String issueid;
issueid = dataGridViewReturnbook.SelectedCells[0].Value.ToString();
MemberDB obj = new MemberDB();
SqlDataReader dr = obj.getissuebookdetil(issueid);
DataTable dt = new DataTable();
// dt.Columns.Add("IssueID");
dt.Columns.Add("BookName");
dt.Columns.Add("MemberName");
dt.Columns.Add("IssueDate");
dt.Columns.Add("ReturnDate");
dt.Columns.Add("MemberID");
while (dr.Read())
{
DataRow row = dt.NewRow();
textBoxBookNAME.Text = dr["BookName"].ToString();
textBoxMemberName.Text = dr["BookName"].ToString();
textBoxIssueDate.Text = dr["IssueDate"].ToString();
textBoxReturndate.Text = dr["ReturnDate"].ToString();
textBoxMembeerid.Text = dr["MemberID"].ToString();
dt.Rows.Add(row);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
String Memberid;
Memberid = dataGridViewReturnbook.SelectedCells[5].Value.ToString();
MemberDB obj = new MemberDB();
SqlDataReader dr = obj.getMemberInfo(Memberid);
// DataTable dt = new DataTable();
while (dr.Read())
{
textBoxEMAIL.Text = dr["Email"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void dataGridViewBookname_CellClick(object sender, DataGridViewCellEventArgs e)
{ //set tble value book nametable
try
{
String Bookid;
Bookid = dataGridViewBookname.SelectedCells[0].Value.ToString();
MemberDB obj = new MemberDB();
SqlDataReader dr = obj.getBookname(Bookid);
DataTable dt = new DataTable();
dt.Columns.Add("BookName");
while (dr.Read())
{
DataRow row = dt.NewRow();
textBoxBookname.Text = dr["BookName"].ToString();
dt.Rows.Add(row);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void buttonReturn_Click(object sender, EventArgs e)
{
MemberDB obj = new MemberDB();
obj.Returnbooknme = labelbookname.Text;
obj.Upatebookavalableqty1(obj);
obj.Retunissueid1 = labelissueid1.Text;
obj.DeleteIssue(obj);
// bookable
try
{
MemberDB objt = new MemberDB();
SqlDataReader dr = objt.getbooklist();
DataTable dt = new DataTable();
dt.Columns.Add("ISBNNumber");
dt.Columns.Add("BookName");
dt.Columns.Add("Quantity");
dt.Columns.Add("Avalableqty");
while (dr.Read())
{
DataRow row = dt.NewRow();
row["ISBNNumber"] = dr["ISBNNumber"];
row["BookName"] = dr["BookName"];
row["Quantity"] = dr["Quantity"];
row["Avalableqty"] = dr["Avalableqty"];
dt.Rows.Add(row);
}
dataGridViewBookname.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// return book table
try
{
MemberDB objt = new MemberDB();
SqlDataReader dr = objt.getissueBooktable();
DataTable dt = new DataTable();
dt.Columns.Add("IssueID");
dt.Columns.Add("BookName");
dt.Columns.Add("MemberName");
dt.Columns.Add("IssueDate");
dt.Columns.Add("ReturnDate");
dt.Columns.Add("MemberID");
while (dr.Read())
{
DataRow row = dt.NewRow();
row["IssueID"] = dr["IssueID"];
row["BookName"] = dr["BookName"];
row["MemberName"] = dr["MemberName"];
row["IssueDate"] = dr["IssueDate"];
row["ReturnDate"] = dr["ReturnDate"];
row["MemberID"] = dr["MemberID"];
dt.Rows.Add(row);
}
dataGridViewReturnbook.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// clearlables
labelissueid1.Text = "";
labelbookname.Text = "";
labelissuedate.Text = "";
labelReturndate.Text = "";
}
private void MemberForm_Load(object sender, EventArgs e)
{
// get member id login form
textBoxMemberid.Text = LoginForm.passingtext;
//get member name
try
{
MemberDB obj = new MemberDB();
SqlDataReader dtr = obj.getMemberInfo(textBoxMemberid.Text);
SqlCommand cmd = new SqlCommand();
while (dtr.Read())
{
textBoxMemberName.Text = dtr["FristName"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//auto genaratd id
try
{
MemberDB obj = new MemberDB();
SqlDataReader DR = obj.getAutogenaratedid();
SqlCommand cmd = new SqlCommand();
while (DR.Read())
{
textBoxIssueid.Text = DR["IssueID"].ToString();
}
int i = int.Parse(textBoxIssueid.Text);
i = i + 1;
textBoxIssueid.Text = i.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// get booktble details
try
{
MemberDB objt = new MemberDB();
SqlDataReader dr = objt.getbooklist();
DataTable dt = new DataTable();
dt.Columns.Add("ISBNNumber");
dt.Columns.Add("BookName");
dt.Columns.Add("Quantity");
dt.Columns.Add("Avalableqty");
while (dr.Read())
{
DataRow row = dt.NewRow();
row["ISBNNumber"] = dr["ISBNNumber"];
row["BookName"] = dr["BookName"];
row["Quantity"] = dr["Quantity"];
row["Avalableqty"] = dr["Avalableqty"];
dt.Rows.Add(row);
}
dataGridViewBookname.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//get issue table details
try
{
MemberDB obj = new MemberDB();
SqlDataReader dr = obj.getissueBooktable();
DataTable dt = new DataTable();
dt.Columns.Add("IssueID");
dt.Columns.Add("BookName");
dt.Columns.Add("MemberName");
dt.Columns.Add("IssueDate");
dt.Columns.Add("ReturnDate");
dt.Columns.Add("MemberID");
while (dr.Read())
{
DataRow row = dt.NewRow();
row["IssueID"] = dr["IssueID"];
row["BookName"] = dr["BookName"];
row["MemberName"] = dr["MemberName"];
row["IssueDate"] = dr["IssueDate"];
row["ReturnDate"] = dr["ReturnDate"];
row["MemberID"] = dr["MemberID"];
dt.Rows.Add(row);
}
dataGridViewReturnbook.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void buttonIssueBook_Click(object sender, EventArgs e)
{ // issue button
int avalaleqty = 0;
MemberDB objct = new MemberDB();
SqlDataReader drt = objct.getbooklist();
DataTable dtr = new DataTable();
dtr.Columns.Add("Avalableqty");
while (drt.Read())
{
avalaleqty = Convert.ToInt32(drt["Avalableqty"].ToString());
}
if (avalaleqty > 0)
{
if (textBoxBookname.Text == "")
{
MessageBox.Show("Plese select book", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MemberDB obj = new MemberDB();
obj.Issueid = textBoxIssueid.Text;
obj.Bookname1 = textBoxBookname.Text;
obj.MemberName1 = textBoxMemberName.Text;
obj.IssueDate1 = dateTimePickerIssudate.Value.ToString();
obj.ReturnDate1 = dateTimePickerReturndate.Value.ToString();
obj.MemberID1 = textBoxMemberid.Text;
obj.addisueinfo(obj);
obj.Upatebookavalableqty(obj);
// get book table details
try
{
MemberDB objt = new MemberDB();
SqlDataReader dr = objt.getbooklist();
DataTable dt = new DataTable();
dt.Columns.Add("ISBNNumber");
dt.Columns.Add("BookName");
dt.Columns.Add("Quantity");
dt.Columns.Add("Avalableqty");
while (dr.Read())
{
DataRow row = dt.NewRow();
row["ISBNNumber"] = dr["ISBNNumber"];
row["BookName"] = dr["BookName"];
row["Quantity"] = dr["Quantity"];
row["Avalableqty"] = dr["Avalableqty"];
dt.Rows.Add(row);
}
dataGridViewBookname.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
else
{
MessageBox.Show("Book not avalable inthis moment", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
textBoxIssueid.Text = "";
textBoxBookname.Text = "";
//get issue table details
try
{
MemberDB obj = new MemberDB();
SqlDataReader dr = obj.getissueBooktable();
DataTable dt = new DataTable();
dt.Columns.Add("IssueID");
dt.Columns.Add("BookName");
dt.Columns.Add("MemberName");
dt.Columns.Add("IssueDate");
dt.Columns.Add("ReturnDate");
dt.Columns.Add("MemberID");
while (dr.Read())
{
DataRow row = dt.NewRow();
row["IssueID"] = dr["IssueID"];
row["BookName"] = dr["BookName"];
row["MemberName"] = dr["MemberName"];
row["IssueDate"] = dr["IssueDate"];
row["ReturnDate"] = dr["ReturnDate"];
row["MemberID"] = dr["MemberID"];
dt.Rows.Add(row);
}
dataGridViewReturnbook.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//get auto genarated id again
try
{
MemberDB objt = new MemberDB();
SqlDataReader DR = objt.getAutogenaratedid();
SqlCommand cmd = new SqlCommand();
//DataTable dt = new DataTable();
//dt.Columns.Add("IssueID");
while (DR.Read())
{
textBoxIssueid.Text = DR["IssueID"].ToString();
}
int i = int.Parse(textBoxIssueid.Text);
i = i + 1;
textBoxIssueid.Text = i.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}