private void AuthorBrowse_Load(object sender, EventArgs e)
{
SA47_Team12bDataSet ds = new SA47_Team12bDataSet();
SA47_Team12bDataSetTableAdapters.AuthorsTableAdapter authorsTableAdapter = new SA47_Team12bDataSetTableAdapters.AuthorsTableAdapter();
authorsTableAdapter.Fill(ds.Authors);
dataGridViewAutBrowse.DataSource = ds.Tables["Authors"];
}
private void MemberBrowse_Load(object sender, EventArgs e)
{
SA47_Team12bDataSet ds = new SA47_Team12bDataSet();
SA47_Team12bDataSetTableAdapters.MembersTableAdapter membersTableAdapter = new SA47_Team12bDataSetTableAdapters.MembersTableAdapter();
membersTableAdapter.Fill(ds.Members);
dataGridViewMemBrowse.DataSource = ds.Tables["Members"];
}
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 ReportBorrowersDemographic_Load(object sender, EventArgs e)
{
SA47_Team12bDataSet ds = new SA47_Team12bDataSet();
SA47_Team12bDataSetTableAdapters.MembersTableAdapter membersTableAdapter = new SA47_Team12bDataSetTableAdapters.MembersTableAdapter();
membersTableAdapter.Fill(ds.Members);
CRBorrowerDemographic crBorrowerDemographic = new CRBorrowerDemographic();
crBorrowerDemographic.SetDataSource(ds);
crystalReportViewerBD.ReportSource = crBorrowerDemographic;
}
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 ReportTransactionHistory_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.TransactionHistoryTableAdapter transactionHistoryTableAdapter = new SA47_Team12bDataSetTableAdapters.TransactionHistoryTableAdapter();
transactionHistoryTableAdapter.Fill(ds.TransactionHistory);
CRTransactionHistory crTransactionHistory = new CRTransactionHistory();
crTransactionHistory.SetDataSource(ds);
crystalReportViewerTH.ReportSource = crTransactionHistory;
}
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;
}
private void buttonLogin_Click(object sender, EventArgs e)
{
login = "******";
string cnS = "data source=(local);initial catalog=SA47_Team12aCADatabase;integrated security=SSPI";
SqlConnection cn = new SqlConnection(cnS);
string sql = "Select Login,Password from EmployeeMaster";
SqlCommand cm = new SqlCommand(sql, cn);
SqlDataAdapter da = new SqlDataAdapter(cm);
SqlCommandBuilder cmb = new SqlCommandBuilder(da);
SA47_Team12bDataSet ds = new SA47_Team12bDataSet();
da.Fill(ds, "EmployeeMaster");
DataRow dr = ds.Tables["EmployeeMaster"].NewRow();
int a, b = 0;
for (a = 0; a < ds.Tables["EmployeeMaster"].Rows.Count; a++)
{
if (ds.Tables["EmployeeMaster"].Rows[a]["Login"].ToString() == textBoxUsername.Text.Trim())
{
break;
}
if (a == ds.Tables["EmployeeMaster"].Rows.Count)
{
a = 109;
}
}
if (a < ds.Tables["EmployeeMaster"].Rows.Count)
{
}
else
{
MessageBox.Show("User not found!!");
}
for (b = 0; b < ds.Tables["EmployeeMaster"].Rows.Count; b++)
{
if (ds.Tables["EmployeeMaster"].Rows[b]["Password"].ToString() == textBoxPassword.Text.Trim())
{
break;
}
}
if (b < ds.Tables["EmployeeMaster"].Rows.Count)
{
}
else
{
MessageBox.Show("Password not correct!!");
}
if (a == b && textBoxUsername.Text != "" && textBoxPassword.Text != "")
{
LibraryScreen menus = new LibraryScreen();
menus.Showname = textBoxUsername.Text;
menus.Show();
this.Hide();
}
else if (b < ds.Tables["EmployeeMaster"].Rows.Count)
{
MessageBox.Show("Password not correct!!");
}
}
