public decimal CalculateInterestEarned(DateTime processingDate)
{
var savingsDepositInterestRatePerAnnum = GlobalSettings.RateOfInterestOnSavingsDeposit;
var savingsDepositInterestEarnedPerAnnum = Amount * savingsDepositInterestRatePerAnnum;
var savingsDepositInterestEarnedPerDay = savingsDepositInterestEarnedPerAnnum /
CountDaysInBetweenDates(DateIn, DateIn.AddYears(1));
var timeDepositInterestEarnedPerAnnum = Amount * Rate;
var timeDepositInterestEarnedPerDay = timeDepositInterestEarnedPerAnnum /
CountDaysInBetweenDates(DateIn, DateIn.AddYears(1));
if (IsMature(processingDate))
{
// get days until maturity
var timeDepositDays = CountDaysInBetweenDates(DateIn, Maturity);
var timeDepositInterestEarned = timeDepositInterestEarnedPerDay * timeDepositDays;
// get days a day after maturity until processing date
var daysAfterMaturity = CountDaysInBetweenDates(Maturity.AddDays(1), processingDate);
if (daysAfterMaturity >= 1)
{
timeDepositInterestEarned += savingsDepositInterestEarnedPerDay * daysAfterMaturity;
}
return(Math.Round(timeDepositInterestEarned));
}
// premature
return(Math.Round(savingsDepositInterestEarnedPerDay * CountDaysInBetweenDates(DateIn, processingDate)));
}
public void Bind()
{
hfOKPO.Value = _OKPO;
int year = DateTime.Now.Year;
string y1 = year.ToString();
string y2 = (year - 1).ToString();
string DateStart = DateIn.ToString();
string DateEnd = DateTime.Now.ToString();
string queryGetTables = "select rdb$relation_name"
+ " from rdb$relations"
+ " where rdb$relation_name like 'PR" + y1 + "%' or rdb$relation_name like 'PR" + y2 + "%' order by rdb$relation_name asc ";
string queryGetPayment = string.Empty;
try
{
using (FbConnection fbCn = new FbConnection("Database=bank;Server=db4;User=SYSDBA;Password=masterkey;Role=All_rights_SVM;"))
{
FbCommand fbCmd = new FbCommand();
fbCn.Open();
fbCmd = new FbCommand(queryGetTables, fbCn);
FbDataReader dr = fbCmd.ExecuteReader();
int count = 0;
while (dr.Read())
{
if (count == 0)
{
queryGetPayment += string.Format(" select summa,date_plat from {0} where ROFILTR(NAZN, 'повер')=1 and OKPOKOR='{1}' and date_plat between '{2}' and '{3}'", dr[0].ToString().TrimEnd(), hfOKPO.Value, DateStart, DateEnd);
}
else
{
queryGetPayment += string.Format(" union select summa,date_plat from {0} where ROFILTR(NAZN, 'повер')=1 and OKPOKOR='{1}' and date_plat between '{2}' and '{3}'", dr[0].ToString().TrimEnd(), hfOKPO.Value, DateStart, DateEnd);
}
count++;
}
dr.Close();
fbCmd = new FbCommand(queryGetPayment, fbCn);
dr = fbCmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
dgPayment.DataSource = dt;
dgPayment.DataBind();
dr.Close();
dr.Dispose();
fbCn.Close();
}
}
catch (Exception ex)
{
}
}
public override string ToString()
{
string teacherString = string.Empty;
teacherString += $"{nameof(Teacher_ID)} = {Teacher_ID.ToString()}/n";
teacherString += $"{nameof(Username)} = {Username ?? "NULL"}/n";
teacherString += $"{nameof(Password)} = {Password ?? "NULL"}/n";
teacherString += $"{nameof(Name)} = {Name ?? "NULL"}/n";
teacherString += $"{nameof(Address)} = {Address ?? "NULL"}/n";
teacherString += $"{nameof(PhoneNumber)} = {PhoneNumber ?? "NULL"}/n";
teacherString += $"{nameof(Permission)} = {Permission ?? "NULL"}/n";
teacherString += $"{nameof(Status)} = {Status ?? "NULL"}/n";
teacherString += $"{nameof(DateIn)} = {((DateIn == null) ? DateIn.ToLongDateString() : "NULL")}/n";
teacherString += $"{nameof(DateOut)} = {((DateOut == null) ? DateOut.Value.ToLongDateString() : "NULL")}/n";
return(teacherString);
}
//változott
public void Print()
{
Console.WriteLine("ID: " + ID);
Console.WriteLine("Tervezett beérkezés: " + DateIn.ToShortDateString());
Console.WriteLine("Tervezett kivitel: " + DateOut.ToShortDateString());
Console.WriteLine("Megrendelés leadva: " + OrderTime.ToString());
Console.WriteLine("Mennyiség: " + PalletQuantity);
if (Comment != "")
{
Console.WriteLine("Megjegyzés: " + Comment);
}
if (Cooled)
{
Console.WriteLine("Hűtött: igen");
}
else
{
Console.WriteLine("Hűtött:nem");
}
if (Confirmed)
{
Console.WriteLine("Jóváhagyott: igen ");
}
else
{
Console.WriteLine("Jóváhagyott: nem ");
}
if (Terminal != 0)
{
Console.WriteLine("Kocsiszín: " + Terminal);
}
Console.WriteLine();
if (FirstOccupiedPlace > 0 && LastOccupiedPlace > 0)
{
if (Cooled)
{
Console.WriteLine("H" + FirstOccupiedPlace + ":H" + LastOccupiedPlace);
}
else
{
Console.WriteLine("S" + FirstOccupiedPlace + ":S" + LastOccupiedPlace);
}
}
Console.WriteLine();
}
public override string ToString() =>
string.Format($"Book\n{Room.ToString()},\n{Customer.ToString()},\n@{DateIn.ToString()}-{DateOut.ToString()}");
