public GeneralDepositLedgerView()
{
InitializeComponent();
data = new GeneralLedger();
generalDepositLedger.ItemsSource = data.GetDataLedger(0, 0);
DataContext = data;
}
private GeneralLedger MapToEntity(GeneralLedgerView inputObject)
{
Mapper mapper = new Mapper();
GeneralLedger outObject = mapper.Map <GeneralLedger>(inputObject);
return(outObject);
}
public GeneralDepositView()
{
InitializeComponent();
GDListObj = new GeneralDepositListView();
memberData.Navigate(GDListObj);
DataContext = new GeneralLedger();
}
public void SetForEdit(string m_id)
{
int id = Convert.ToInt32(m_id);
data = new GeneralLedger();
data.GetDataDetails(id);
DataContext = data;
}
public GeneralDepositListView()
{
InitializeComponent();
GeneralLedger data = new GeneralLedger();
generalDepositlist.ItemsSource = data.GetDataList();
DataContext = data;
}
public TransactionImportContext(GeneralLedger general, IEnumerable<AccountIdentifier> patterns, IImportRepository repository)
{
_general = general;
_repository = repository;
_patterns = patterns.ToArray();
Array.ForEach(_patterns, p => p.Account = general[p.Account.Id]);
}
public void ActivateGeneralLedger(GeneralLedger generalLedger)
{
var command = new ActivateGeneralLedgerCommand
{
GeneralLedger = generalLedger
};
processXml.Process(command.ToXml());
}
private string GenerateCustomRefNo(GeneralLedger item)
{
var referenceNo = new StringBuilder();
referenceNo.Append($"{m_applicationName.ToUpper()}-");
referenceNo.Append(DateTime.Now.ToString("ddMMyy-ss-"));
referenceNo.Append((item.Id.Split('-'))[1]);
return(referenceNo.ToString());
}
void UpdateGeneralLedger(PurchaseModel purchaseModel, int purchaseId, int APKey)
{
GeneralLedger generalLedger = new GeneralLedger
{
SubsidiaryLedgerAccountId = purchaseModel.Vendor.Value,
GeneralLedgerReferenceNo = purchaseModel.ReferenceNo,
GeneralLedgerInvoiceNo = "",
GeneralLedgerDate = purchaseModel.Date,
GeneralLedgerType = "PUR",
PurchaseId = purchaseId
};
_serverContext.GeneralLedgers.Add(generalLedger);
_serverContext.SaveChanges();
//var invoiceDetail = customerInvoiceModel.Items.GroupBy(x => x.SalesItem.Value).Select(g => new { Id = g.Key, Value = g.Sum(s => Convert.ToDecimal(s.Amount)) });
foreach (PurchaseItemModel item in purchaseModel.Items)
{
GeneralLedgerDetail generalLedgerDetail = new GeneralLedgerDetail();
//var temp = _serverContext.Inventories.Where(x => x.Id == item.SalesItem.Value).FirstOrDefault();
//generalLedgerDetail.ChartOfAccountId = Convert.ToInt32(temp.InventoryProductServiceIncomeAccountId);
generalLedgerDetail.ChartOfAccountId = item.ChartOfAccountItem.Value;
generalLedgerDetail.GeneralLedgerDetailMode = "D";
generalLedgerDetail.GeneralLedgerId = generalLedger.Id;
generalLedgerDetail.GeneralLedgerDetailAmount = Convert.ToDecimal(item.Amount);
generalLedgerDetail.GeneralLedgerDetailDescription = item.Description;
_serverContext.GeneralLedgerDetails.Add(generalLedgerDetail);
_serverContext.SaveChanges();
}
if (purchaseModel.TotalTaxes > 0)
{
GeneralLedgerDetail generalLedgerDetail = new GeneralLedgerDetail();
generalLedgerDetail.ChartOfAccountId = SalesTaxKey;
generalLedgerDetail.GeneralLedgerDetailMode = "D";
generalLedgerDetail.GeneralLedgerId = generalLedger.Id;
generalLedgerDetail.GeneralLedgerDetailAmount = purchaseModel.TotalTaxes;
generalLedgerDetail.GeneralLedgerDetailDescription = "";
_serverContext.GeneralLedgerDetails.Add(generalLedgerDetail);
_serverContext.SaveChanges();
}
var APAmount = purchaseModel.Amount;
GeneralLedgerDetail APGeneralLedgerDetail = new GeneralLedgerDetail();
APGeneralLedgerDetail.GeneralLedgerId = generalLedger.Id;
APGeneralLedgerDetail.GeneralLedgerDetailDescription = "";
APGeneralLedgerDetail.ChartOfAccountId = purchaseModel.ModeOfPayment == "PY" ? APKey : (int)purchaseModel.ChartOfAccounts.Value;
APGeneralLedgerDetail.GeneralLedgerDetailMode = "C";
APGeneralLedgerDetail.GeneralLedgerId = generalLedger.Id;
APGeneralLedgerDetail.GeneralLedgerDetailAmount = APAmount;
_serverContext.GeneralLedgerDetails.Add(APGeneralLedgerDetail);
_serverContext.SaveChanges();
}
public async Task TestAddUpdatDelete()
{
SupplierLedgerModule SupplierLedgerMod = new SupplierLedgerModule();
Supplier supplier = await SupplierLedgerMod.Supplier.Query().GetEntityById(3);
Invoice invoice = await SupplierLedgerMod.Invoice.Query().GetEntityById(2);
AccountPayable accountPayable = await SupplierLedgerMod.AccountPayable.Query().GetEntityById(2);
GeneralLedger generalLedger = await SupplierLedgerMod.GeneralLedger.Query().GetEntityById(17);
AddressBook addressBook = await SupplierLedgerMod.AddressBook.Query().GetEntityById(17);
SupplierLedgerView view = new SupplierLedgerView()
{
SupplierId = supplier.SupplierId,
InvoiceId = invoice.InvoiceId,
AcctPayId = accountPayable.AccountPayableId,
Amount = 300M,
Gldate = DateTime.Parse("11/11/2019"),
AccountId = generalLedger.AccountId,
GeneralLedgerId = generalLedger.GeneralLedgerId,
DocNumber = 17,
Comment = "back to school",
AddressId = addressBook.AddressId,
CreatedDate = DateTime.Parse("11/11/2019"),
DocType = "PV",
DebitAmount = null,
CreditAmount = null,
FiscalYear = 2019,
FiscalPeriod = 11
};
NextNumber nnNextNumber = await SupplierLedgerMod.SupplierLedger.Query().GetNextNumber();
view.SupplierLedgerNumber = nnNextNumber.NextNumberValue;
SupplierLedger supplierLedger = await SupplierLedgerMod.SupplierLedger.Query().MapToEntity(view);
SupplierLedgerMod.SupplierLedger.AddSupplierLedger(supplierLedger).Apply();
SupplierLedger newSupplierLedger = await SupplierLedgerMod.SupplierLedger.Query().GetEntityByNumber(view.SupplierLedgerNumber);
Assert.NotNull(newSupplierLedger);
newSupplierLedger.Comment = "back to school update";
SupplierLedgerMod.SupplierLedger.UpdateSupplierLedger(newSupplierLedger).Apply();
SupplierLedgerView updateView = await SupplierLedgerMod.SupplierLedger.Query().GetViewById(newSupplierLedger.SupplierLedgerId);
Assert.Same(updateView.Comment, "back to school update");
SupplierLedgerMod.SupplierLedger.DeleteSupplierLedger(newSupplierLedger).Apply();
SupplierLedger lookupSupplierLedger = await SupplierLedgerMod.SupplierLedger.Query().GetEntityById(view.SupplierLedgerId);
Assert.Null(lookupSupplierLedger);
}
public List <ProjectBudget> GetBudgetLinesByGLCode(GeneralLedger gl, ProjectDonor pd)
{
using (var context = new SCMSEntities())
{
var pbList = context.ProjectBudgets.Where(b => b.GeneralLedger.Id == gl.Id && b.BudgetCategory.ProjectDonorId == pd.Id).ToList();
pbList = SCMS.Utils.BudgetLineSorter.SortBudgetLine(pbList);
return(pbList);
}
}
private void Remove_Click(object sender, RoutedEventArgs e)
{
RemoveDialogView handle = new RemoveDialogView();
handle.ChangeLabelForMember();
if (handle.ShowDialog() == true)
{
using (SqlConnection con = new SqlConnection(@Connection.ConnectionString))
{
if (handle.FirstInput != handle.SecondInput)
{
MessageBox.Show("Member ID did not match.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
Connection conn = new Connection();
conn.OpenConection();
int isLogin = 0;
string query = "SELECT * From Stuff ";
SqlDataReader reader = conn.DataReader(query);
while (reader.Read())
{
stuff_name = (string)reader["Stuff_Name"];
stuff_pass = (string)reader["Stuff_Password"];
if (stuff_name.Equals(Login.GlobalStuffName) && stuff_pass.Equals(handle.GetPassword))
{
isLogin = 1;
break;
}
}
if (isLogin != 1)
{
MessageBox.Show("Wrong Password.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
using (SqlCommand command = new SqlCommand("DELETE FROM MonthlyDepositDetails WHERE MemberId = " + handle.FirstInput, con))
{
con.Open();
command.ExecuteNonQuery();
con.Close();
}
Id = Convert.ToInt32(handle.FirstInput);
dateTime = DateTime.Today;
string table = "MonthlyDepositDetails";
string type = "Removed";
string color = "Red";
EntryLog entry = new EntryLog();
entry.Add_Entry(table, type, Id, dateTime, color);
conn.CloseConnection();
GeneralLedger data = new GeneralLedger();
//next click
}
}
}
private void generalDepositlist_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
GeneralLedger classObj = generalDepositlist.SelectedItem as GeneralLedger;
int id = classObj.MemberId;
GDViewObj = new GeneralDepositView();
GDDetailsObj = new GeneralDepositDetailsView();
GDDetailsObj.SearchWithID(id);
this.NavigationService.Navigate(GDDetailsObj);
}
public async Task <ActionResult> PsRequestPrepaid(string id)
{
var context = new SphDataContext();
LoadData <Wallet> lo = await GetWallet(id);
if (null == lo.Source)
{
Response.StatusCode = (int)HttpStatusCode.NotFound;
return(Json(new { success = false, status = "ERROR", message = $"Cannot find WalletCode with Id: {id}." }, JsonRequestBehavior.AllowGet));
}
var generalLedger = new GeneralLedger();
generalLedger.Id = Guid.NewGuid().ToString();
var wallet = lo.Source;
decimal noGstPrice = 0;
decimal gstPrice = 0;
decimal totalPrice = 0;
noGstPrice = Convert.ToDecimal(wallet.TotalValue);
gstPrice = noGstPrice * Convert.ToDecimal(0.06);
totalPrice = noGstPrice + gstPrice;
// required by payment gateway
var model = new PaymentSwitchRequestModel();
model.TransactionId = GenerateCustomRefNo(generalLedger);
model.TransactionAmount = noGstPrice;
model.TransactionGST = gstPrice;
model.PurchaseDate = DateTime.Now;
model.Description = $"{m_applicationName} purchase topup by {User.Identity.Name} for RM{totalPrice} with Id: ({wallet.WalletCode})";
model.CallbackUrl = $"{m_baseUrl}/ost-payment/ps-response-prepaid";
//insert empty transaction into GL with reference no and type
generalLedger.ReferenceNo = model.TransactionId;
generalLedger.Type = "Prepaid";
using (var session = context.OpenSession())
{
session.Attach(generalLedger);
await session.SubmitChanges("Default");
}
var rijndaelKey = new RijndaelEnhanced(m_paymentGatewayEncryptionKey);
var dataToEncrypt = string.Format("{0}|{1}|{2}|{3}|{4}", model.TransactionId, model.TransactionAmount, model.TransactionGST, model.PurchaseDate.ToString("MM/dd/yyyy hh:mm:ss"), model.Description);
if (!string.IsNullOrEmpty(model.CallbackUrl))
{
dataToEncrypt += "|" + model.CallbackUrl;
}
var encryptedData = rijndaelKey.Encrypt(dataToEncrypt);
Response.StatusCode = (int)HttpStatusCode.OK;
return(Json(new { success = true, status = "OK", id = m_paymentGatewayApplicationId, data = encryptedData, url = $"{m_paymentGatewayBaseUrl}/pay" }, JsonRequestBehavior.AllowGet));
}
public ActionResult GeneralLedger_GetTemplate()
{
using (FATContainer dataContainer = new FATContainer())
{
JsonResult result = new JsonResult();
GeneralLedger glInfo = dataContainer.GeneralLedger.Create();
glInfo.TimeMark = DateTime.Now;
result.Data = glInfo;
return(result);
}
}
public ActionResult GeneralLedger_Init()
{
using (FATContainer dataContainer = new FATContainer())
{
GeneralLedger glInfo = dataContainer.GeneralLedger.Create();
glInfo.TchNodeID = Convert.ToInt32(RouteData.Values["id"]);
TeachingNode tchNode = dataContainer.TeachingNode.FirstOrDefault(node => node.Row_ID == glInfo.TchNodeID);
glInfo.TchRoutineID = tchNode.RoutineID;
return(View(glInfo));
}
}
private static bool GLCodeExists(GeneralLedger gl, SCMSEntities context)
{
var mbc = context.MasterBudgetCategories.FirstOrDefault(c => c.Id == gl.MasterBudgetCategoryId);
//check if gl code already exists
var existingGL = context.GeneralLedgers.FirstOrDefault(g => g.Code.Trim() == gl.Code.Trim() && g.MasterBudgetCategory.CountryProgramme.Id == mbc.CountryProgramme.Id && g.Id != gl.Id);
if (existingGL != null)
{
return(true);
}
return(false);
}
public ActionResult GeneralLedger_Insert(GeneralLedger info)
{
using (FATContainer dataContainer = new FATContainer())
{
dataContainer.GeneralLedger.Add(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = info;
return(result);
}
}
public ActionResult GeneralLedger_Update(GeneralLedger info)
{
using (FATContainer dataContainer = new FATContainer())
{
GeneralLedger existedInfo = dataContainer.GeneralLedger.FirstOrDefault(item => item.Row_ID == info.Row_ID);
dataContainer.Entry <GeneralLedger>(existedInfo).CurrentValues.SetValues(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = existedInfo;
return(result);
}
}
public ActionResult GeneralLedger_Delete(int glRowID)
{
using (FATContainer dataContainer = new FATContainer())
{
GeneralLedger glInfo = dataContainer.GeneralLedger.FirstOrDefault(item => item.Row_ID == glRowID);
dataContainer.GeneralLedger.Remove(glInfo);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = glInfo;
return(result);
}
}
/// <summary>
/// Ghi bản ghi trong DB báo cáo
/// </summary>
/// <param name="generalLedger">Bản ghi báo cáo</param>
/// <returns>1: Thành công</returns>
/// <returns>0: Thất bại</returns>
/// Created by nnanh - 06-09-2018
public int AddGeneralLedger(GeneralLedger generalLedger)
{
try
{
var result = _dbContext.GeneralLedger.Add(generalLedger);
}
catch (Exception)
{
return(0);
}
_dbContext.SaveChanges();
return(1);
}
public void SetUp()
{
DateTimeServer.SetLocal(new TestDateTimeServer(DateTime.Parse("2012-1-1")));
_income = AccountFactory.Income("Income", initialBalance:100M);
_pocketMoney = AccountFactory.Income("Pocket Money", initialBalance: 100M);
_automaticPayment = new AutomaticPayment() { Debit = _income, Credit = _pocketMoney, Amount = 10M, Description = "Weekly pocket money" };
_generalLedger = new GeneralLedger(new InMemoryRepository())
{
_income,
_pocketMoney
};
}
public async ValueTask <GeneralLedger> Get(CancellationToken cancellationToken = default)
{
var optional = await _inner.GetOptional(GeneralLedger.Identifier, cancellationToken);
if (optional.HasValue)
{
return(optional.Value);
}
var generalLedger = GeneralLedger.Factory();
_inner.Add(generalLedger);
return(generalLedger);
}
public async Task <IFluentGeneralLedger> CreateGeneralLedgerByInvoiceView(InvoiceView invoiceView)
{
try
{
AccountReceivable acctRec = await unitOfWork.accountReceivableRepository.GetEntityByPurchaseOrderId(invoiceView.PurchaseOrderId);
if (acctRec != null)
{
GeneralLedger generalLedgerLookup = await unitOfWork.generalLedgerRepository.FindEntityByDocNumber(acctRec.DocNumber);
if (generalLedgerLookup == null)
{
long addressId = await unitOfWork.addressBookRepository.GetAddressIdByCustomerId(acctRec.CustomerId);
//Revenue Account
ChartOfAccount chartOfAcct = await unitOfWork.chartOfAccountRepository.GetChartofAccount("1000", "1200", "250", "");
GeneralLedger ledger = new GeneralLedger();
ledger.DocNumber = acctRec.DocNumber ?? 0;
ledger.DocType = "OV";
ledger.Amount = acctRec.Amount ?? 0;
ledger.LedgerType = "AA";
ledger.Gldate = DateTime.Now.Date;
ledger.FiscalPeriod = DateTime.Now.Date.Month;
ledger.FiscalYear = DateTime.Now.Date.Year;
ledger.AccountId = chartOfAcct.AccountId;
ledger.CreatedDate = DateTime.Now.Date;
ledger.AddressId = addressId;
ledger.Comment = acctRec.Remark;
ledger.DebitAmount = 0.0M;
ledger.CreditAmount = acctRec.Amount ?? 0;
ledger.GeneralLedgerNumber = (await unitOfWork.nextNumberRepository.GetNextNumber(TypeOfGeneralLedger.GeneralLedgerNumber.ToString())).NextNumberValue;
AddGeneralLedger(ledger);
return(this as IFluentGeneralLedger);
}
processStatus = CreateProcessStatus.AlreadyExists;
return(this as IFluentGeneralLedger);
}
processStatus = CreateProcessStatus.Failed;
return(this as IFluentGeneralLedger);
}
catch (Exception ex)
{
throw new Exception(GetMyMethodName(), ex);
}
}
public ResultType GetGeneralLegerList()
{
ResultType result = new ResultType();
string sqlQuery = @"select ROW_NUMBER() OVER(ORDER BY gl.Gl_Desc asc) as Sno ,gl.Gl_Code,gl.Gl_Desc,gl.Gl_ShortName,gl.Gl_Category,isnull(gl.Gl_PanNo,'')Gl_PanNo,ISNULL(ag.Ac_GrpCode,'')Ac_GrpCode,ISNULL(ag.Ac_Desc,'')Ac_Desc ,
isnull(asg.Ac_GrpCode,'')Ac_GrpCode,isnull(asg.Ac_SGrpDesc,'')Ac_SGrpDesc,isnull(a.Agent_Code,'')Agent_Code,isnull(a.Agent_Desc,'')Agent_Desc,
isnull(ar.Area_Code,'')Area_Code,isnull(ar.Area_Desc,'')Area_Desc
from General_Ledger gl
left join Account_Group ag on ag.Ac_GrpCode = gl.Ac_GrpCode
left join Account_Sub_Group asg on asg.Ac_SGrpCode = gl.Ac_SGrpCode
left join Agent a on a.Agent_Code= gl.Agent_Code
left join Area ar on ar.Area_Code= gl.Area_Code ";
using (SqlConnection conn = new SqlConnection(GetConnectionString()))
{
using (SqlCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandTimeout = conn.ConnectionTimeout;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = sqlQuery;
SqlDataReader dr = cmd.ExecuteReader();
List <GeneralLedger> lstObjects = new List <GeneralLedger>();
GeneralLedger obj = null;
while (dr.Read())
{
obj = new GeneralLedger();
obj.Sno = dr["Sno"].ToString();
obj.Gl_Code = dr["Gl_Code"].ToString();
obj.Gl_Desc = dr["Gl_Desc"].ToString();
obj.Gl_ShortName = dr["Gl_ShortName"].ToString();
obj.Gl_Category = dr["Gl_Category"].ToString();
obj.Gl_PanNo = dr["Gl_PanNo"].ToString();
obj.Ac_GrpCode = dr["Ac_GrpCode"].ToString();
obj.Ac_Desc = dr["Ac_Desc"].ToString();
obj.Ac_GrpCode = dr["Ac_GrpCode"].ToString();
obj.Ac_SGrpDesc = dr["Ac_SGrpDesc"].ToString();
obj.Agent_Code = dr["Agent_Code"].ToString();
obj.Agent_Desc = dr["Agent_Desc"].ToString();
obj.Area_Code = dr["Area_Code"].ToString();
obj.Area_Desc = dr["Area_Desc"].ToString();
lstObjects.Add(obj);
}
result.ListData = lstObjects;
}
}
return(result);
}
public IActionResult DeleteGeneralLedger([FromHeader] string generalLedgerId)
{
try
{
GeneralLedger generalLedger = _dbContext.GeneralLedger.First(i => i.ObjectID.ToString() == generalLedgerId);
_dbContext.GeneralLedger.Remove(generalLedger);
_dbContext.SaveChanges();
}
catch (Exception ex)
{
return(Ok("Lỗi khi xóa trong database"));
}
_dbContext.SaveChanges();
return(Ok(new { Code = 200, Success = true, Data = generalLedgerId }));
}
/// <summary>
/// Performs the playback of actions in this module.
/// </summary>
/// <remarks>You should not call this method directly, instead pass the module
/// instance to the <see cref="TestModuleRunner.Run(ITestModule)"/> method
/// that will in turn invoke this method.</remarks>
void ITestModule.Run()
{
Mouse.DefaultMoveTime = 300;
Keyboard.DefaultKeyPressTime = 100;
Delay.SpeedFactor = 1.0;
GL_ACCOUNT account = new GL_ACCOUNT();
account.acctNumber = "571" + StringFunctions.RandStr("9(1)") + " " + StringFunctions.RandStr("A(9)"); // the db is setup to use 4 digits accounts
GeneralLedger._SA_Create(account);
GeneralLedger._SA_Close();
this._varAccount = account.acctNumber;
}
public void SearchAccountTransactions()
{
var ledger = new GeneralLedger(_repository);
var t1 = new Transaction(TestData.Expenses, TestData.Bank, 10M) { Reference = "A", Description = "Buy some stuff" };
ledger.Post(t1);
var t2 = new Transaction(TestData.Bank, TestData.Bank, 10M) { Reference = "B", Description = "Withdraw money" };
ledger.Post(t2);
var bankTransactions = ledger.GetTransactions(TestData.Bank.Id);
bankTransactions.Should().Equal(new[] { t1, t2 }, (x, y) => x.Id == y.Id);
var mortgageTransactions = ledger.GetTransactions(TestData.Expenses.Id);
mortgageTransactions.Should().Equal(new[] { t1 }, (x, y) => x.Id == y.Id);
}
public static double AccountBalance(Session session, Account _Account)
{
XPQuery <GeneralLedger> LedgerQuery = session.Query <GeneralLedger>();
GeneralLedger LastLedger = (from c in LedgerQuery
where c.AccountId == _Account &&
c.TransactionId.AccountingPeriodId == AccountingPeriodBO.getCurrentAccountingPeriod(session)
orderby c.IssuedDate descending
, c.UpdateDate descending
select c).FirstOrDefault();
if (LastLedger == null)
{
return(0);
}
return(LastLedger.Balance);
}
public async Task <Guid> Handle(CreateGeneralLedgerCommand request, CancellationToken cancellationToken)
{
var entity = new GeneralLedger
{
GlIdByCustomer = request.GlIdByCustomer,
GLNameAr = request.GLNameAr,
GlNameEn = request.GlNameEn,
CustomerId = request.CustomerId
};
_context.GeneralLedgers.Add(entity);
await _context.SaveChangesAsync(cancellationToken);
return(entity.Id);
}
/// <summary>
/// Performs the playback of actions in this module.
/// </summary>
/// <remarks>You should not call this method directly, instead pass the module
/// instance to the <see cref="TestModuleRunner.Run(ITestModule)"/> method
/// that will in turn invoke this method.</remarks>
void ITestModule.Run()
{
Mouse.DefaultMoveTime = 300;
Keyboard.DefaultKeyPressTime = 100;
Delay.SpeedFactor = 1.0;
Settings._SA_Get_AllPayableSettings();
// Setup a new account
GL_ACCOUNT newAccount = new GL_ACCOUNT();
if (this._varAccount == "")
{
newAccount.acctNumber = "590" + StringFunctions.RandStr("9(1)") + " " + StringFunctions.RandStr("A(9)"); // the db is setup to use 4 digits accounts
GeneralLedger._SA_Create(newAccount);
GeneralLedger._SA_Close();
}
else
{
newAccount.acctNumber = this._varAccount;
}
// Post an entry in GJ
GENERAL_JOURNAL genJournal = new GENERAL_JOURNAL();
GL_ACCOUNT account2 = new GL_ACCOUNT();
GJ_ROW row = new GJ_ROW();
GJ_ROW row2 = new GJ_ROW();
string amount = Functions.RandCashAmount();
row.Account = newAccount;
row.debitAmt = amount;
genJournal.GridRows.Add(row);
// Using the currency account will need foreign currency setup
row2.Account = Variables.globalSettings.PayableSettings.CurrencyAccounts[0].BankAccount;
row2.creditAmt = amount;
genJournal.GridRows.Add(row2);
genJournal.source = StringFunctions.RandStr("A(8)");
// to be continued
GeneralJournal._SA_Create(genJournal);
GeneralJournal._SA_Close();
}
public GeneralLedger GetNextGeneralLedger(Session session, Guid GeneralLedgerId)
{
GeneralLedger result = null;
try
{
XPCollection <GeneralLedger> NewerGeneralLedgerList = GetNewerGeneralLedger(session, GeneralLedgerId);
NewerGeneralLedgerList.Sorting.Add(new SortProperty("IssuedDate", SortingDirection.Ascending));
NewerGeneralLedgerList.Sorting.Add(new SortProperty("CreateDate", SortingDirection.Ascending));
result = NewerGeneralLedgerList.FirstOrDefault();
}
catch (Exception)
{
return(result);
}
return(result);
}
public GeneralLedgerView(GeneralLedger generalLedger)
{
this.GeneralLedgerId = generalLedger.GeneralLedgerId;
this.DocNumber = generalLedger.DocNumber;
this.DocType = generalLedger.DocType;
this.Amount = generalLedger.Amount;
this.LedgerType = generalLedger.LedgerType;
this.GLDate = generalLedger.GLDate;
this.AccountId = generalLedger.AccountId;
this.CreatedDate = generalLedger.CreatedDate;
this.AddressId = generalLedger.AddressId;
this.Comment = generalLedger.Comment;
this.DebitAmount = generalLedger.DebitAmount;
this.CreditAmount = generalLedger.CreditAmount;
this.FiscalPeriod = generalLedger.FiscalPeriod ?? 0;
this.FiscalYear = generalLedger.FiscalYear ?? 0;
this.CheckNumber = generalLedger.CheckNumber;
this.PurchaseOrderNumber = generalLedger.PurchaseOrderNumber;
this.Units = generalLedger.Units;
}
public void SetUpForImport()
{
DateTimeServer.SetLocal(new TestDateTimeServer(DateTime.Parse("2012-1-1")));
_visa = AccountFactory.Liability("visa");
_electricity = AccountFactory.Expense("electricity");
_groceries = AccountFactory.Expense("groceries");
_general = new GeneralLedger(new InMemoryRepository()) {_visa, _electricity, _groceries };
_repository = new Mock<IImportRepository>(MockBehavior.Strict);
var patterns = GetPatterns();
_importContext = new TransactionImportContext(_general, patterns, _repository.Object);
_import = new Moq.Mock<IImport>(MockBehavior.Strict);
_import.SetupGet(x => x.Name).Returns("Mock Import");
_import.SetupGet(x => x.ImportType).Returns("Mock");
}
public void ImportController()
{
_bank = AccountFactory.Asset("bank", initialBalance: 100);
_groceries = AccountFactory.Asset("groceries");
_wow = AccountFactory.Asset("wow");
_unclassifiedExpense = AccountFactory.Expense("unclassified");
_directoryExplorer = new DirectoryExplorer(_directory);
_repository = new Mock<IImportRepository>();
_importDetector = new Mock<IImportDetector>(MockBehavior.Strict);
_generalLedger = new GeneralLedger(new InMemoryRepository())
{
_bank,
_groceries,
_wow,
_unclassifiedExpense
};
var transactionContext = new TransactionImportContext(_generalLedger, GetAccountIdentifers(), _repository.Object);
_controller = new ImportController(transactionContext, _directoryExplorer, new ImportDetector(new[] {_importDetector.Object}));
}
public void SetUp()
{
_expenseBudgetAccount = AccountFactory.Expense("Grocery Budget");
_expenseAccount = AccountFactory.Expense("Groceries");
_general = new GeneralLedger(new InMemoryRepository()) { _expenseBudgetAccount, _expenseAccount };
_b = new Budget
{
BudgetAccount = _expenseBudgetAccount,
RealAccount = _expenseAccount,
Amount = 100M
};
}
public AccountIdentifierController(IAccountIdentifierRepository repository, GeneralLedger generalLedger, IEnumerable<PatternBuilder> patterns)
{
_repository = repository;
_generalLedger = generalLedger;
_patterns = patterns;
}
public void PostTransaction()
{
var generalLedger = new GeneralLedger(new InMemoryRepository());
Assert.That(generalLedger.Post(_transaction), Is.True);
}
public AccountController(GeneralLedger generalLedger)
{
_generalLedger = generalLedger;
}
