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")); }