public virtual DataSet ManageExpenseItem(ExpenseDataContract expenseDC)
{
DataSet dataSet = new DataSet();
try
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@hoa", expenseDC.ClientID),
new SqlParameter("@product", expenseDC.ProductID),
new SqlParameter("@price", expenseDC.UnitPrice),
new SqlParameter("@notes", expenseDC.Notes),
new SqlParameter("total", expenseDC.Extended_Price),
new SqlParameter("@invdate", expenseDC.invoicedate),
new SqlParameter("@user", HttpContext.Current.Request.ServerVariables["Logon_User"].ToString())
};
DBHelper obj = new DBHelper();
dataSet = obj.ExecuteDataSet("sp_AddExpenseItem", parameters);
}
catch (Exception ex)
{
string mess = ex.Message;
}
return(dataSet);
}
public ActionResult ExpenseAddItem(int?id)
{
ExpenseDataContract expenseDC = new ExpenseDataContract();
_dropDownManager = new DropDownManager();
try
{
expenseDC.ClientList = _dropDownManager.GetClientList();
expenseDC.ProductList = _dropDownManager.GetProductList();
}
catch (Exception ex)
{
var trace = new StackTrace(ex, true);
var frame = trace.GetFrame(0);
var line = frame.GetFileLineNumber();
LibLogging.WriteErrorToDB("ExpenseAddItem", "LineNumber" + line.ToString() + "-" + ex.Message, ex);
}
return(View(expenseDC));
}
public ActionResult ExpenseAddItem(ExpenseDataContract expenseDC)
{
_expenseManager = new ExpenseManager();
int result = 0;
try
{
if (expenseDC != null)
{
result = _expenseManager.ManageExpenseItem(expenseDC);
}
}
catch (Exception ex)
{
var trace = new StackTrace(ex, true);
var frame = trace.GetFrame(0);
var line = frame.GetFileLineNumber();
LibLogging.WriteErrorToDB("ExpenseAddItem", "LineNumber" + line.ToString() + "-" + ex.Message, ex);
}
return(RedirectToAction("ExpenseAddItem", "Expense"));
}
