/// <summary> /// Fügt einen neuen Kassenabschluss der Datenbank hinzu /// </summary> /// <param name="cashClosureUserAccountID">Die UserAccount ID</param> /// <param name="closureDate">Datum des Kassenabschlusses</param> /// <param name="comment">Kommentar</param> /// <returns></returns> public static int Add(int cashClosureUserAccountID, DateTime closureDate, double revenue, double expense, string comment = null) { using (TafelModelContainer db = new TafelModelContainer()) { var cashClosure = new CashClosure { ClosureDate = closureDate, ClosureUserAccount = db.UserAccounts.Single(u => u.UserAccountID == cashClosureUserAccountID), Comment = comment, Sum = (revenue - expense), Expense = expense, Revenue = revenue }; db.CashClosures.AddObject(cashClosure); db.SaveChanges(); return cashClosure.CashClosureID; } }
/// <summary> /// Fügt einen neuen Kassenabschluss der Datenbank hinzu /// </summary> /// <param name="cashClosureUserAccountID">Die UserAccount ID</param> /// <param name="closureDate">Datum des Kassenabschlusses</param> /// <param name="comment">Kommentar</param> /// <returns></returns> public static int Add(int cashClosureUserAccountID, DateTime closureDate, double revenue, double expense, string comment = null) { using (TafelModelContainer db = new TafelModelContainer()) { var cashClosure = new CashClosure { ClosureDate = closureDate, ClosureUserAccount = db.UserAccounts.Single(u => u.UserAccountID == cashClosureUserAccountID), Comment = comment, Sum = (revenue - expense), Expense = expense, Revenue = revenue }; db.CashClosures.AddObject(cashClosure); db.SaveChanges(); return(cashClosure.CashClosureID); } }
/// <summary> /// Füllt die Felder aus /// Benötigt Kassenabschluss-Instanz und die zugehörigen Kassenabrechnung-Instanz und Kassenabschlussbeleg-Instanz /// </summary> /// <param name="cashClosure">Kassenabschluss-Instanz</param> /// <param name="cashClosureReport">Kassenabschlussbeleg-Instanz</param> /// <param name="cashClosureReceipt">Kassenabrechnung-Instanz</param> public CashClosureManagerDataGridModel(CashClosure cashClosure, CashClosureReport cashClosureReport, CashClosureReceipt cashClosureReceipt) { this.cashClosure = cashClosure; this.cashClosureReport = cashClosureReport; this.cashClosureReceipt = cashClosureReceipt; this.cashClosureID = cashClosure.CashClosureID; this.closureDate = SafeStringParser.safeParseToStr(cashClosure.ClosureDate, true); this.comment = SafeStringParser.safeParseToStr(cashClosure.Comment); this.revenues = SafeStringParser.safeParseToMoney(cashClosure.Revenue, true); this.expenses = SafeStringParser.safeParseToMoney(cashClosure.Expense, true); this.sum = SafeStringParser.safeParseToMoney(cashClosure.Sum, true); this.reportPrinted = cashClosureReport.PrintDone; this.reportPrintDate = SafeStringParser.safeParseToStr(cashClosureReport.PrintDate, true); this.reportDone = cashClosureReport.Done; this.reportDoneBoxEnabled = !(cashClosureReport.Done); this.reportDoneDate = SafeStringParser.safeParseToStr(cashClosureReport.DoneDate, true); this.receiptPrinted = cashClosureReceipt.PrintDone; this.receiptPrintedDate = SafeStringParser.safeParseToStr(cashClosureReceipt.PrintDate, true); if (cashClosure.ClosureUserAccount != null) this.closureUser = SafeStringParser.safeParseToStr(cashClosure.ClosureUserAccount.Username); else this.closureUser = ""; if (cashClosureReport.PrintUserAccount != null) this.reportPrintUser = SafeStringParser.safeParseToStr(cashClosureReport.PrintUserAccount.Username); else this.reportPrintUser = ""; if (cashClosureReport.DoneUserAccount != null) this.reportDoneUser = SafeStringParser.safeParseToStr(cashClosureReport.DoneUserAccount.Username); else this.reportDoneUser = ""; if (cashClosureReceipt.PrintUserAccount != null) this.receiptPrintedUser = SafeStringParser.safeParseToStr(cashClosureReceipt.PrintUserAccount.Username); else this.receiptPrintedUser = ""; }
/// <summary> /// Veraltete Methode zum Hinzufügen eines neuen Objekts zum EntitySet 'CashClosures'. Verwenden Sie stattdessen die Methode '.Add' der zugeordneten Eigenschaft 'ObjectSet<T>'. /// </summary> public void AddToCashClosures(CashClosure cashClosure) { base.AddObject("CashClosures", cashClosure); }
/// <summary> /// Erstellt ein neues CashClosure-Objekt. /// </summary> /// <param name="cashClosureID">Anfangswert der Eigenschaft CashClosureID.</param> /// <param name="closureDate">Anfangswert der Eigenschaft ClosureDate.</param> /// <param name="sum">Anfangswert der Eigenschaft Sum.</param> /// <param name="revenue">Anfangswert der Eigenschaft Revenue.</param> /// <param name="expense">Anfangswert der Eigenschaft Expense.</param> public static CashClosure CreateCashClosure(global::System.Int32 cashClosureID, global::System.DateTime closureDate, global::System.Double sum, global::System.Double revenue, global::System.Double expense) { CashClosure cashClosure = new CashClosure(); cashClosure.CashClosureID = cashClosureID; cashClosure.ClosureDate = closureDate; cashClosure.Sum = sum; cashClosure.Revenue = revenue; cashClosure.Expense = expense; return cashClosure; }