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()}");