public List<DAO.BalanceEntry> getAllBalanceEntryInfo() { try { aSqlConnection.Open(); SqlCommand command = new SqlCommand("USPBalances", aSqlConnection); command.CommandType = CommandType.StoredProcedure; SqlDataReader aReader = command.ExecuteReader(); aBalanceEntryList = new List<BalanceEntry>(); if (aReader.HasRows) { while (aReader.Read()) { BalanceEntry aBalanceEntry = new BalanceEntry(); aBalanceEntry.memberId = (int)aReader[0]; aBalanceEntry.balance = Convert.ToInt32(aReader[1].ToString()); aBalanceEntry.balanceEntryDate = (DateTime)aReader[2]; aBalanceEntryList.Add(aBalanceEntry); } } } catch (Exception e) { MessageBox.Show(e.Message); } finally { if (aSqlConnection != null && aSqlConnection.State == ConnectionState.Open) { aSqlConnection.Close(); } } return aBalanceEntryList; }
private void saveButton_Click(object sender, EventArgs e) { try { if (!Regex.IsMatch(balanceTextBox.Text, "^[0-9]")) { throw new Exception("Digit Only!"); } BalanceEntry aBalanceEntry = new BalanceEntry(Convert.ToInt32(memberIdComboBox.Text), Convert.ToInt32(balanceTextBox.Text), dateTimePicker1.Value); string msg = aBalanceEntryBll.save(aBalanceEntry); MessageBox.Show(msg); showDataInDataGridView(); clearTextBoxes(); } catch (FormatException exception) { MessageBox.Show(@"Please enter balance in correct format.",exception.Message); } catch (Exception exception) { MessageBox.Show(exception.Message); } }
public string updateBalance(BalanceEntry aBalanceEntry) { try { aSqlConnection.Open(); SqlCommand command = new SqlCommand("USPBalanceUpdation", aSqlConnection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@memberId", aBalanceEntry.memberId); command.Parameters.AddWithValue("@balance", aBalanceEntry.balance); command.Parameters.AddWithValue("@balanceEntryDate", aBalanceEntry.balanceEntryDate); int effectedRows = command.ExecuteNonQuery(); if (effectedRows > 0) { return @"Balance is updated"; } } catch (Exception e) { throw new Exception(e.Message); } finally { if (aSqlConnection != null && aSqlConnection.State == ConnectionState.Open) { aSqlConnection.Close(); } } return @"Error while updating data."; }