public JsonResult SaveExpense(expense_setup ex_setup)
{
try
{
dbcontext.SPROC_TCCG_EXPENSE_MSTR(ex_setup.invoice_num,
ex_setup.customercode,
ex_setup.total_amt);
var q_del_expense = from aa in dbcontext.TCCG_EXPENSE_DTLs
where aa.INVOICE_NUM == ex_setup.invoice_num
select aa;
dbcontext.TCCG_EXPENSE_DTLs.DeleteAllOnSubmit(q_del_expense);
dbcontext.SubmitChanges();
foreach (var row in ex_setup.expensedtl)
{
dbcontext.SPROC_TCCG_EXPENSE_DTL(ex_setup.invoice_num,
DateTime.Parse(row.trans_dte.ToString()),
row.trans_des,
row.trans_amt);
}
return(Json(new { result = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { result = false, err = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetExpenseDetails(string invoice_num)
{
try
{
expense_setup ex_setup = new expense_setup();
List <expense_setup_dtl> ex_dtl = new List <expense_setup_dtl>();
string cusname = string.Empty;
var q_expense_mstr = (from aa in dbcontext.V_EXPENSEs
where aa.INVOICE_NUM == invoice_num
select aa).First();
ex_setup.invoice_num = q_expense_mstr.INVOICE_NUM;
ex_setup.customercode = q_expense_mstr.CUSTOMER_CDE;
ex_setup.total_amt = q_expense_mstr.EXPENSE_AMT;
cusname = dbcontext.TCCG_CUSTOMERs.Where(aa => aa.CUSTOMER_CODE == q_expense_mstr.CUSTOMER_CDE).First().CUSTOMER_NAME;
var q_expense_dtl = from aa in dbcontext.V_EXPENSE_DTLs
where aa.INVOICE_NUM == invoice_num orderby aa.REC_ID ascending
select aa;
foreach (var row in q_expense_dtl)
{
ex_dtl.Add(new expense_setup_dtl {
trans_des = row.TRANS_DES,
trans_dte = DateTime.Parse(row.TRANS_DTE.ToString()).ToShortDateString(),
trans_amt = row.TRANS_AMT
});
}
ex_setup.expensedtl = ex_dtl;
return(Json(new { result = true, cusname = cusname, ex_setup = ex_setup }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { result = false, err = ex.Message }, JsonRequestBehavior.AllowGet));
}
}