public JsonResult SetSupplierInvDetails(int acheadid, string achead, string invno, string Particulars, decimal Rate, int Qty, decimal amount, int currency, decimal Taxpercent, decimal netvalue)
{
Random rnd = new Random();
int dice = rnd.Next(1, 7); // creates a number between 1 and 6
var invoice = new SupplierInvoiceDetailVM();
invoice.AcHeadId = acheadid;
invoice.AcHeadName = achead;
invoice.InvNo = invno + "_" + dice;
invoice.Particulars = Particulars;
invoice.Rate = Rate;
invoice.Quantity = Qty;
invoice.CurrencyID = currency;
var currencyMaster = db.CurrencyMasters.Find(currency);
invoice.CurrencyAmount = Convert.ToDecimal(currencyMaster.ExchangeRate);
invoice.Currency = currencyMaster.CurrencyName;
//var amount = (Qty * Rate);
//var value = amount + (amount * Taxpercent / 100);
invoice.Amount = amount;
invoice.Value = netvalue;
invoice.TaxPercentage = Taxpercent;
return(Json(new { InvoiceDetails = invoice }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetSupplierInvDetails(int Id)
{
Random rnd = new Random();
// creates a number between 1 and 6
var _invoice = db.SupplierInvoices.Find(Id);
List <SupplierInvoiceDetailVM> _details = new List <SupplierInvoiceDetailVM>();
List <SupplierInvoiceDetailVM> _details1 = new List <SupplierInvoiceDetailVM>();
_details = (from c in db.SupplierInvoiceDetails
join a in db.AcHeads on c.AcHeadID equals a.AcHeadID
join cu in db.CurrencyMasters on c.CurrencyID equals cu.CurrencyID
where c.SupplierInvoiceID == Id
select new SupplierInvoiceDetailVM {
SupplierInvoiceDetailID = c.SupplierInvoiceDetailID, SupplierInvoiceID = c.SupplierInvoiceID, AcHeadId = c.AcHeadID, AcHeadName = a.AcHead1, Particulars = c.Particulars, TaxPercentage = c.TaxPercentage, CurrencyID = c.CurrencyID, Amount = c.Amount, Rate = c.Rate, Quantity = c.Quantity, Value = c.Value, Currency = cu.CurrencyCode
}).ToList();
//var details = (from c in db.SupplierInvoiceDetails
// where c.SupplierInvoiceID == Id
// select c).ToList();
foreach (var item in _details)
{
int dice = rnd.Next(1, 7);
var invoice = new SupplierInvoiceDetailVM();
invoice.SupplierInvoiceDetailID = item.SupplierInvoiceDetailID;
invoice.AcHeadId = item.AcHeadId;
invoice.AcHeadName = item.AcHeadName;
invoice.InvNo = _invoice.InvoiceNo + "_" + dice;
invoice.Particulars = item.Particulars;
invoice.Rate = item.Rate;
invoice.Quantity = item.Quantity;
invoice.CurrencyID = item.CurrencyID;
var currencyMaster = db.CurrencyMasters.Find(item.CurrencyID);
invoice.CurrencyAmount = Convert.ToDecimal(currencyMaster.ExchangeRate);
invoice.Currency = currencyMaster.CurrencyName;
//decimal amount = (item.Quantity * item.Rate);
//decimal value = amount + (amount * Convert.ToDecimal(item.TaxPercentage) / 100);
invoice.Amount = item.Amount;
invoice.Value = item.Value;
invoice.TaxPercentage = item.TaxPercentage;
_details1.Add(invoice);
}
return(Json(new { InvoiceDetails = _details1 }, JsonRequestBehavior.AllowGet));
}
