public bool AddExpense(ExpenseDetails expenseDetails)
{
int res;
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
var param = new DynamicParameters();
param.Add("@Item", expenseDetails.Item);
param.Add("@CategoryId", expenseDetails.CategoryId);
param.Add("@UserId", expenseDetails.UserId);
param.Add("@Amount", expenseDetails.Amount);
param.Add("@ExpenseDate", expenseDetails.ExpenseDate);
res = connection.Execute("AddExpense", param, commandType: CommandType.StoredProcedure);
connection.Close();
}
if (res > 0)
{
return(true);
}
else
{
return(false);
}
}
private void addButton_Click(object sender, EventArgs e)
{
//Expense Details
int id;
bool result = int.TryParse(expenseItemComboBox.SelectedValue.ToString(), out id);
expenseDetails = new ExpenseDetails();
expenseDetails.ExpenseCode = id.ToString();
expenseDetails.Quantity = Convert.ToInt32(qtyTextBox.Text);
expenseDetails.Description = descriptionTextBox.Text;
expenseDetails.Amount = Convert.ToDouble(amountTextBox.Text);
expenseDetails.LineTotal = expenseDetails.Quantity * expenseDetails.Amount;
expenseDetails.ExpenseInfoId = _maxExpenseInfoId;
db.ExpenseDetailses.Add(expenseDetails);
int n = db.SaveChanges();
if (n > 0)
{
MessageBox.Show("Saved!");
GetExpenseDetails();
GetTotalPrice();
}
else
{
MessageBox.Show("Not saved!");
}
}
public void Execute(object parameter)
{
bool res = false;
var window = (Window)parameter;
ExpenseDetailsDAL expenseDetailsDAL = new ExpenseDetailsDAL();
ExpenseDetails expense = new ExpenseDetails
{
UserId = AddExpenseViewModel.UserId,
CategoryId = AddExpenseViewModel.CategoryId,
Amount = AddExpenseViewModel.Amount,
ExpenseDate = AddExpenseViewModel.ExpenseDate.GetValueOrDefault().ToString("yyyy-MM-dd"),
Item = AddExpenseViewModel.Item,
ExpenseTrackerId = AddExpenseViewModel.ExpenseTrackerId,
};
if (expense.ExpenseTrackerId > 0)
{
res = expenseDetailsDAL.UpdateExpense(expense);
}
else
{
res = expenseDetailsDAL.AddExpense(expense);
}
if (res)
{
var viewModel = new ExpenseTrackerManagerViewModel(AddExpenseViewModel.UserId);
viewModel.UserName = AddExpenseViewModel.UserName;
ExpenseTrackerManager expenseTrackerManager = new ExpenseTrackerManager(viewModel);
window.Close();
expenseTrackerManager.Show();
}
}
public JsonResult SaveExpense(ExpenseModel model)
{
ExpenseDetails _details = new ExpenseDetails();
Tuple <Enums.CrudStatus, int> result = _details.SetExpense(model, CrudType.Insert);
return(Json(ReturnAjaxAlertMessage(result.Item1, result.Item2).ToList(), JsonRequestBehavior.AllowGet));
}
//public Expense GetById(int id)
//{
// return context.Expenses.Include(ex => ex.Comments).FirstOrDefault(ex => ex.Id == id);
//}
public ExpenseDetails GetByIdNew(int id)
{
var result = context.Expenses.Include(ex => ex.Comments).FirstOrDefault(ex => ex.Id == id);
ExpenseDetails expenseDetails = ExpenseDetails.DtoFromModel(result);
return(expenseDetails);
}
protected void BindData(string pos, string id)
{
AgressoDirectory.BusinessLogic.ExpenseManager businessLayer = new AgressoDirectory.BusinessLogic.ExpenseManager();
DataTable FromTable = businessLayer.GetExpenses(pos, id);
//Database have values
if (FromTable.Rows.Count > 0)
{
ExpenseDetails.DataSource = FromTable;
ExpenseDetails.DataBind();
}
else
{
FromTable.Rows.Add(FromTable.NewRow());
ExpenseDetails.DataSource = FromTable;
ExpenseDetails.DataBind();
int TotalColumns = ExpenseDetails.Rows[0].Cells.Count;
ExpenseDetails.Rows[0].Cells.Clear();
ExpenseDetails.Rows[0].Cells.Add(new TableCell());
ExpenseDetails.Rows[0].Cells[0].ColumnSpan = TotalColumns;
ExpenseDetails.Rows[0].Cells[0].Text = "No records Found";
}
}
private void ExecuteSaveExpenseDetail()
{
if (ValidateExpenseDetail())
{
using (var unitOfWork = new UnitOfWork(new MahalluDBContext())) {
ExpenseDetails expenseDetail = GetExpenseDetails();
unitOfWork.ExpenseDetails.Add(expenseDetail);
unitOfWork.Complete();
ExpenseDetailList.Add(expenseDetail);
CurrentExpenseDetail = expenseDetail;
//To update total amount
CurrentExpense.ToatalAmount = Convert.ToDecimal(TotalAmount) + _amount;
TotalAmount = (Convert.ToDecimal(TotalAmount) + _amount).ToString();
//TotalExpense = _amount;
unitOfWork.Expenses.Update(CurrentExpense);
unitOfWork.Complete();
ExpenseType totatExpenseType = new ExpenseType()
{
Expense = CurrentExpense
};
eventAggregator.GetEvent <PubSubEvent <ExpenseType> >().Publish(totatExpenseType);
}
}
}
public void EditExpense(ExpenseDetails ExpenseDetails)
{
var Expense = _ExpenseRepository.GetById(ExpenseDetails.Id, true);
var oldMovement = new Movement(Mapper.Map <ExpenseDetails>(Expense));
Expense = Mapper.Map <Expense>(ExpenseDetails);
if (Expense.GeneratedIncomeId.HasValue)
{
Expense.GeneratedIncomeId = (int?)null;
_ExpenseRepository.Update(Expense);
}
var strategy = ContextMovementStrategy.GetMovementStrategy(oldMovement, _bankAccountRepository, _historicMovementRepository, _incomeRepository, _atmWithdrawRepository);
var newMovement = new Movement(ExpenseDetails);
strategy.UpdateDebit(newMovement);
if (newMovement.TargetIncomeId.HasValue)
{
// Update the GenerateIncomeId.
Expense.GeneratedIncomeId = newMovement.TargetIncomeId.Value;
}
_ExpenseRepository.Update(Expense);
}
public Movement(ExpenseDetails expenditure)
{
this.Date = expenditure.DateExpense;
this.Description = expenditure.Description;
this.Amount = expenditure.Cost;
this.PaymentMethod = (PaymentMethod)expenditure.PaymentMethodId;
this.SourceAccountId = expenditure.AccountId;
this.TargetAccountId = expenditure.TargetInternalAccountId;
this.TargetIncomeId = expenditure.GeneratedIncomeId;
this.AtmWithdrawId = expenditure.AtmWithdrawId;
}
public void BindExpenes(Int64 CategoryId)
{
ExpenseDetails objExpenseDetails = (new Cls_ExpenseDetails_b().SelectById(CategoryId));
if (objExpenseDetails != null)
{
ddlExpenseType.SelectedValue = objExpenseDetails.FK_ExpenseID.ToString();
txtExpenseAmt.Text = objExpenseDetails.amount.ToString();
txtDescription.Text = objExpenseDetails.Description.ToString();
}
}
public async Task Add(ExpenseDetails expenseDetails)
{
if (expenseDetails.Detail.Id != null && expenseDetails.Detail.Id != Guid.Empty)
{
_context.Entry(expenseDetails.Detail).State = EntityState.Modified;
}
await _context.ExpensesDetails.AddAsync(expenseDetails);
await _context.SaveChangesAsync();
}
private ExpenseDetails GetExpenseDetails()
{
var expenseDetail = new ExpenseDetails();
expenseDetail.Name = Name?.Trim();
expenseDetail.CreatedOn = Date;
expenseDetail.BillNo = ExpenseDetailBillNo?.Trim();
expenseDetail.CareOf = CareOf?.Trim();
expenseDetail.Expense_Id = CurrentExpense.Id;
expenseDetail.Amount = _amount;
return(expenseDetail);
}
public ExpenseDetails GetExpenseDetails(int expenseTrackerId)
{
var expense = new ExpenseDetails();
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
var param = new DynamicParameters();
param.Add("@ExpenseTrackerId", expenseTrackerId);
expense = connection.Query <ExpenseDetails>("GetExpenseTrackerInfo", param, commandType: CommandType.StoredProcedure).FirstOrDefault();
connection.Close();
}
return(expense);
}
public void AddButtonOnClick()
{
GameObject expenseDetails = GameObject.Find("ExpenseDetails");
expenseDetails.transform.SetAsLastSibling();
GameObject expenseDetailsPanel = GameObject.Find("ExpenseDetailsPanel");
expenseDetailsPanel.transform.SetAsLastSibling();
GameObject scripts = GameObject.Find("Scripts");
ExpenseDetails details = scripts.GetComponent <ExpenseDetails>();
details.Setup(Expense);
}
public ExpenseDetails SelectById(Int64 id)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
ExpenseDetails objExpenseDetails = new ExpenseDetails();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "ExpenseDetails_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@id", id);
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
{
objExpenseDetails.id = Convert.ToInt64(ds.Tables[0].Rows[0]["id"]);
objExpenseDetails.FK_ExpenseID = Convert.ToInt64(ds.Tables[0].Rows[0]["FK_ExpenseID"]);
objExpenseDetails.amount = Convert.ToDecimal(ds.Tables[0].Rows[0]["amount"]);
objExpenseDetails.Description = Convert.ToString(ds.Tables[0].Rows[0]["Description"]);
objExpenseDetails.bankid = Convert.ToInt64(ds.Tables[0].Rows[0]["bankid"]);
}
}
}
}
}
}
catch (Exception ex)
{
// ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objExpenseDetails);
}
override public void deleteExpense(ExpenseDetails expense)
{
connection.Open();
string deleteQuery = "DELETE " + TABLE_EXPENSES.TABLE_NAME + " WHERE " + TABLE_EXPENSES.KEY_ID + " = '" + expense.getExpenseID().ToString() + "'";
SqlCommand command = new SqlCommand(deleteQuery, connection);
try
{
command.ExecuteNonQuery();
}
catch (Exception es)
{
MessageBox.Show(es.Message);
}
}
private IExpenseDetails MapExpenseDetialsDomainToDTO(MyDiary.Domain.Abstract.Domains.IExpenseDetails expenseDetailsDomain)
{
if (expenseDetailsDomain == null)
{
throw new ArgumentNullException("expenseDetailsDomain");
}
if (expenseDetailsDomain.ExpenseList == null)
{
throw new ArgumentNullException("expenseDetailsDomain-->ExpenseList");
}
IExpenseDetails expenseDetails = new ExpenseDetails();
expenseDetails.TotalAmount = expenseDetailsDomain.TotalAmount;
expenseDetails.ExpenseList = MapExpenseDomainListToExpenseDTOList(expenseDetailsDomain.ExpenseList);
return(expenseDetails);
}
public void CreateExpense(ExpenseDetails expenseDetails)
{
var Expense = Mapper.Map <Expense>(expenseDetails);
var movement = new Movement(expenseDetails);
var strategy = ContextMovementStrategy.GetMovementStrategy(movement, _bankAccountRepository, _historicMovementRepository, _incomeRepository, _atmWithdrawRepository);
strategy.Debit();
if (movement.TargetIncomeId.HasValue)
{
Expense.GeneratedIncomeId = movement.TargetIncomeId.Value;
}
_ExpenseRepository.Create(Expense);
}
public ExpenseCard(ExpenseDetails expDetails) : this()
{
this.expenseDetails = expDetails;
this.setName(expDetails.getExpenseName());
this.setAmount(expDetails.getAmount());
if (this.expenseDetails.GetExpenseStatus() == ExpenseStatus.Paid)
{
this.changeToPaid();
}
else
{
this.changeToUnpaid();
}
}
public override void getAllExpense(List <ExpenseCard> expenses, Building apartment, string month, int year)
{
string selectQuery = "SELECT * FROM " + TABLE_EXPENSES.TABLE_NAME +
" WHERE " + TABLE_EXPENSES.KEY_APARTMENT_ID + " = '" + apartment.getID() + "' AND "
+ TABLE_EXPENSES.KEY_MONTH + " = '" + month + "' AND " + TABLE_EXPENSES.KEY_YEAR + " = " + year;
connection.Open();
using (SqlCommand selectCommand = new SqlCommand(selectQuery, connection))
{
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
ExpenseDetails exp = new ExpenseDetails(reader[TABLE_EXPENSES.KEY_ID].ToString(), apartment, reader[TABLE_EXPENSES.KEY_NAME].ToString(), Convert.ToInt32(reader[TABLE_EXPENSES.KEY_AMOUNT]), (ExpenseType)Enum.Parse(typeof(ExpenseType), reader[TABLE_EXPENSES.KEY_TYPE].ToString(), true), (ExpenseStatus)Enum.Parse(typeof(ExpenseStatus), reader[TABLE_EXPENSES.KEY_STATUS].ToString(), true), reader[TABLE_EXPENSES.KEY_MONTH].ToString(), (int)reader[TABLE_EXPENSES.KEY_YEAR]);
expenses.Add(new ExpenseCard(exp));
}
}
}
}
public void SubmitItem()
{
string itemName = ItemNameText.text;
decimal itemPrice = decimal.Parse(ItemPriceText.text);
ExpenseDetails details = GetComponent <ExpenseDetails>();
PeopleDropdown dropdown = GetComponent <PeopleDropdown>();
string personName = dropdown.selectedPerson;
PersonRepository repo = GetComponent <PersonRepository>();
Person person = repo.GetPerson(personName);
details.AddItem(itemName, itemPrice, person);
ExpenseElementList expenseList = GetComponent <ExpenseElementList>();
expenseList.Prime();
}
protected void btnSave_Click(object sender, EventArgs e)
{
Int64 Result = 0;
ExpenseDetails objExpenseDetails = new ExpenseDetails();
objExpenseDetails.FK_ExpenseID = Convert.ToInt64(ddlExpenseType.SelectedValue.ToString());
objExpenseDetails.amount = Convert.ToDecimal(txtExpenseAmt.Text.Trim());
objExpenseDetails.Description = txtDescription.Text.Trim();
objExpenseDetails.bankid = Convert.ToInt64(ddlBank.SelectedValue.ToString());
if (Request.QueryString["id"] != null)
{
objExpenseDetails.id = Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
Result = (new Cls_ExpenseDetails_b().Update(objExpenseDetails));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/Manage_expenseDetails.aspx?mode=u"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Expense Not Updated";
BindExpenes(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)));
}
}
else
{
Result = (new Cls_ExpenseDetails_b().Insert(objExpenseDetails));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/Manage_expenseDetails.aspx?mode=i"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Expense Not Inserted";
}
}
}
public ActionResult Update(DateTime date, string name, string category, double amount, int?dueDate)
{
if (!dueDates.Any(n => n.Name == name))
{
var newExpenseDueDate = new ExpenseDetails {
Name = name, DueDate = dueDate
};
db.Save(newExpenseDueDate);
}
var formData = new MonthlyExpenses {
Date = date, Name = name, Category = category, Amount = amount
};
db.Save(formData);
var returnYear = date.Year > DateTime.Now.Year ? DateTime.Now.Year : date.Year;
return(RedirectToAction("YearSummary/" + returnYear));
}
public Int64 Insert(ExpenseDetails objExpenseDetails)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "ExpenseDetails_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@id";
param.Value = objExpenseDetails.id;
param.SqlDbType = SqlDbType.BigInt;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@FK_ExpenseID", objExpenseDetails.FK_ExpenseID);
cmd.Parameters.AddWithValue("@amount", objExpenseDetails.amount);
cmd.Parameters.AddWithValue("@Description", objExpenseDetails.Description);
cmd.Parameters.AddWithValue("@bankid", objExpenseDetails.bankid);
ConnectionString.Open();
cmd.ExecuteNonQuery();
result = Convert.ToInt64(param.Value);
}
catch (Exception ex)
{
// ErrHandler.writeError(ex.Message, ex.StackTrace);
return(result);
}
finally
{
ConnectionString.Close();
}
return(result);
}
public override void addExpense(ExpenseDetails expDetails)
{
SqlCommand insertCommand = new SqlCommand(INSERT_EXPENSE_SP.SP_NAME, connection);
insertCommand.CommandType = System.Data.CommandType.StoredProcedure;
insertCommand.Parameters.Add(new SqlParameter(INSERT_EXPENSE_SP.ID_PARAM, expDetails.getExpenseID()));
insertCommand.Parameters.Add(new SqlParameter(INSERT_EXPENSE_SP.AMOUNT_PARAM, expDetails.getAmount()));
insertCommand.Parameters.Add(new SqlParameter(INSERT_EXPENSE_SP.APARTMENT_ID_PARAM, Guid.Parse(expDetails.getApartment().getID())));
insertCommand.Parameters.Add(new SqlParameter(INSERT_EXPENSE_SP.MONTH_PARAM, expDetails.getMonth()));
insertCommand.Parameters.Add(new SqlParameter(INSERT_EXPENSE_SP.NAME_PARAM, expDetails.getExpenseName()));
insertCommand.Parameters.Add(new SqlParameter(INSERT_EXPENSE_SP.STATUS_PARAM, expDetails.GetExpenseStatus().ToString()));
insertCommand.Parameters.Add(new SqlParameter(INSERT_EXPENSE_SP.TYPE_PARAM, expDetails.GetExpenseType().ToString()));
insertCommand.Parameters.Add(new SqlParameter(INSERT_EXPENSE_SP.YEAR_PARAM, expDetails.getYear()));
connection.Open();
try
{
insertCommand.ExecuteNonQuery();
}
catch (SqlException e)
{
SqlCommand updateCommand = new SqlCommand(UPDATE_EXPENSE_DETAILS_SP.SP_NAME, connection);
updateCommand.CommandType = System.Data.CommandType.StoredProcedure;
updateCommand.Parameters.Add(new SqlParameter(UPDATE_EXPENSE_DETAILS_SP.AMOUNT_PARAM, expDetails.getAmount()));
updateCommand.Parameters.Add(new SqlParameter(UPDATE_EXPENSE_DETAILS_SP.ID_PARAM, expDetails.getExpenseID()));
updateCommand.Parameters.Add(new SqlParameter(UPDATE_EXPENSE_DETAILS_SP.NAME_PARAM, expDetails.getExpenseName()));
updateCommand.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
private void ExecueDeleteExpenseDetail()
{
MessageBoxResult result = MessageBox.Show("Are you sure to delete " + CurrentExpenseDetail.Name, "Delete", MessageBoxButton.YesNo, MessageBoxImage.Warning);
if (result == MessageBoxResult.Yes)
{
if (CurrentExpenseDetail != null)
{
using (var unitOfWork = new UnitOfWork(new MahalluDBContext())) {
ExpenseDetails expenseDetail = unitOfWork.ExpenseDetails.Get(CurrentExpenseDetail.Id);
if (expenseDetail != null)
{
unitOfWork.ExpenseDetails.Remove(expenseDetail);
unitOfWork.Complete();
decimal amount = CurrentExpenseDetail.Amount;
ExpenseDetailList.Remove(CurrentExpenseDetail);
CurrentExpenseDetail = null;
//To update total amount
CurrentExpense.ToatalAmount = Convert.ToDecimal(TotalAmount) - amount;
TotalAmount = (Convert.ToDecimal(TotalAmount) - amount).ToString();
//TotalExpense = -amount;
unitOfWork.Expenses.Update(CurrentExpense);
unitOfWork.Complete();
ExpenseType totatExpenseType = new ExpenseType()
{
Expense = CurrentExpense
};
eventAggregator.GetEvent <PubSubEvent <ExpenseType> >().Publish(totatExpenseType);
}
}
}
}
}
virtual public void addExpense(Expense view, bool regularActive, ExpenseDetails expDetails)
{
}
virtual public void addExpense(ExpenseDetails expDetails)
{
}
virtual public void deleteExpense(ExpenseDetails expense)
{
}
public override void addExpense(Expense view, bool regularActive, ExpenseDetails expDetails)
{
}