public bool CreateNewStay(EventExpensesEstimateLookup eventExpenses)
{
try
{
return(DAL.CreateStay(eventExpenses));
}
catch (Exception ex)
{
throw ex;
}
}
public string CreateStay(int eventDetailId, int expenseTypeId, string name, double amount, string paymentMode, string notes)
{
try
{
var expenseObj = new EventExpensesEstimateLookup
{
EventID = eventDetailId,
ExpensesTypeid = expenseTypeId,
ExpenseTypeSource = name,
ExpenseAmount = amount,
ExpenseModeOfPayment = paymentMode,
Notes = notes
};
var result = dbStore.CreateNewStay(expenseObj);
return((result) ? "saved successfully" : "something went wrong");
}
catch (Exception ex)
{
throw ex;
}
}
public bool CreateStay(EventExpensesEstimateLookup eventExpenses)
{
try
{
var query = $"INSERT INTO finance.EventExpensesEstimateLookup (EventID,ExpensesTypeid,ExpenseTypeSource,ExpenseAmount,ExpenseModeOfPayment,Notes) VALUES " +
$"(@EventId,@ExpenseTypeId,@StayName,@Amount,@paymentMode,@Notes)";
var cmd = dbmanager.GetSqlCommand(query);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@EventId", eventExpenses.EventID);
cmd.Parameters.AddWithValue("@ExpenseTypeId", eventExpenses.ExpensesTypeid);
cmd.Parameters.AddWithValue("@StayName", eventExpenses.ExpenseTypeSource);
cmd.Parameters.AddWithValue("@Amount", eventExpenses.ExpenseAmount);
cmd.Parameters.AddWithValue("@paymentMode", eventExpenses.ExpenseModeOfPayment);
cmd.Parameters.AddWithValue("@Notes", eventExpenses.Notes);
var rows = dbmanager.ExecuteNonQuery(cmd);
return(rows >= 1);
}
catch (Exception ex)
{
throw ex;
}
}
