public void ExpenseListHasItems()
{
ExpenseList list = null;
list = ExpenseList.GetList(false);
Assert.IsTrue(list.Count > 0);
}
private void ExecuteDeleteExpense()
{
MessageBoxResult result = MessageBox.Show("Deleting Expense will delete all of the details also, \nAre you sure to delete", "Delete", MessageBoxButton.YesNo, MessageBoxImage.Warning);
if (result == MessageBoxResult.Yes)
{
if (CurrentExpense != null)
{
using (var unitofWork = new UnitOfWork(new MahalluDBContext())) {
MahalluManager.Model.Expense expense = unitofWork.Expenses.Get(CurrentExpense.Id);
unitofWork.Expenses.Remove(expense);
unitofWork.Complete();
ExpenseType totatExpenseType = new ExpenseType()
{
Expense = CurrentExpense, Operation = MahalluManager.Model.Common.Operation.Delete
};
eventAggregator.GetEvent <PubSubEvent <ExpenseType> >().Publish(totatExpenseType);
ExpenseList.Remove(CurrentExpense);
CurrentExpense = null;
}
}
}
}
protected override void UpdateAllocated()
{
decimal _asignado = 0;
ExpenseList gastos = Datos_Lineas.DataSource as ExpenseList;
foreach (ExpenseInfo item in gastos)
{
_asignado += item.Asignado;
}
if (_entity.EMedioPago != EMedioPago.CompensacionFactura)
{
_deallocated = _entity.Importe - _asignado;
if (_entity.Importe >= 0)
{
_deallocated = (_deallocated < 0) ? 0 : _deallocated;
}
else
{
_deallocated = (_deallocated > 0) ? 0 : _deallocated;
}
}
else
{
_deallocated = -_asignado;
_entity.Importe = _asignado;
}
NoAsignado_TB.Text = _deallocated.ToString("N2");
MarkControl(NoAsignado_TB);
}
public ActionResult ExpenseReport(string date_from, string date_to)
{
List <ExpenseList> ExpList = new List <ExpenseList>();
Property p = new Property();
DataSet ds = new DataSet();
p.OnTable = "GetExpenseRecord";
p.Condition1 = date_from;
p.Condition2 = date_to;
ds = dl.GetExpenseReport_sp(p);
try
{
foreach (DataRow item in ds.Tables[0].Rows)
{
ExpenseList m = new ExpenseList();
m.Id = item["Id"].ToString();
m.Name = item["Name"].ToString();
m.InvoiceNo = item["InvoiceNo"].ToString();
m.HeadId = item["HeadId"].ToString();
m.HeadName = item["HeadName"].ToString();
m.Date = item["Date"].ToString();
m.Amount = item["Amount"].ToString();
//m.ReceiverName = item["ReceiverName"].ToString();
//m.IsActive = item["IsActive"].ToString();
ExpList.Add(m);
}
ViewBag.ExpList = ExpList;
}
catch (Exception ex)
{
}
return(View());
}
protected override void RefreshMainData()
{
PgMng.Grow(string.Empty, "Gasto");
_selectedOid = ActiveOID;
switch (DataType)
{
case EntityMngFormTypeData.Default:
if (moleQule.Common.ModulePrincipal.GetUseActiveYear())
{
List = ExpenseList.GetList(_categoria, moleQule.Common.ModulePrincipal.GetActiveYear().Year, false);
}
else
{
List = ExpenseList.GetList(_categoria, false);
}
break;
case EntityMngFormTypeData.ByParameter:
_sorted_list = List.GetSortedList();
break;
}
PgMng.Grow(string.Empty, "Lista de Gastos");
}
public void ExpenseListHasItemsOnlyFromBankCategory()
{
ExpenseList list = null;
list = ExpenseList.GetList(ECategoriaGasto.Bancario, 2013, false);
Assert.IsTrue(list.Count > 0);
Assert.IsNull(list.FirstOrDefault(x => x.Fecha.Year != 2013 || x.ECategoriaGasto != ECategoriaGasto.Bancario));
}
public void ExpenseListHasItemsOnlyFromAYear()
{
ExpenseList list = null;
list = ExpenseList.GetList(ECategoriaGasto.Todos, 2013, false);
Assert.IsTrue(list.Count > 0);
Assert.IsNull(list.FirstOrDefault(x => x.Fecha.Year != 2013));
}
public void ExpenseListNotIsNull()
{
ExpenseList list = null;
list = ExpenseList.GetList(ECategoriaGasto.Todos, 2000, false);
Assert.IsNotNull(list);
Assert.AreEqual(list.Count, 0);
}
public ExpenseSelectForm(Form parent, ECategoriaGasto categoria, ExpenseList list)
: base(true, parent, categoria, list)
{
InitializeComponent();
_view_mode = molView.Select;
_action_result = DialogResult.Cancel;
}
public void TotalExpenseShouldBeZeroAfterConstruction()
{
var list = new ExpenseList();
var total = list.TotalExpensesValue;
Assert.AreEqual(new Money(), total);
}
public void GetExpenseShouldReturnZeroExpenseAfterConstruction()
{
var list = new ExpenseList();
var result = list.GetExpense(Id);
Assert.AreEqual(new Money(), result.Value);
}
private void loadedFIle(ExpenseList _list)
{
this.list = new ExpenseList(_list.Exp, _list.Inc);
this.IncList.ItemsSource = this.list.Inc;
this.ExpList.ItemsSource = this.list.Exp;
this.DataContext = this;
this.updateIndo();
}
protected override void GetFormSourceData(long oid, object[] parameters)
{
ETipoPago tipo = (ETipoPago)parameters[0];
_entity = Payment.Get(oid, tipo);
_entity.BeginEdit();
_gastos = ExpenseList.GetByPagoAndPendientesList(moleQule.Store.Structs.EnumConvert.ToECategoriaGasto(tipo), _entity.GetInfo(false), false);
}
protected override void SetUnlinkedGridValues(Control control)
{
if (_gastos != null)
{
_gastos.UpdatePagoValues(_entity);
}
Expenses_BS.DataSource = ExpenseList.GetSortedList(_gastos, "PrevisionPago", ListSortDirection.Ascending);
UpdateAllocated();
RefreshAction();
}
public void AddExpenseShouldIncreaseTotalWithTheExpense()
{
var list = new ExpenseList();
var expense = new Money(10m);
list.AddExpense(new Expense(Id, expense));
var totalExpense = list.TotalExpensesValue;
Assert.AreEqual(expense, totalExpense);
}
public void GetExpenseShouldReturnExpenseAfterItWasAddedWithAddExpenseUsingSameId()
{
var list = new ExpenseList();
var expenseValue = new Money(10m);
list.AddExpense(new Expense(Id, expenseValue));
var result = list.GetExpense(Id);
Assert.AreEqual(expenseValue, result.Value);
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <param name="ProjectID"></param>
/// <returns></returns>
public object GetAllExpenseData(int ProjectID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_PROJ_EXPENSE";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PROJECTID_", ProjectID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
ExpenseBO ExpenseBOobj = null;
ExpenseList ExpenseListobj = new ExpenseList();
ExpenseBOobj = new ExpenseBO();
while (dr.Read())
{
ExpenseBOobj = new ExpenseBO();
if (!dr.IsDBNull(dr.GetOrdinal("PROJECTEXPENSEID")))
{
ExpenseBOobj.PROJECTEXPENSEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PROJECTEXPENSEID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("PROJECTID")))
{
ExpenseBOobj.PROJECTID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PROJECTID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("EXPENSETYPE")))
{
ExpenseBOobj.EXPENSETYPE = dr.GetString(dr.GetOrdinal("EXPENSETYPE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ACCOUNTCODE")))
{
ExpenseBOobj.ACCOUNTCODE = dr.GetString(dr.GetOrdinal("ACCOUNTCODE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("EXPENSEAMOUNT")))
{
ExpenseBOobj.EXPENSEAMOUNT = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("EXPENSEAMOUNT")));
}
if (!dr.IsDBNull(dr.GetOrdinal("DATEOFEXPENSE")))
{
ExpenseBOobj.DATEOFEXPENSE = dr.GetDateTime(dr.GetOrdinal("DATEOFEXPENSE"));
}
ExpenseBOobj.ISDELETED = dr.GetString(dr.GetOrdinal("ISDELETED"));
ExpenseListobj.Add(ExpenseBOobj);
}
dr.Close();
return(ExpenseListobj);
}
public void AddExpenseShouldIncreaseExpenseAfterItWasAlreadyAdded()
{
var list = new ExpenseList();
var expenseValue = new Money(10m);
list.AddExpense(new Expense(Id, expenseValue));
list.AddExpense(new Expense(Id, expenseValue));
var updatedExpense = list.GetExpense(Id);
Assert.AreEqual(new Money(20m), updatedExpense.Value);
}
public override void PrintList()
{
PgMng.Reset(3, 1, Face.Resources.Messages.LOADING_DATA, this);
ExpenseReportMng reportMng = new ExpenseReportMng(AppContext.ActiveSchema, this.Text, FilterValues);
PgMng.Grow(Face.Resources.Messages.BUILDING_REPORT);
ExpenseListRpt report = reportMng.GetListReport(ExpenseList.GetList((IList <ExpenseInfo>)Datos.List));
PgMng.FillUp();
ShowReport(report);
}
public ExpenseList CalculateExpenses(IEnumerable <Journey> journeys)
{
var expenseList = new ExpenseList();
foreach (var journey in journeys)
{
var journeyExpense = _journeyCostPolicy.CalculateCost(journey);
expenseList.AddExpense(journeyExpense);
}
return(expenseList);
}
public override void UpdateList()
{
switch (_current_action)
{
case molAction.Add:
case molAction.Copy:
if (_entity == null)
{
return;
}
List.AddItem(_entity.GetInfo(false));
if (FilterType == IFilterType.Filter)
{
ExpenseList listA = ExpenseList.GetList(_filter_results);
listA.AddItem(_entity.GetInfo(false));
//_filter_results.Clear();
_filter_results = listA.GetSortedList();
}
break;
case molAction.Edit:
case molAction.ChangeStateContabilizado:
case molAction.Unlock:
if (_entity == null)
{
return;
}
ActiveItem.CopyFrom(_entity);
break;
case molAction.Delete:
if (ActiveItem == null)
{
return;
}
List.RemoveItem(ActiveOID);
if (FilterType == IFilterType.Filter)
{
ExpenseList listD = ExpenseList.GetList(_filter_results);
listD.RemoveItem(ActiveOID);
//_filter_results.Clear();
_filter_results = listD.GetSortedList();
}
break;
}
RefreshSources();
if (_entity != null)
{
Select(_entity.Oid);
}
_entity = null;
}
protected override void SetUnlinkedGridValues(string gridName)
{
SortedBindingList <ExpenseInfo> gastos = Datos_Lineas.DataSource as Csla.SortedBindingList <ExpenseInfo>;
ExpenseList list = ExpenseList.GetList(gastos);
if (gastos != null)
{
list.UpdatePagoValues(_entity);
}
Datos_Lineas.DataSource = list.GetSortedList();
UpdateAllocated();
}
protected override void RefreshMainData()
{
Datos.DataSource = _entity;
PgMng.Grow();
Datos_Lineas.DataSource = ExpenseList.GetSortedList(_expenses, "PrevisionPago", ListSortDirection.Ascending);
PgMng.Grow();
Fecha_DTP.Value = _entity.Fecha;
Vencimiento_DTP.Value = _entity.Vencimiento;
base.RefreshMainData();
}
protected override void RefreshMainData()
{
Datos.DataSource = _entity;
PgMng.Grow();
Datos_Lineas.DataSource = ExpenseList.GetByPagoList(_entity, false);
PgMng.Grow();
Fecha_DTP.Value = _entity.Fecha;
Vencimiento_DTP.Value = _entity.Vencimiento;
base.RefreshMainData();
}
private void button2_Click(object sender, EventArgs e)
{
//var str = tableLayoutPanel1.GetControlFromPosition(1, 1);
ExpenseList newExpenses = new ExpenseList();
for (int i = 0; i < numEntries; i++)
{
string str = tableLayoutPanel1.GetControlFromPosition(0, i).Text;
Decimal num = ((NumericUpDown)(tableLayoutPanel1.GetControlFromPosition(1, i))).Value;
Console.WriteLine(str + ", " + num.ToString());
newExpenses.Add(new Expense(str, num));
}
expenseState = newExpenses;
}
public ActionResult ExpenseList()
{
List <ExpenseList> CategoryList = new List <ExpenseList>();
Property p = new Property();
DataSet ds = new DataSet();
p.OnTable = "FetchExpenseList";
ds = dl.FetchExpenseList_sp(p);
List <SelectListItem> Categoryinventory = new List <SelectListItem>();
Categoryinventory.Add(new SelectListItem {
Text = "Select", Value = ""
});
foreach (DataRow dr in ds.Tables[1].Rows)
{
Categoryinventory.Add(new SelectListItem {
Text = dr["HeadName"].ToString(), Value = dr["HeadId"].ToString()
});
}
ViewBag.Categoryinventory = new SelectList(Categoryinventory, "Value", "Text");
try
{
foreach (DataRow item in ds.Tables[0].Rows)
{
ExpenseList m = new ExpenseList();
m.Id = item["Id"].ToString();
m.HeadId = item["HeadId"].ToString();
m.HeadName = item["HeadName"].ToString();
m.Name = item["Name"].ToString();
m.InvoiceNo = item["InvoiceNo"].ToString();
m.Date = item["Date"].ToString();
m.Amount = item["Amount"].ToString();
m.Attachment = item["Attachment"].ToString();
m.Description = item["Description"].ToString();
m.IsActive = item["IsActive"].ToString();
CategoryList.Add(m);
}
ViewBag.CategoryList = CategoryList;
}
catch (Exception e)
{
}
return(View());
}
protected void UpdateAmount()
{
ExpenseList lines = Datos_Lineas.DataSource as ExpenseList;
decimal asignado = lines.Sum(item => item.Asignado);
if (_entity.Importe >= 0)
{
_entity.Importe = (_entity.Importe) > asignado ? _entity.Importe : asignado;
}
else
{
_entity.Importe = (_entity.Importe) < asignado ? _entity.Importe : asignado;
}
}
public ActionResult ListActive()
{
//GetData();
IEnumerable <expense> ExpenseList;
ExpenseList = ExpenseRepository.GetExpenseByStatus("Unpaid");
ViewBag.RecordCount = ExpenseList.Count();
foreach (var i in ExpenseList)
{
i.subcategory = SubCategoryRepository.GetBySubCategoryID(i.subCategoryID);
i.bankaccount = BankAccountRepository.GetBankAccountByID(i.bankAccountID);
}
return(PartialView(ExpenseList));
}
private void ExecuteSaveExpense()
{
if (ValidateExpense())
{
using (var unitOfWork = new UnitOfWork(new MahalluDBContext())) {
MahalluManager.Model.Expense expense = GetExpense();
unitOfWork.Expenses.Add(expense);
unitOfWork.Complete();
ExpenseList.Add(expense);
CurrentExpense = expense;
ExpenseType totatExpenseType = new ExpenseType()
{
Expense = CurrentExpense
};
eventAggregator.GetEvent <PubSubEvent <ExpenseType> >().Publish(totatExpenseType);
}
}
}
private void btnAdd_Click_1(object sender, EventArgs e)
{
ExpenseList expenseAdd = new ExpenseList();
try
{
DialogResult result = MessageBox.Show("Do you want to Add?", "Confirmation",
MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
expenseAdd.ExpenseName = cmbExpenseItem.Text;
expenseAdd.Qty = Convert.ToInt32(txtQty.Text);
expenseAdd.Amount = Convert.ToDecimal(txtAmount.Text);
expenseAdd.Paid = Convert.ToDecimal(txtpaid.Text);
expenseAdd.Due = Convert.ToDecimal(txtAmount.Text) - Convert.ToDecimal(txtpaid.Text);
var name = db.ExpenseItems.Where(a => a.Name == expenseAdd.ExpenseName).ToList();
if (name.Count == 0)
{
MessageBox.Show("Item Does Not Found", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (name.Count > 0)
{
expenseLists.Add(expenseAdd);
ShowDgvAddItems();
ShowExpenseSummary();
ClearAddItemTextBox();
}
MessageBox.Show("Expense added successfully!");
}
else if (result == DialogResult.No)
{
MessageBox.Show("You have clicked Cancel Button");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
internal static ExpenseList getExpenseHistory(HttpResponseMessage responce)
{
var expenseList = new ExpenseList();
var jsonObj = JsonConvert.DeserializeObject<Dictionary<string, object>>(responce.Content.ReadAsStringAsync().Result);
if (jsonObj.ContainsKey("expensehistory"))
{
var expenseArray = JsonConvert.DeserializeObject<List<object>>(jsonObj["expensehistory"].ToString());
foreach(var expObj in expenseArray)
{
var expense = new Expense();
expense = JsonConvert.DeserializeObject<Expense>(expObj.ToString());
expenseList.Add(expense);
}
}
if (jsonObj.ContainsKey("page_context"))
{
var pageContext = new PageContext();
pageContext = JsonConvert.DeserializeObject<PageContext>(jsonObj["page_context"].ToString());
expenseList.page_context = pageContext;
}
return expenseList;
}
public async Task<ExpenseList.response> ExpenseList(ExpenseList.request request, CancellationToken? token = null)
{
return await SendAsync<ExpenseList.response>(request.ToXmlString(), token.GetValueOrDefault(CancellationToken.None));
}
