public ActionResult Insert(MAccount viewModel, FormCollection formCollection) { MAccount mCompanyToInsert = new MAccount(); TransferFormValuesTo(mCompanyToInsert, viewModel); mCompanyToInsert.AccountParentId = _mAccountRepository.Get(formCollection["ParentId"]); mCompanyToInsert.SetAssignedIdTo(viewModel.Id); mCompanyToInsert.CreatedDate = DateTime.Now; mCompanyToInsert.CreatedBy = User.Identity.Name; mCompanyToInsert.DataStatus = EnumDataStatus.New.ToString(); _mAccountRepository.Save(mCompanyToInsert); try { _mAccountRepository.DbContext.CommitChanges(); } catch (Exception e) { _mAccountRepository.DbContext.RollbackTransaction(); //throw e.GetBaseException(); return(Content(e.GetBaseException().Message)); } return(Content("success")); }
public static MAccount AddAccount(MAccount account) { using (var db = DbConnection) { db.TraceListener = new DebugTraceListener(); object[] parameters = { account.Name, account.ColorKey, DateTimeHelper.DateTimeUtcNowString, false, account.GlobalId ?? (Dal.GetMaxRowId(typeof(MAccount)) + 1).NewGlobalIdFromLocal(),//SyncProperties.GetGlobalId(typeof(MAccount)), (account as SubMAccount)?.BossAccountGlobalId }; db.Execute( "INSERT INTO " + typeof(MAccount).Name + " (Name, ColorKey, LastModifed, IsDeleted, GlobalId, BossAccountGlobalId) VALUES(?,?,?,?,?,?)" , parameters); account.LastModifed = parameters[2] as string; account.GlobalId = parameters[4] as string; if (account is SubMAccount) { ((SubMAccount)account).BossAccountGlobalId = parameters[5] as string; } return(account); } }
} // copyGL /// <summary> /// Copy Default /// </summary> /// <param name="targetAS">target</param> private void CopyDefault(MAcctSchema targetAS) { MAcctSchemaDefault source = MAcctSchemaDefault.Get(GetCtx(), _SourceAcctSchema_ID); MAcctSchemaDefault target = new MAcctSchemaDefault(GetCtx(), 0, Get_Trx()); target.SetC_AcctSchema_ID(_TargetAcctSchema_ID); target.SetC_AcctSchema_ID(_TargetAcctSchema_ID); //ArrayList<KeyNamePair> list = source.getAcctInfo(); List <KeyNamePair> list = source.GetAcctInfo(); for (int i = 0; i < list.Count; i++) { //KeyNamePair pp = list.get(i); KeyNamePair pp = list[i]; int sourceC_ValidCombination_ID = pp.GetKey(); String columnName = pp.GetName(); MAccount sourceAccount = MAccount.Get(GetCtx(), sourceC_ValidCombination_ID); MAccount targetAccount = CreateAccount(targetAS, sourceAccount); target.SetValue(columnName, Utility.Util.GetValueOfInt(targetAccount.GetC_ValidCombination_ID())); } if (!target.Save()) { throw new Exception("Could not Save Default"); } } // copyDefault
private static MAccount GetDefaultAccount(EnumReferenceType referenceType) { IMAccountRepository mAccountRepository = new MAccountRepository(); MAccount account = mAccountRepository.Get(Helper.CommonHelper.GetReference(referenceType).ReferenceValue); return(account); }
public async Task<IActionResult> Edit(long id, [Bind("AccountSeq,AccountType,Id,Pass,DatabaseName,UpdateDt,UpdateId,UpdateTer,CreateDt,CreateId,CreateTer,ConfigurationManagementSeq")] MAccount mAccount) { if (id != mAccount.AccountSeq) { return NotFound(); } if (ModelState.IsValid) { try { _context.Update(mAccount); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MAccountExists(mAccount.AccountSeq)) { return NotFound(); } else { throw; } } return RedirectToAction(nameof(Index)); } return View(mAccount); }
/// <summary> /// 账户花销(包含写帐户日志) /// </summary> /// <param name="orderId"></param> /// <returns></returns> public bool AccountExpend(decimal orderId, string ip) { Bll.Order.TOrderBLL obll = new TMM.Service.Bll.Order.TOrderBLL(); Bll.Order.AccountLogBLL albll = new TMM.Service.Bll.Order.AccountLogBLL(); TOrder o = obll.Get(orderId); MAccount acc = GetByUserId(o.UserId); if (acc.Amount >= o.Total) { AccountLog accLog = new AccountLog() { UserId = o.UserId, OrderId = o.OrderId, Amount = -o.Total, AccountWay = (int)AmountWay.Out, Ip = ip }; albll.Insert(accLog); acc.Amount = acc.Amount - o.Total; return(Update(acc)); } return(false); }
/// <summary> /// 账户充值 for 出售文档收入 /// </summary> /// <param name="userId"></param> /// <param name="amount"></param> /// <returns></returns> public bool AddAmount(int userId, decimal amount) { MAccount acc = GetByUserId(userId); acc.Amount = acc.Amount + amount; return(Update(acc)); }
/// <summary> /// Load Invoice Line /// </summary> /// <param name="journal"></param> /// <returns>DocLine Array</returns> private DocLine[] LoadLines(MJournal journal) { List <DocLine> list = new List <DocLine>(); MJournalLine[] lines = journal.GetLines(false); for (int i = 0; i < lines.Length; i++) { MJournalLine line = lines[i]; DocLine docLine = new DocLine(line, this); // -- Source Amounts docLine.SetAmount(line.GetAmtSourceDr(), line.GetAmtSourceCr()); // -- Converted Amounts docLine.SetConvertedAmt(_C_AcctSchema_ID, line.GetAmtAcctDr(), line.GetAmtAcctCr()); // -- Account MAccount account = line.GetAccount(); docLine.SetAccount(account); // -- Quantity docLine.SetQty(line.GetQty(), false); // -- Date docLine.SetDateAcct(journal.GetDateAcct()); // -- Organization of Line was set to Org of Account list.Add(docLine); } // Return Array int size = list.Count; DocLine[] dls = new DocLine[size]; dls = list.ToArray(); return(dls); }
private async void EditButton_Click(object sender, RoutedEventArgs e) { object datacontext = (e.OriginalSource as FrameworkElement)?.DataContext; MAccountWithSubMAccounts oldAccound = ((MAccountWithSubMAccounts)datacontext); EditMAccountContentDialog editMoneyAccountContentDialog = new EditMAccountContentDialog(oldAccound?.MAccount); ContentDialogResult result = await editMoneyAccountContentDialog.ShowAsync(); if (result != ContentDialogResult.Primary) { return; } MAccount editedAccound = editMoneyAccountContentDialog.EditedAccount; if (editedAccound is SubMAccount) { AccountToSubAccount(oldAccound, editedAccound as SubMAccount); } else { AccountToAccount(oldAccound, editedAccound); } /* * int index = Accounts.IndexOf(oldAccound); //TODO gdyby edytować z karty na konto i na odwró * Accounts.Remove(oldAccound); * oldAccound.MAccount = editedAccound; * Accounts.Insert(index, oldAccound);*/ }
private async void NewMoneyAccount_Click(object sender, RoutedEventArgs e) { var contentDialogItem = new NewMoneyAccountContentDialog(); var result = await contentDialogItem.ShowAsync(); if (result != ContentDialogResult.Primary) { return; } MAccount newAccount = contentDialogItem.AddedAccount; //TODO Id i GlobalID bo są 0 albo null if (newAccount is SubMAccount) { MAccountWithSubMAccounts mAccountWithSubMAccounts = Accounts.SingleOrDefault(i => i.MAccount.GlobalId == ((SubMAccount)newAccount).BossAccountGlobalId); mAccountWithSubMAccounts?.SubMAccounts.Insert(0, (SubMAccount)newAccount); //TODO wali NULLem jeżeli kontoi nie ma podkategorii } else { Accounts.Insert(0, new MAccountWithSubMAccounts { MAccount = newAccount }); } }
/// <summary> /// Create and convert Fact Line. /// Used to create a DR and/or CR entry /// </summary> /// <param name="docLine">the document line or null</param> /// <param name="account">if null, line is not created</param> /// <param name="C_Currency_ID">the currency</param> /// <param name="debitAmt">debit amount, can be null</param> /// <param name="creditAmt">credit amount, can be null</param> /// <returns>Fact Line</returns> public FactLine CreateLine(DocLine docLine, MAccount account, int C_Currency_ID, Decimal?debitAmt, Decimal?creditAmt) { // Data Check if (account == null) { log.Info("No account for " + docLine + ": Amt=" + debitAmt + "/" + creditAmt + " - " + ToString()); return(null); } //Added By Bharat to Handle -ve entry if (debitAmt < 0) { creditAmt = Decimal.Negate(debitAmt.Value); debitAmt = 0; } else if (creditAmt < 0) { debitAmt = Decimal.Negate(creditAmt.Value); creditAmt = 0; } // FactLine line = new FactLine(_doc.GetCtx(), _doc.Get_Table_ID(), _doc.Get_ID(), docLine == null ? 0 : docLine.Get_ID(), _trx); // set accounting schema reference line.SetC_AcctSchema_ID(_acctSchema.GetC_AcctSchema_ID()); // Set Info & Account line.SetDocumentInfo(_doc, docLine); line.SetPostingType(_postingType); line.SetAccount(_acctSchema, account); // Amounts - one needs to not zero if (!line.SetAmtSource(C_Currency_ID, debitAmt, creditAmt)) { if (docLine == null || docLine.GetQty() == null || Env.Signum(Utility.Util.GetValueOfDecimal(docLine.GetQty())) == 0) { log.Fine("Both amounts & qty = 0/Null - " + docLine + " - " + ToString()); return(null); } log.Fine("Both amounts = 0/Null, Qty=" + docLine.GetQty() + " - " + docLine + " - " + ToString()); } // Convert line.Convert(); // Optionally overwrite Acct Amount if (docLine != null && (docLine.GetAmtAcctDr() != null || docLine.GetAmtAcctCr() != null)) { line.SetAmtAcct(docLine.GetAmtAcctDr(), docLine.GetAmtAcctCr()); } // log.Fine(line.ToString()); Add(line); return(line); }
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (!ValidateForm()) { return; } if (accountIdTextBox.Enabled == true) { acc = new MAccount(); } else { acc = (MAccount)DataMaster.GetObjectByProperty(typeof(MAccount), MAccount.ColumnNames.AccountId, accountIdTextBox.Text); } acc.AccountDesc = accountDescTextBox.Text; acc.AccountId = accountIdTextBox.Text; acc.AccountName = accountNameTextBox.Text; //acc.AccountSaldo = accountSaldoNumericUpDown.Value; acc.AccountPosition = accountPositionComboBox.Text; if (accountStatusDebetRadioButton.Checked) { acc.AccountStatus = ListOfJournalStatus.Debet.ToString(); } if (accountStatusKreditRadioButton.Checked) { acc.AccountStatus = ListOfJournalStatus.Kredit.ToString(); } acc.ModifiedBy = lbl_UserName.Text; acc.ModifiedDate = DateTime.Now; if (accountIdTextBox.Enabled == true) { try { DataMaster.SavePersistence(acc); } catch (NHibernate.NonUniqueObjectException) { RecreateBalloon(); balloonHelp.Caption = "Validasi data kurang"; balloonHelp.Content = "POS Neraca dengan kode " + accountIdTextBox.Text + " sudah pernah diinput, silahkan input dengan kode yang lain"; balloonHelp.ShowBalloon(accountIdTextBox); accountIdTextBox.Focus(); return; } ModuleControlSettings.SaveLog(ListOfAction.Insert, accountIdTextBox.Text, ListOfTable.MAccount, lbl_UserName.Text); } else { DataMaster.UpdatePersistence(acc); ModuleControlSettings.SaveLog(ListOfAction.Update, accountIdTextBox.Text, ListOfTable.MAccount, lbl_UserName.Text); } BindData(); }
private void TransferFormValuesTo(MAccount mCompanyToUpdate, MAccount mCompanyFromForm) { mCompanyToUpdate.AccountName = mCompanyFromForm.AccountName; mCompanyToUpdate.AccountDesc = mCompanyFromForm.AccountDesc; mCompanyToUpdate.AccountCatId = mCompanyFromForm.AccountCatId; mCompanyToUpdate.AccountParentId = mCompanyFromForm.AccountParentId; mCompanyToUpdate.AccountStatus = mCompanyFromForm.AccountStatus; }
/// <summary> /// Allocation Tax Adjustmentdiscount acct /// </summary> /// <param name="DiscountAccount">DiscountAccount </param> /// <param name="DiscountAmt">discount amt</param> /// <param name="WriteOffAccount">write off acct</param> /// <param name="WriteOffAmt">write off amt</param> public Doc_AllocationTax(MAccount DiscountAccount, Decimal DiscountAmt, MAccount WriteOffAccount, Decimal WriteOffAmt) { log = VLogger.GetVLogger(this.GetType().FullName);//getClass()); _DiscountAccount = DiscountAccount; _DiscountAmt = DiscountAmt; _WriteOffAccount = WriteOffAccount; _WriteOffAmt = WriteOffAmt; }
private async void NewCategory_AddButtonClick(ContentDialog sender, ContentDialogButtonClickEventArgs args) { AddedAccount = MAccountsDal.AddAccount(GetNewAccount()); if (!string.IsNullOrEmpty(_acceptedCostValue)) { Dal.SaveOperation(await MakeOperation(AddedAccount.GlobalId)); } }
/// <summary> /// Is used to create line against Income Account summary account -- /// </summary> /// <param name="Profit">class object of MProfitLoss </param> private void InsertProfitLossLine(MProfitLoss Profit) { // get consolidated profit amount agsint Organization String Sql = @"SELECT AD_Org_ID , (SUM(AccountDebit) - SUM(AccountCredit)) AS ProfitAmt FROM C_ProfitLossLines WHERE C_ProfitAndLoss_ID > 0 AND C_ProfitLoss_ID = " + Profit.GetC_ProfitLoss_ID() + @" GROUP BY AD_Org_ID"; DataSet dsProfit = DB.ExecuteDataset(Sql, null, Get_Trx()); if (dsProfit != null && dsProfit.Tables.Count > 0 && dsProfit.Tables[0].Rows.Count > 0) { // get max line no int lineNo = Convert.ToInt32(DB.ExecuteScalar(@"SELECT NVL(MAX(Line),0)+10 AS line FROM C_ProfitLossLines WHERE C_ProfitLoss_ID = " + Profit.GetC_ProfitLoss_ID(), null, Get_Trx())); // get Valid Combination against Income Summary Acct from accounting schema int validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT IncomeSummary_Acct FROM C_AcctSchema_GL WHERE C_AcctSchema_ID=" + Util.GetValueOfInt(Profit.Get_Value("C_AcctSchema_ID")))); // get account id MAccount acct = MAccount.Get(GetCtx(), validComID); for (int i = 0; i < dsProfit.Tables[0].Rows.Count; i++) { Decimal profitAmt = Util.GetValueOfDecimal(dsProfit.Tables[0].Rows[i]["ProfitAmt"]); // when difference of DR - CR is ZERO then not to create line if (profitAmt == 0) { continue; } MProfitLossLines profitLossLines = new MProfitLossLines(GetCtx(), 0, Get_Trx()); profitLossLines.SetAD_Client_ID(Profit.GetAD_Client_ID()); profitLossLines.SetAD_Org_ID(Util.GetValueOfInt(dsProfit.Tables[0].Rows[i]["AD_Org_ID"])); profitLossLines.SetC_ProfitLoss_ID(Profit.GetC_ProfitLoss_ID()); profitLossLines.SetLine(lineNo); profitLossLines.SetC_AcctSchema_ID(Util.GetValueOfInt(Profit.Get_Value("C_AcctSchema_ID"))); profitLossLines.SetPostingType(Util.GetValueOfString(Profit.Get_Value("PostingType"))); profitLossLines.SetAccount_ID(acct.GetAccount_ID()); profitLossLines.Set_Value("LedgerCode", acct.GetAccount().Get_Value("Value")); profitLossLines.Set_Value("LedgerName", acct.GetAccount().Get_Value("Name")); if (profitAmt > 0) { profitLossLines.SetAccountCredit(profitAmt); } else { profitLossLines.SetAccountDebit(profitAmt); } if (!profitLossLines.Save(Get_Trx())) { ValueNamePair pp = VLogger.RetrieveError(); log.Fine("Failed - Profit loss line not saved for income acct summary - " + (pp != null && !String.IsNullOrEmpty(pp.GetName()) ? pp.GetName() : "")); } else { lineNo += 10; } } } }
public async Task<IActionResult> Create([Bind("AccountSeq,AccountType,Id,Pass,DatabaseName,UpdateDt,UpdateId,UpdateTer,CreateDt,CreateId,CreateTer,ConfigurationManagementSeq")] MAccount mAccount) { if (ModelState.IsValid) { _context.Add(mAccount); await _context.SaveChangesAsync(); return RedirectToAction(nameof(Index)); } return View(mAccount); }
/// <summary> /// 插入数据 /// </summary> /// <param name="obj">对象</param> /// <returns>返回:该条数据的主键Id</returns> public int Insert(MAccount obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "MAccount.Insert"; return(SqlMapper.Instance().QueryForObject <int>(stmtId, obj)); }
private void bindingSource_Master_PositionChanged(object sender, EventArgs e) { SetNavigatorDisplay(); acc = (MAccount)DataMaster.GetObjectByProperty(typeof(MAccount), MAccount.ColumnNames.AccountId, accountIdTextBox.Text); if (acc != null) { accountStatusDebetRadioButton.Checked = (acc.AccountStatus == ListOfJournalStatus.Debet.ToString()); accountStatusKreditRadioButton.Checked = (acc.AccountStatus == ListOfJournalStatus.Kredit.ToString()); } }
private void SubAccountToAccount(SubMAccount oldSubMAccount, MAccount newMAccount) { var accountWithSubMAccounts = Accounts.FirstOrDefault(i => i.SubMAccounts.Contains(oldSubMAccount)); accountWithSubMAccounts.SubMAccounts.Remove(oldSubMAccount); Accounts.Insert(0, new MAccountWithSubMAccounts { MAccount = newMAccount }); }
/// <summary> /// Create Facts (the accounting logic) for /// CMC. /// <pre> /// Expense /// CashExpense DR /// CashAsset CR ///Receipt /// CashAsset DR /// CashReceipt CR /// Charge /// Charge DR /// CashAsset CR /// Difference /// CashDifference DR /// CashAsset CR /// Invoice /// CashAsset DR /// CashTransfer CR /// Transfer /// BankInTransit DR /// CashAsset CR /// </pre> /// </summary> /// <param name="?"></param> /// <returns>Fact</returns> public override List <Fact> CreateFacts(MAcctSchema as1) { // create Fact Header List <Fact> facts = new List <Fact>(); if (GetDocumentType().Equals(MDocBaseType.DOCBASETYPE_PROFITLOSS)) { // Decimal grossAmt = getAmount(Doc.AMTTYPE_Gross); SetC_Currency_ID(GetCurrency(as1.GetC_AcctSchema_ID())); // Commitment Fact fact = new Fact(this, as1, Fact.POST_Actual); Decimal total = Env.ZERO, totalCredit = Env.ZERO, totalDebit = Env.ZERO; Decimal credit = Env.ZERO, debit = Env.ZERO; for (int i = 0; i < _lines.Length; i++) { DocLine dline = _lines[i]; MProfitLossLines line = new MProfitLossLines(GetCtx(), dline.Get_ID(), null); credit = Util.GetValueOfDecimal(dline.GetAmtAcctCr()); debit = Util.GetValueOfDecimal(dline.GetAmtAcctDr()); if (credit > 0) { totalCredit = Decimal.Add(totalCredit, credit); } if (debit > 0) { totalDebit = Decimal.Add(totalDebit, debit); } // Account MAccount expense = MAccount.Get(GetCtx(), GetAD_Client_ID(), GetAD_Org_ID(), line.GetC_AcctSchema_ID(), line.GetAccount_ID(), line.GetC_SubAcct_ID(), line.GetM_Product_ID(), line.GetC_BPartner_ID(), line.GetAD_OrgTrx_ID(), line.GetC_LocFrom_ID(), line.GetC_LocTo_ID(), line.GetC_SalesRegion_ID(), line.GetC_Project_ID(), line.GetC_Campaign_ID(), line.GetC_Activity_ID(), line.GetUser1_ID(), line.GetUser2_ID(), line.GetUserElement1_ID(), line.GetUserElement2_ID()); fact.CreateLine(dline, expense, GetCurrency(line.GetC_AcctSchema_ID()), debit, credit); } total = totalCredit - totalDebit; if (total != Env.ZERO) { int validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT IncomeSummary_Acct FROM C_AcctSchema_GL WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND AD_Client_ID = " + GetAD_Client_ID())); MAccount acct = MAccount.Get(GetCtx(), validComID); fact.CreateLine(null, acct, GetC_Currency_ID(), total); } //if (TotalCurrLoss != Env.ZERO) //{ // int validComID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT C_ValidCombination_ID FROM C_ValidCombination WHERE Account_ID= ( SELECT C_ElementValue_ID FROM C_ElementValue WHERE Value='82540' AND AD_Client_ID = " + GetAD_Client_ID() + " )")); // MAccount acct = MAccount.Get(GetCtx(), validComID); // TotalCurrLoss = MConversionRate.Convert(GetCtx(), TotalCurrLoss, childCashCurrency, headerCashCurrency, GetAD_Client_ID(), GetAD_Org_ID()); // fact.CreateLine(null, acct, // GetC_Currency_ID(), (TotalCurrLoss)); //} facts.Add(fact); } return(facts); }
/// <summary> /// 更新数据 /// </summary> /// <param name="obj"></param> /// <returns>返回:ture 成功,false 失败</returns> public bool Update(MAccount obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "MAccount.Update"; int result = SqlMapper.Instance().QueryForObject <int>(stmtId, obj); return(result > 0 ? true : false); }
/// <summary> /// Create and convert Fact Line. /// Used to create either a DR or CR entry /// </summary> /// <param name="docLine">Document line or null</param> /// <param name="account">Account to be used</param> /// <param name="C_Currency_ID">Currency</param> /// <param name="Amt">if negative Cr else Dr</param> /// <param name ="AD_Org_ID">Set Line Org</param> /// <returns>FactLine</returns> public FactLine CreateLine(DocLine docLine, MAccount account, int C_Currency_ID, Decimal?Amt, int AD_Org_ID) { if (Env.Signum(Amt.Value) < 0) { return(CreateLine(docLine, account, C_Currency_ID, null, Math.Abs(Amt.Value), AD_Org_ID)); } else { return(CreateLine(docLine, account, C_Currency_ID, Amt.Value, null, AD_Org_ID)); } }
/// <summary> /// 验证用户信息(登录) /// </summary> /// <param name="mAccount">用户信息</param> public static void ValdateLoginMAccount(MAccount mAccount) { if (mAccount == null) { throw new CustomException("帐号不存在"); } if (mAccount.Status == Model.AccountStatus.Disable) { throw new CustomException("帐号已被禁用"); } }
public static SelectList GetAccounts(IMAccountRepository mAccountRepository, string defaultText) { IList <MAccount> listAcc = mAccountRepository.GetAll(); if (!string.IsNullOrEmpty(defaultText)) { MAccount account = new MAccount(); account.AccountName = defaultText; listAcc.Insert(0, account); } return(new SelectList(listAcc, "Id", "AccountName")); }
private void SaveJournal(string subAccountId, ListOfJournalStatus listOfJournalStatus) { TJournal jur = new TJournal(); MSubAccount sub = (MSubAccount)DataMaster.GetObjectByProperty(typeof(MSubAccount), MSubAccount.ColumnNames.SubAccountId, subAccountId); MAccount acc = new MAccount(); if (sub != null) { acc = (MAccount)DataMaster.GetObjectByProperty(typeof(MAccount), MAccount.ColumnNames.AccountId, sub.AccountId); if (acc == null) { acc = new MAccount(); } } else { sub = new MSubAccount(); } if (acc.AccountStatus == listOfJournalStatus.ToString()) { jur.AccountSaldo = acc.AccountSaldo + GrandTotalNumericUpDown.Value; jur.SubAccontSaldo = sub.SubAccountSaldo + GrandTotalNumericUpDown.Value; } else { jur.AccountSaldo = acc.AccountSaldo - GrandTotalNumericUpDown.Value; jur.SubAccontSaldo = sub.SubAccountSaldo - GrandTotalNumericUpDown.Value; } jur.JournalDate = DateTime.Now; jur.JournalDesc = namaTransaksi + transactionFacturTextBox.Text; jur.JournalJumlah = GrandTotalNumericUpDown.Value; jur.JournalPic = transactionByTextBox.Text; jur.JournalStatus = listOfJournalStatus.ToString(); jur.SubAccountId = subAccountId; jur.ModifiedBy = lbl_UserName.Text; jur.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(jur); //update saldo sub account sub.SubAccountSaldo = jur.SubAccontSaldo; sub.ModifiedBy = lbl_UserName.Text; sub.ModifiedDate = DateTime.Now; DataMaster.UpdatePersistence(sub); //update saldo account acc.AccountSaldo = jur.AccountSaldo; acc.ModifiedBy = lbl_UserName.Text; acc.ModifiedDate = DateTime.Now; DataMaster.UpdatePersistence(acc); }
/* * private async void ShowDeleteCardContentDialog(SubMAccount account) { * AcceptContentDialog acceptDeleteOperationContentDialog = new AcceptContentDialog("Czy chcesz usunąć kartę płatniczą? Zostaną usunięte wszystkie operacje skojażone z tą kartą."); * ContentDialogResult result = await acceptDeleteOperationContentDialog.ShowAsync(); * if (result == ContentDialogResult.Primary) * DeleteAccountWithOperations(account); * } */ private void DeleteAccountWithOperations(MAccount account) { if (account is SubMAccount) { DeleteCardWithOperations((SubMAccount)account); } else { Accounts.Remove(Accounts.SingleOrDefault(i => i.MAccount.Id == account.Id));// /Remove(account); } MAccountsDal.RemoveAccountWithSubAccountsAndOperations(account); }
public BalanceAccountContentDialog(MAccount account) { InitializeComponent(); _account = account; _actualMoneyValue = _account.ActualMoneyValueDecimal; if (account is SubMAccount) { ParentAccountNameTextBlock.Visibility = Visibility.Visible; ParentAccountNameTextBlock.Text = ((SubMAccount)account).ParentAccount.Name; } }
/// <summary> /// Save account /// </summary> /// <param name="ctx"></param> /// <param name="AD_Client_ID"></param> /// <param name="AD_Org_ID"></param> /// <param name="C_AcctSchema_ID"></param> /// <param name="AD_Account_ID"></param> /// <param name="C_SubAcct_ID"></param> /// <param name="M_Product_ID"></param> /// <param name="C_BPartner_ID"></param> /// <param name="AD_OrgTrx_ID"></param> /// <param name="C_LocFrom_ID"></param> /// <param name="C_LocTo_ID"></param> /// <param name="C_SRegion_ID"></param> /// <param name="C_Project_ID"></param> /// <param name="C_Campaign_ID"></param> /// <param name="C_Activity_ID"></param> /// <param name="User1_ID"></param> /// <param name="User2_ID"></param> /// <param name="Alias"></param> /// <returns></returns> public AccountingObjects SaveAccount(Ctx ctx, int AD_Client_ID, int AD_Org_ID, int C_AcctSchema_ID, int AD_Account_ID, int C_SubAcct_ID, int M_Product_ID, int C_BPartner_ID, int AD_OrgTrx_ID, int C_LocFrom_ID, int C_LocTo_ID, int C_SRegion_ID, int C_Project_ID, int C_Campaign_ID, int C_Activity_ID, int User1_ID, int User2_ID, string Alias) { AccountingObjects obj = new AccountingObjects(); MAccount acct = MAccount.Get(ctx, AD_Client_ID, AD_Org_ID, C_AcctSchema_ID, AD_Account_ID, C_SubAcct_ID, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID, C_LocTo_ID, C_SRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, 0, 0); if (acct != null && acct.Get_ID() == 0) { acct.Save(); } // Show Info if (acct == null || acct.Get_ID() == 0) { obj = LoadInfo(0, 0); } else { // Update Account with optional Alias bool found = false; if (Alias.Length > 0) { String sql1 = "SELECT COUNT(*) FROM C_ValidCombination WHERE Alias='" + Alias + "'"; int ii = DB.GetSQLValue(null, sql1); if (ii != 0) { found = true; } else { acct.SetAlias(Alias); acct.Save(); } } if (found) { obj.ErrorMsg = "DuplicateAlias"; } else { //obj = LoadInfo(acct.Get_ID(), C_AcctSchema_ID); obj.C_ValidCombination_ID = acct.Get_ID(); obj.C_AcctSchema_ID = C_AcctSchema_ID; } } return(obj); }
private void AccountToAccount(MAccountWithSubMAccounts oldAccount, MAccount newAccount) { // var accountWithSubMAccounts = Accounts.FirstOrDefault(i => Equals(i.MAccount, oldAccount.MAccount)); // accountWithSubMAccounts.MAccount = newAccount; int index = Accounts.IndexOf(oldAccount); var accountWithSubMAccounts = Accounts.ElementAt(index); accountWithSubMAccounts.MAccount = newAccount; Accounts.RemoveAt(index); Accounts.Insert(index, accountWithSubMAccounts); }