// ISPLATI BANKA
public static string IsplatiBanka(int sumaUplata, int buildingNo, string ticketNo, string comment)
{
// DataTable
int numberApt = 0; int Income = 0; DateTime dateIncomeFor = DateTime.Now; DateTime dateNow = DateTime.Now;
string query = null;
transactions saldo = getSaldo(buildingNo);
try
{
conn.Open();
int vtor = 0;
float Isplata = 0;
string Kasa = "kasa";
query = string.Format("INSERT INTO transactions VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}' ,'{6}', '{7}' , '{8}' , '{9}' , '{10}' , '{11}', '{12}' , '{13}' , '{14}')", numberApt, buildingNo, Income, vtor, ticketNo, dateIncomeFor, dateNow, saldo.Budget, comment, vtor, vtor, Isplata, vtor, saldo.BudgetBank + saldo.Budget - sumaUplata, saldo.BudgetBank - sumaUplata);
command.CommandText = query; // int Stan, int Uplata , DateTimeOffset date ,int Building, string Komentar)
command.ExecuteNonQuery();
return("Успешна исплата од банка");
}
finally
{
conn.Close();
}
}
//get last numbers in db table.
public static transactions getSaldo(int buildingNo)
{
double Budget = 0.0;
double BankBudget = 0.0;
double AllBudget = 0.0;
transactions trans = new transactions();
string query1 = string.Format("SELECT * FROM transactions WHERE building = '{0}'", buildingNo);
try
{
conn.Open();
command.CommandText = query1;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Budget = reader.GetDouble(8);
BankBudget = reader.GetDouble(15);
AllBudget = reader.GetDouble(14);
}
}
finally
{
trans.Budget = Budget;
trans.BudgetBank = BankBudget;
conn.Close();
}
return(trans);
}