public List<DAO.BazarCostEntry> getAllBazarCost()
{
try
{
aSqlConnection.Open();
SqlCommand command = new SqlCommand("uspBazarCost", aSqlConnection);
command.CommandType = CommandType.StoredProcedure;
SqlDataReader aReader = command.ExecuteReader();
abazarCostEntryList = new List<BazarCostEntry>();
if (aReader.HasRows)
{
while (aReader.Read())
{
BazarCostEntry aBazarCostEntry=new BazarCostEntry();
aBazarCostEntry.id = (int) aReader[0];
aBazarCostEntry.amount = Convert.ToInt32(aReader[1].ToString());
aBazarCostEntry.date= (DateTime) aReader[2];
abazarCostEntryList.Add(aBazarCostEntry);
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
finally
{
if (aSqlConnection != null && aSqlConnection.State == ConnectionState.Open)
{
aSqlConnection.Close();
}
}
return abazarCostEntryList;
}
public string save(BazarCostEntry aBazarCostEntry)
{
try
{
new BazarCostEntryValidator().isValidCost(aBazarCostEntry.amount);
if ((aBazarCostEntry.amount == 0))
{
return "please fill all the field";
}
else
{
return aBazarCostEntryGateway.save(aBazarCostEntry);
}
}
catch (Exception e)
{
throw new Exception(e.Message,e);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
try
{
BazarCostEntry aBazarCostEntry = new BazarCostEntry(Convert.ToInt32(amountTextBox.Text),
dateTimePicker1.Value);
string msg = aBazarCostEntryBll.save(aBazarCostEntry);
MessageBox.Show(msg, @"Message");
showDataInDataGrid();
clearTextBoxes();
}
catch (FormatException ex)
{
MessageBox.Show(@"Enter amount in correct format.",ex.Message);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}