public string saveTransaction(Models.EntryModel model)
{
using (var transaction=_ctx.Database.BeginTransaction())
{
try
{
Guid salesId = Guid.NewGuid();
SalesMaster salesMaster = new SalesMaster();
salesMaster.Id = model.Id;
salesMaster.TimeStamp = model.TimeStamp;
salesMaster.LocationName = model.LocationName;
salesMaster.InvoiceNo = model.InvoiceNo;
salesMaster.TotalAmount = model.TotalAmount;
salesMaster.Currency = model.Currency;
List<ProductModel> sales = model.Products.Select(a => new ProductModel() { Name= a.Name, Quantity=a.Quantity, SaleAmount=a.SaleAmount }).ToList();
foreach (var sale in sales)
{
int i = getProductId(sale.Name);
SalesDetail detail = new SalesDetail()
{
ProductId = i,
Quantity = sale.Quantity,
SalesMasterId = model.Id
};
_ctx.salesDetail.Add(detail);
}
_ctx.salesMaster.Add(salesMaster);
_ctx.SaveChanges();
transaction.Commit();
return salesId.ToString();
}
catch
{
transaction.Rollback();
return null;
}
}
}
public bool saveTransaction(Newtonsoft.Json.Linq.JToken model)
{
using (var transaction = _ctx.Database.BeginTransaction())
{
try
{
JObject obj = JObject.Parse(model.ToString());
JToken jsonId = obj["id"];
SalesMaster salesMaster = new SalesMaster();
salesMaster.Id = jsonId.ToString();
JToken jsonLocation = obj["location_name"];
salesMaster.LocationName = jsonLocation.ToString();
JToken jsonSalesPerson = obj["sales_person_name"];
salesMaster.SalesPerson = jsonSalesPerson.ToString();
JToken jsonTimeStamp = obj["timeStamp"];
salesMaster.TimeStamp = jsonTimeStamp.ToString();
JToken jsonCurrency = obj["currency"];
salesMaster.Currency = jsonCurrency.ToString();
JToken jsonSalesInvoiceNo = obj["sale_invoice_number"];
salesMaster.InvoiceNo = jsonSalesInvoiceNo.ToString();
JToken jsonSalesAmount = obj["total_sale_amount"];
salesMaster.TotalAmount = Convert.ToDouble(jsonSalesAmount.ToString());
JToken jsonSalesDetail = obj["SalesDetails"];
JToken[] sales = jsonSalesDetail.ToArray();
_ctx.salesMaster.Add(salesMaster);
foreach (JToken t in sales)
{
string prodName = t["name"].ToString();
int prodId = getProductId(prodName);
if (prodId < 0)
throw new NullReferenceException();
string salesId = salesMaster.Id;
int quantity = Convert.ToInt32(t["quantity"].ToString());
SalesDetail salesDetail = new SalesDetail() { ProductId = prodId, Quantity = quantity, SalesMasterId = salesId };
_ctx.salesDetail.Add(salesDetail);
}
_ctx.SaveChanges();
transaction.Commit();
return true;
}
catch
{
return false;
}
}
}