public ActionResult InsertJournalVoucher(LedgerInsertRequest request)
{
var response = new DBResponse();
try
{
var job = _dalLedger.InsertLedger(request);
if (job.FirstOrDefault().Id > 0)
{
response.Id = job.FirstOrDefault().Id;
response.StatusCode = "200";
response.StatusMessage = job.FirstOrDefault().StatusMessage;
}
else
{
response.Id = job.FirstOrDefault().Id;
response.StatusCode = "501";
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));
}
public List <DBResponse> InsertLedger(LedgerInsertRequest request)
{
using (var _context = new AccountsEntities())
{
List <GeneralLedger> objLedger = request.ledgerList;
var xmlLedger = new XElement("ArrayOfLedger", objLedger.Select(x => new XElement("ChildList",
new XElement("Id", x.Id),
new XElement("TransactionDate", x.TransactionDate),
new XElement("VoucherNo", x.VoucherNo),
new XElement("VoucherType", x.VoucherType),
new XElement("VoucherName", x.VoucherName),
new XElement("AccountCode", x.AccountCode),
new XElement("Debit", x.Debit),
new XElement("Credit", x.Credit),
new XElement("Description", x.Description),
new XElement("Narration", x.Narration),
new XElement("Reference", x.Reference),
new XElement("Creator", x.Creator)
)));
request.ledgerXML = xmlLedger.ToString();
string dataList = "[Acc_InsertLedgerInfo] '" + request.ledgerXML + "'";
var list = _context.Database.SqlQuery <DBResponse>(dataList).ToList <DBResponse>();
return(list);
}
}
