private void BookBrowse_Load(object sender, EventArgs e)
{
SA47_Team12bDataSet ds = new SA47_Team12bDataSet();
SA47_Team12bDataSetTableAdapters.BooksTableAdapter booksTableAdapter = new SA47_Team12bDataSetTableAdapters.BooksTableAdapter();
booksTableAdapter.Fill(ds.Books);
dataGridViewBookBrowse.DataSource = ds.Tables["Books"];
}
private void buttonBMUpdate_Click(object sender, EventArgs e)
{
try
{
int originalTotalStock = Convert.ToInt16(Books[row].TotalStock.ToString());
Books[row].BookID = Convert.ToInt16(textBoxBMBookID.Text.ToString());
Books[row].BookTitle = textBoxBMBookTitle.Text.ToString();
Books[row].AuthorName = textBoxBMAuthorName.Text.ToString();
Books[row].Publisher = textBoxBMPublisher.Text.ToString();
Books[row].TotalStock = Convert.ToInt16(textBoxBMTotalStock.Text.ToString());
context.SaveChanges();
ds = new SA47_Team12bDataSet();
SA47_Team12bDataSetTableAdapters.StockAdjustmentTableAdapter stockAdjustmentTableAdapter = new SA47_Team12bDataSetTableAdapters.StockAdjustmentTableAdapter();
stockAdjustmentTableAdapter.Fill(ds.StockAdjustment);
SA47_Team12bDataSetTableAdapters.BooksTableAdapter booksTableAdapter = new SA47_Team12bDataSetTableAdapters.BooksTableAdapter();
booksTableAdapter.Fill(ds.Books);
DataRow dr = ds.Tables["StockAdjustment"].NewRow();
dr["BookID"] = Books[row].BookID;
dr["Date Adjusted"] = Convert.ToString(DateTime.Now);
ds.Tables["StockAdjustment"].Rows.Add(dr);
stockAdjustmentTableAdapter.Update(ds.StockAdjustment);
foreach (DataRow datarow in ds.Tables["Books"].Rows)
{
if (datarow["BookID"].ToString() == textBoxBMBookID.Text)
{
if (Convert.ToInt16(textBoxBMTotalStock.Text) >= originalTotalStock)
{
/* ds.Tables["StockAdjustment2"].Rows[row]["Adjustment Quantity"]*/
dr["Adjustment Quantity"] = Convert.ToInt16(textBoxBMTotalStock.Text.ToString()) - originalTotalStock;
dr["Status"] = "ADD";
}
else
{
dr["Adjustment Quantity"] = originalTotalStock - Convert.ToInt16(textBoxBMTotalStock.Text.ToString());
dr["Status"] = "REMOVE";
}
}
row = row + 1;
}
stockAdjustmentTableAdapter.Update(ds.StockAdjustment);
MessageBox.Show("Record has been updated");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ReportAvailableStocks_Load(object sender, EventArgs e)
{
SA47_Team12bDataSet ds = new SA47_Team12bDataSet();
SA47_Team12bDataSetTableAdapters.BooksTableAdapter booksTableAdapter = new SA47_Team12bDataSetTableAdapters.BooksTableAdapter();
booksTableAdapter.Fill(ds.Books);
CRAvailableStocks crAvailableStocks = new CRAvailableStocks();
crAvailableStocks.SetDataSource(ds);
crystalReportViewerAS.ReportSource = crAvailableStocks;
}
private void buttonIBIssue_Click(object sender, EventArgs e)
{
try
{
ds = new SA47_Team12bDataSet();
SA47_Team12bDataSetTableAdapters.IssueTransTableAdapter issueTransTableAdapter = new SA47_Team12bDataSetTableAdapters.IssueTransTableAdapter();
issueTransTableAdapter.Fill(ds.IssueTrans);
SA47_Team12bDataSetTableAdapters.BooksTableAdapter booksTableAdapter = new SA47_Team12bDataSetTableAdapters.BooksTableAdapter();
booksTableAdapter.Fill(ds.Books);
DataRow dr = ds.Tables["IssueTrans"].NewRow();
//dr["TransactionID"] = .Text;
dr["MemberID"] = textBoxIBMemID.Text;
dr["BookID"] = textBoxIBBookID.Text;
dr["IssueDate"] = textBoxIBIssueDate.Text;
dr["DueDate"] = textBoxIBDueDate.Text;
dr["Status"] = "OUT";
dr["Remarks"] = textBoxIBRemarks.Text;
ds.Tables["IssueTrans"].Rows.Add(dr);
issueTransTableAdapter.Update(ds.IssueTrans);
foreach (DataRow datarow in ds.Tables["Books"].Rows)
{
if (datarow["BookID"].ToString() == textBoxIBBookID.Text)
{
ds.Tables["Books"].Rows[rowNo]["NumberRented"] = Convert.ToInt32(ds.Tables["Books"].Rows[rowNo]["NumberRented"]) + 1;
}
rowNo = rowNo + 1;
}
booksTableAdapter.Update(ds.Books);
progressBarLib.Visible = true;
progressBarLib.PerformStep();
if (progressBarLib.Value == 100)
{
MessageBox.Show("Record has been updated");
progressBarLib.Value = progressBarLib.Minimum;
}
progressBarLib.Visible = false;
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message);
}
}
private void ReportMonthlyStats_Load(object sender, EventArgs e)
{
SA47_Team12bDataSet ds = new SA47_Team12bDataSet();
SA47_Team12bDataSetTableAdapters.BooksTableAdapter booksTableAdapter = new SA47_Team12bDataSetTableAdapters.BooksTableAdapter();
booksTableAdapter.Fill(ds.Books);
SA47_Team12bDataSetTableAdapters.IssueTransTableAdapter issueTransTableAdapter = new SA47_Team12bDataSetTableAdapters.IssueTransTableAdapter();
issueTransTableAdapter.Fill(ds.IssueTrans);
SA47_Team12bDataSetTableAdapters.MonthlyStatsTableAdapter monthlyStatsTableAdapter = new SA47_Team12bDataSetTableAdapters.MonthlyStatsTableAdapter();
monthlyStatsTableAdapter.Fill(ds.MonthlyStats);
CRMonthlyStats crMonthlyStats = new CRMonthlyStats();
crMonthlyStats.SetDataSource(ds);
crystalReportViewerMS.ReportSource = crMonthlyStats;
}