override public void confirmTransaction(IncomingTransaction transaction, Building apartment, Income view)
{
SqlCommand insertCommand = new SqlCommand(INSERT_TRANSACTION_SP.SP_NAME, connection);
insertCommand.CommandType = System.Data.CommandType.StoredProcedure;
insertCommand.Parameters.AddWithValue(INSERT_TRANSACTION_SP.TR_ID_PARAM, transaction.getTrID());
insertCommand.Parameters.AddWithValue(INSERT_TRANSACTION_SP.APARTMENT_ID_PARAM, Guid.Parse(transaction.getApartment().getID()));
insertCommand.Parameters.AddWithValue(INSERT_TRANSACTION_SP.AMOUNT_PARAM, transaction.getAmount());
insertCommand.Parameters.AddWithValue(INSERT_TRANSACTION_SP.COLLECTED_BY_PARAM, transaction.getCollectedBy().getFlatNumber());
insertCommand.Parameters.AddWithValue(INSERT_TRANSACTION_SP.DATE_PARAM, transaction.getDate());
insertCommand.Parameters.AddWithValue(INSERT_TRANSACTION_SP.MONTH_PARAM, transaction.getMonth());
insertCommand.Parameters.AddWithValue(INSERT_TRANSACTION_SP.PAID_BY_PARAM, transaction.getPaidBy().getFlatNumber());
insertCommand.Parameters.AddWithValue(INSERT_TRANSACTION_SP.YEAR_PARAM, transaction.getYear());
connection.Open();
try
{
insertCommand.ExecuteNonQuery();
}
catch (Exception es)
{
}
connection.Close();
int prevDues = transaction.getPaidBy().getDues();
transaction.getPaidBy().setDues(prevDues - transaction.getAmount());
apartment.updateFlatAt(transaction.getPaidBy());
transaction.getPaidBy().setDues(prevDues - transaction.getAmount());
view.updateFlat(transaction.getPaidBy().getFlatNumber());
sendEmail("*****@*****.**", view);
}
public Receipt(User user, Flat flat, Building apartment, string month, int year, MainScreen mainScreen, Income incomeView) // used for collection
{
InitializeComponent();
setValues(flat, month, year);
controller = new TransactionModule(Util.CONNECTION_DETAILS.CONNECITION_STRING, Util.Tables.TABLE_INCOMING_TRANSACTIONS.TABLE_NAME);
transaction = new IncomingTransaction(receiptTrID.Text, apartment, flat, (int)receiptAmount.Value, reciptDateTime.Value, user.getFlat(), month, year);
this.mainScreen = mainScreen;
this.apartment = apartment;
this.incomeView = incomeView;
}
virtual public void confirmTransaction(IncomingTransaction transaction, Building apartment, Income view)
{
}
