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 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);
}
}
