protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Database.Expense expense = new Database.Expense();
expense.CreatedBy = currentUserName;
expense.CreatedDate = DateTime.Now.Date;
expense.ExpenseAmount = Convert.ToInt32(txtExpenseAmount.Text);
expense.ExpenseBillNo = txtExpenseBillNo.Text;
expense.ExpenseDate = Convert.ToDateTime(txtExpenseDate.Text);
expense.ExpenseDescription = txtExpenseDescription.Text;
expense.IsActive = true;
context.Expenses.Add(expense);
context.SaveChanges();
lblMessage.Text = "Expense Added Successfully";
lblMessage.ForeColor = Color.Green;
ClearForm();
txtExpenseBillNo.Text = GetNextBillNo();
txtExpenseDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
catch (Exception ex)
{
Helper.LogError(ex);
lblMessage.Text = "Something went Wrong kindly check log";
lblMessage.ForeColor = Color.Red;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
string ExpenseIDObj = hdnExpenseID.Value;
if (!string.IsNullOrEmpty(ExpenseIDObj))
{
int ExpenseID = Convert.ToInt32(ExpenseIDObj);
if (ExpenseID > 0)
{
var ExpenseObj = context.Expenses.Where(x => x.IsActive == true && x.ExpenseID == ExpenseID);
if (ExpenseObj.Count() > 0)
{
Database.Expense expense = ExpenseObj.FirstOrDefault();
string amount = txtExpenseAmount.Text;
expense.ExpenseAmount = amount == "" ? 0 : Convert.ToInt32(amount);
expense.ExpenseBillNo = txtExpenseBillNo.Text;
expense.ExpenseDate = txtExpenseDate.Text == "" ? DateTime.Now.Date : Convert.ToDateTime(txtExpenseDate.Text);
expense.ExpenseDescription = txtExpenseDescription.Text;
expense.ModifiedBy = currentUserName;
expense.ModifiedDate = DateTime.Now.Date;
context.SaveChanges();
lblMessage.Text = "Expense Updated Successfully";
lblMessage.ForeColor = Color.Green;
}
else
{
lblMessage.Text = "Expense Not Found";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Expense ID Not Valid";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Expense ID Not in right format";
lblMessage.ForeColor = Color.Red;
}
}
catch (Exception ex)
{
Helper.LogError(ex);
lblMessage.Text = "Something went Wrong kindly check log";
lblMessage.ForeColor = Color.Red;
}
}
private void UpdateProperties(UpdateExpenseCommand cmd, Database.Expense expense)
{
expense.AccountId = cmd.Account.Id;
expense.Amount = cmd.Amount;
expense.Category = cmd.CategoryName;
expense.Subcategory = cmd.SubcategoryName;
expense.Date = cmd.Date;
expense.Details = cmd.Details;
expense.Type = cmd.Type;
var modified = (DateTimeOffset)cmd.LastModified;
expense.LastModified = modified.LocalDateTime;
expense.LastModifiedBy = cmd.UserName;
}
public async Task <bool> Handle(CreateExpenseCommand cmd, CancellationToken cancellationToken)
{
var createdUtc = (DateTimeOffset)cmd.Created;
var expense = new Database.Expense
{
Id = 0,
AccountId = cmd.Account.Id,
Category = cmd.CategoryName,
Subcategory = cmd.SubcategoryName,
Amount = cmd.Amount,
Date = cmd.Date,
Details = cmd.Details,
Type = cmd.Type,
Created = createdUtc.LocalDateTime,
CreatedBy = cmd.UserName,
LastModified = createdUtc.LocalDateTime,
LastModifiedBy = cmd.UserName
};
this.expenseValidator.Validate(expense)
.ThrowOnError("Invalid expense");
if (cmd.HandlesImportedExpenseId > 0)
{
var importedExpense = this.db.ImportedExpenses.SingleOrDefault(ie => ie.AccountId == cmd.Account.Id &&
ie.Id == cmd.HandlesImportedExpenseId);
if (importedExpense == null)
{
throw new NotFoundException($"ImportedExpense {cmd.HandlesImportedExpenseId}");
}
importedExpense.IsHandled = true;
importedExpense.Expense = expense;
}
else
{
this.db.Expenses.Add(expense);
}
await this.db.SaveChangesAsync();
return(true);
}
public void FillForm()
{
try
{
string ExpenseIDObj = Request.QueryString[Constants.queryExpenseID];
if (!string.IsNullOrEmpty(ExpenseIDObj))
{
int ExpenseID = Convert.ToInt32(ExpenseIDObj);
if (ExpenseID > 0)
{
var ExpenseCollection = context.Expenses.Where(x => x.IsActive == true && x.ExpenseID == ExpenseID);
if (ExpenseCollection.Count() > 0)
{
Database.Expense expense = ExpenseCollection.FirstOrDefault();
txtExpenseAmount.Text = Convert.ToString(expense.ExpenseAmount);
txtExpenseBillNo.Text = expense.ExpenseBillNo;
txtExpenseDate.Text = expense.ExpenseDate.GetValueOrDefault(DateTime.Now.Date).ToString("yyyy-MM-dd");
txtExpenseDescription.Text = expense.ExpenseDescription;
hdnExpenseID.Value = Convert.ToString(expense.ExpenseID);
}
else
{
lblMessage.Text = "Expense Not Found";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Expense ID Not Valid";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Expense ID Not in right format";
lblMessage.ForeColor = Color.Red;
}
}
catch
{
throw;
}
}
