//public List<ExpenseTransactionDTO> GetExpenseTransaction(DateTime reportDate, string mode)
//{
// var lstExpenseTransaction = new List<ExpenseTransactionDTO>();
// using (var entities = new ManiMotorsEntities1())
// {
// if (mode == "DAILY")
// {
// var results = entities.GetDailyExpenseTransaction_SP(reportDate);
// foreach (var ent in results)
// {
// var expenseTransactionDTO = new ExpenseTransactionDTO();
// expenseTransactionDTO.ExpenseTransactionID = ent.ExpenseTransactionID;
// expenseTransactionDTO.ExpenseID = ent.ExpenseID ?? 0;
// expenseTransactionDTO.Comments = ent.Comments;
// expenseTransactionDTO.Amount = ent.Amount ?? 0;
// expenseTransactionDTO.ExpenseDescription = ent.Description;
// expenseTransactionDTO.CreatedDate = ent.CreatedDate ?? DateTime.Now;
// lstExpenseTransaction.Add(expenseTransactionDTO);
// }
// }
// else if (mode == "MONTHLY")
// {
// var results = entities.GetMonthlyExpenseTransaction_SP(reportDate);
// foreach (var ent in results)
// {
// var expenseTransactionDTO = new ExpenseTransactionDTO();
// expenseTransactionDTO.ExpenseTransactionID = ent.ExpenseTransactionID;
// expenseTransactionDTO.ExpenseID = ent.ExpenseID ?? 0;
// expenseTransactionDTO.Comments = ent.Comments;
// expenseTransactionDTO.Amount = ent.Amount ?? 0;
// expenseTransactionDTO.ExpenseDescription = ent.Description;
// expenseTransactionDTO.CreatedDate = ent.CreatedDate ?? DateTime.Now;
// lstExpenseTransaction.Add(expenseTransactionDTO);
// }
// }
// else if (mode == "YEARLY")
// {
// var results = entities.GetYearlyExpenseTransaction_SP(reportDate);
// foreach (var ent in results)
// {
// var expenseTransactionDTO = new ExpenseTransactionDTO();
// expenseTransactionDTO.ExpenseTransactionID = ent.ExpenseTransactionID;
// expenseTransactionDTO.ExpenseID = ent.ExpenseID ?? 0;
// expenseTransactionDTO.Comments = ent.Comments;
// expenseTransactionDTO.Amount = ent.Amount ?? 0;
// expenseTransactionDTO.ExpenseDescription = ent.Description;
// expenseTransactionDTO.CreatedDate = ent.CreatedDate ?? DateTime.Now;
// lstExpenseTransaction.Add(expenseTransactionDTO);
// }
// }
// }
// return lstExpenseTransaction;
//}
public bool AddExpenseTransaction(ExpenseTransactionDTO expenseTransactionDTO)
{
var flag = true;
try
{
using (var entities = new ManiMotorsEntities1())
{
var expenseTransaction = new ExpenseTransaction()
{
ExpenseID = expenseTransactionDTO.ExpenseID,
Comments = expenseTransactionDTO.Comments,
Amount = expenseTransactionDTO.Amount,
DebitType = expenseTransactionDTO.DebitType,
ExpenseDate = expenseTransactionDTO.ExpenseDate,
CreatedDate = expenseTransactionDTO.CreatedDate,
Createdby = expenseTransactionDTO.CreatedBy,
Modifiedby = expenseTransactionDTO.ModifiedBy,
ModifiedDate = expenseTransactionDTO.ModifiedDate,
Type = expenseTransactionDTO.Type,
};
entities.ExpenseTransactions.Add(expenseTransaction);
entities.SaveChanges();
flag = true;
}
}
catch (Exception ex)
{
flag = false;
throw ex;
}
return(flag);
}
public bool UpdateExpenseTransaction(ExpenseTransactionDTO expenseTransactionDTO)
{
var flag = true;
try
{
using (var entities = new ManiMotorsEntities1())
{
var expenseTran = entities.ExpenseTransactions.FirstOrDefault(g => g.ExpenseTransactionID == expenseTransactionDTO.ExpenseTransactionID);
expenseTran.ExpenseTransactionID = expenseTransactionDTO.ExpenseTransactionID;
expenseTran.ExpenseID = expenseTransactionDTO.ExpenseID;
expenseTran.Comments = expenseTransactionDTO.Comments;
expenseTran.Amount = expenseTransactionDTO.Amount;
expenseTran.DebitType = expenseTransactionDTO.DebitType;
expenseTran.ExpenseDate = expenseTransactionDTO.ExpenseDate;
expenseTran.Modifiedby = expenseTransactionDTO.ModifiedBy;
expenseTran.ModifiedDate = expenseTransactionDTO.ModifiedDate;
expenseTran.Type = expenseTransactionDTO.Type;
entities.SaveChanges();
flag = true;
}
}
catch (Exception ex)
{
flag = false;
throw ex;
}
return(flag);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (validate())
{
//Populate ExpenseTransactionDTO
var expense = (ComboboxItem)ddlExpenses.SelectedItem;
var Amount = txtAmount.Text;
var Comments = txtComments.Text;
ExpenseTransactionDTO expenseTransactionDTO = new ExpenseTransactionDTO();
expenseTransactionDTO.ExpenseID = Convert.ToInt32(expense.Value);
expenseTransactionDTO.Comments = Comments;
expenseTransactionDTO.Amount = Convert.ToInt32(Amount);
expenseTransactionDTO.DebitType = ddlDebitType.Text;
expenseTransactionDTO.ExpenseDate = Convert.ToDateTime(dtExpDate.Text);
expenseTransactionDTO.CreatedBy = GlobalSetup.Userid;
expenseTransactionDTO.CreatedDate = DateTime.Now;
expenseTransactionDTO.ModifiedDate = null;
expenseTransactionDTO.ModifiedBy = null;
expenseTransactionDTO.Type = ddlType.Text;
ExpenseTransactionBL obj = new ExpenseTransactionBL();
bool result = false;
if (_mode == "EDIT")
{
expenseTransactionDTO.ExpenseTransactionID = _expenseTransactionID;
result = obj.UpdateExpenseTransaction(expenseTransactionDTO);
}
else
{
result = obj.AddExpenseTransaction(expenseTransactionDTO);
}
if (result)
{
MyMessageBox.ShowBox("Expense Transaction Saved!!!");
}
else
{
MyMessageBox.ShowBox("Save Failed !!!");
}
}
else
{
MyMessageBox.ShowBox("Please enter all mandatory fields!!!");
}
this.Clear();
}
