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