public List <DBResponse> InsertVoucher(VoucherInsertRequest request)
{
using (var _context = new AccountsEntities())
{
List <VoucherList> objVoucher = request.voucherList;
var xmlLedger = new XElement("ArrayOfVoucher", objVoucher.Select(x => new XElement("ChildList",
new XElement("Id", x.Id),
new XElement("VoucherNo", x.VoucherNo),
new XElement("VoucherType", x.VoucherType),
new XElement("VoucherName", x.VoucherName),
new XElement("CashOfAccountType", x.CashOfAccountType),
new XElement("Payable", x.Payable),
new XElement("Note", x.Note),
new XElement("AccountCode", x.AccountCode),
new XElement("Description", x.Description),
new XElement("Quantity", x.Quantity),
new XElement("UnitPrice", x.UnitPrice),
new XElement("Amount", x.Amount)
)));
request.voucherXml = xmlLedger.ToString();
string dataList = "[Acc_InsertVoucherInfo] '" + request.voucherXml + "'";
var list = _context.Database.SqlQuery <DBResponse>(dataList).ToList <DBResponse>();
return(list);
}
}
public ActionResult InsertReceiptVoucher(VoucherInsertRequest request)
{
var ledgerRequest = new LedgerInsertRequest();
var response = new DBResponse();
try
{
ledgerRequest.ledgerList = request.ledgerList;
var job = _dalLedger.InsertVoucher(request);
if (job.FirstOrDefault().Id > 0)
{
_dalLedger.InsertLedger(ledgerRequest);
response.Id = job.FirstOrDefault().Id;
response.StatusCode = "200";
response.StatusMessage = job.FirstOrDefault().StatusMessage;
}
else
{
response.Id = job.FirstOrDefault().Id;
response.StatusCode = "409";
response.StatusMessage = job.FirstOrDefault().StatusMessage;
}
}
catch (Exception ex)
{
response.Id = -1;
response.StatusCode = "500";
response.StatusMessage = ex.Message.ToString();
}
var camelCaseFormatter = new JsonSerializerSettings();
camelCaseFormatter.ContractResolver = new CamelCasePropertyNamesContractResolver();
return(Json(JsonConvert.SerializeObject(response, camelCaseFormatter), JsonRequestBehavior.AllowGet));
}
