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.";
}
