public JsonResult Insert_Reversal(ReversalVM objects)
{
bool result = false;
string msg = "Failed to save record..";
result = ReversalMethods.Insert_Reversal(objects, ref msg);
if (result)
{
msg = "Successfully Added";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
// GET: /Samples/Reversal/
public ActionResult Index()
{
var customerID = Convert.ToInt64(ConfigurationManager.AppSettings["DemoCustomerIds"].Split(',')[2]);
var planFrequencyID = Convert.ToInt64(ConfigurationManager.AppSettings["DemoPlanFrequencyID"]);
List <decimal> invoiceCharges = new List <decimal>();
var invoices = ApiClient.GetInvoicesByCustomerId(customerID, new ApiWrapper.QueryOptions()).Results;
ReversalVM reversalController = new ReversalVM {
invoices = new List <ApiWrapper.Dto.Get.Invoice>()
};
reversalController.invoices = invoices;
return(View(reversalController));
}
public static bool Insert_Reversal(ReversalVM model, ref string msg)
{
try
{
if (model.ReversalID == null || model.ReversalID == "")
{
strAutoCode = sysfun.AutoGen("Reversal", "ReversalID", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode);
}
else
{
strAutoCode = model.ReversalID;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@ReversalID", strAutoCode), //1
new SqlParameter("@ReversalDate", sysfun.SaveDate(model.ReversalDate)), //2
new SqlParameter("@TransactionNo", model.TransactionNo), //3
new SqlParameter("@TrType", model.TrType), //4
new SqlParameter("@TransactionAmount", model.TransactionAmount), //5
new SqlParameter("@Remarks", model.Remarks), //6
new SqlParameter("@UpdUser", AuthBase.UserId), //7
new SqlParameter("@UpdDate", DateTime.Parse(DateTime.Now.ToShortDateString())), //7
new SqlParameter("@UpdTime", DateTime.Now), //7
new SqlParameter("@UpdTerminal", General.CurrentIP) //8
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (sysfun.ExecuteSP_NonQuery("SP_Insert_Reversal", param, Trans))
{
IsSaved = true;
}
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(IsSaved);
}
