public async Task <int> CreatePurchaseInvoiceDetail(PurchaseInvoiceDetailModel purchaseInvoiceDetailModel) { int purchaseInvoiceDetailId = 0; // assign values. Purchaseinvoicedetail purchaseInvoiceDetail = new Purchaseinvoicedetail(); purchaseInvoiceDetail.PurchaseInvoiceId = purchaseInvoiceDetailModel.PurchaseInvoiceId; purchaseInvoiceDetail.SrNo = purchaseInvoiceDetailModel.SrNo; purchaseInvoiceDetail.Description = purchaseInvoiceDetailModel.Description; purchaseInvoiceDetail.UnitOfMeasurementId = purchaseInvoiceDetailModel.UnitOfMeasurementId; purchaseInvoiceDetail.Quantity = purchaseInvoiceDetailModel.Quantity; purchaseInvoiceDetail.PerUnit = purchaseInvoiceDetailModel.PerUnit; purchaseInvoiceDetail.UnitPrice = purchaseInvoiceDetailModel.UnitPrice; purchaseInvoiceDetail.GrossAmountFc = 0; purchaseInvoiceDetail.GrossAmount = 0; purchaseInvoiceDetail.TaxAmountFc = 0; purchaseInvoiceDetail.TaxAmount = 0; purchaseInvoiceDetail.NetAmountFc = 0; purchaseInvoiceDetail.NetAmount = 0; if (purchaseInvoiceDetailId != 0) { await UpdatePurchaseInvoiceDetailAmount(purchaseInvoiceDetailId); await purchaseInvoice.UpdatePurchaseInvoiceMasterAmount(purchaseInvoiceDetail.PurchaseInvoiceId); } purchaseInvoiceDetailId = await Create(purchaseInvoiceDetail); return(purchaseInvoiceDetailId); // returns. }
private async Task <PurchaseInvoiceDetailModel> AssignValueToModel(Purchaseinvoicedetail purchaseInvoiceDetail) { return(await Task.Run(() => { PurchaseInvoiceDetailModel purchaseInvoiceDetailModel = new PurchaseInvoiceDetailModel(); purchaseInvoiceDetailModel.PurchaseInvoiceId = purchaseInvoiceDetail.PurchaseInvoiceId; purchaseInvoiceDetailModel.SrNo = purchaseInvoiceDetail.SrNo; purchaseInvoiceDetailModel.Description = purchaseInvoiceDetail.Description; purchaseInvoiceDetailModel.UnitOfMeasurementId = purchaseInvoiceDetail.UnitOfMeasurementId; purchaseInvoiceDetailModel.Quantity = purchaseInvoiceDetail.Quantity; purchaseInvoiceDetailModel.PerUnit = purchaseInvoiceDetail.PerUnit; purchaseInvoiceDetailModel.UnitPrice = purchaseInvoiceDetail.UnitPrice; purchaseInvoiceDetailModel.GrossAmountFc = purchaseInvoiceDetail.GrossAmountFc; purchaseInvoiceDetailModel.GrossAmount = purchaseInvoiceDetail.GrossAmount; purchaseInvoiceDetailModel.UnitPrice = purchaseInvoiceDetail.UnitPrice; purchaseInvoiceDetailModel.TaxAmountFc = purchaseInvoiceDetail.TaxAmountFc; purchaseInvoiceDetailModel.TaxAmount = purchaseInvoiceDetail.TaxAmount; purchaseInvoiceDetailModel.NetAmountFc = purchaseInvoiceDetail.NetAmountFc; purchaseInvoiceDetailModel.NetAmount = purchaseInvoiceDetail.NetAmount; //--#### purchaseInvoiceDetailModel.UnitOfMeasurementName = purchaseInvoiceDetail.UnitOfMeasurement.UnitOfMeasurementName; return purchaseInvoiceDetailModel; })); }
public async Task <PurchaseInvoiceDetailModel> GetPurchaseInvoiceDetailById(int purchaseInvoiceDetailId) { PurchaseInvoiceDetailModel purchaseInvoiceDetailModel = null; IList <PurchaseInvoiceDetailModel> purchaseInvoiceModelDetailList = await GetPurchaseInvoiceDetailList(purchaseInvoiceDetailId, 0); if (null != purchaseInvoiceModelDetailList && purchaseInvoiceModelDetailList.Any()) { purchaseInvoiceDetailModel = purchaseInvoiceModelDetailList.FirstOrDefault(); } return(purchaseInvoiceDetailModel); // returns. }
public async Task <int> CreatePurchaseInvoiceDetailTax(PurchaseInvoiceDetailTaxModel purchaseInvoiceDetailTaxModel) { int purchaseInvoiceDetailTaxId = 0; int multiplier = 1; PurchaseInvoiceDetailModel purchaseInvoiceDetailModel = null; purchaseInvoiceDetailModel = await purchaseInvoiceDetail.GetPurchaseInvoiceDetailById((int)purchaseInvoiceDetailTaxModel.PurchaseInvoiceDetId); // assign values. Purchaseinvoicedetailtax purchaseInvoiceDetailTax = new Purchaseinvoicedetailtax(); purchaseInvoiceDetailTax.PurchaseInvoiceDetId = purchaseInvoiceDetailTaxModel.PurchaseInvoiceDetId; purchaseInvoiceDetailTax.SrNo = purchaseInvoiceDetailTaxModel.SrNo; purchaseInvoiceDetailTax.TaxLedgerId = purchaseInvoiceDetailTaxModel.TaxLedgerId; purchaseInvoiceDetailTax.TaxPercentageOrAmount = purchaseInvoiceDetailTaxModel.TaxPercentageOrAmount; purchaseInvoiceDetailTax.TaxPerOrAmountFc = purchaseInvoiceDetailTaxModel.TaxPerOrAmountFc; if (DiscountType.Percentage.ToString() == purchaseInvoiceDetailTax.TaxPercentageOrAmount) { purchaseInvoiceDetailTaxModel.TaxAmountFc = (purchaseInvoiceDetailModel.GrossAmountFc * purchaseInvoiceDetailTaxModel.TaxPerOrAmountFc) / 100; } else { purchaseInvoiceDetailTaxModel.TaxAmountFc = purchaseInvoiceDetailTaxModel.TaxPerOrAmountFc; } if (TaxAddOrDeduct.Deduct.ToString() == purchaseInvoiceDetailTaxModel.TaxAddOrDeduct) { multiplier = -1; } purchaseInvoiceDetailTax.TaxAddOrDeduct = purchaseInvoiceDetailTaxModel.TaxAddOrDeduct; purchaseInvoiceDetailTax.TaxAmountFc = multiplier * purchaseInvoiceDetailTaxModel.TaxAmountFc; purchaseInvoiceDetailTax.TaxAmount = multiplier * purchaseInvoiceDetailTaxModel.TaxAmount; purchaseInvoiceDetailTax.Remark = purchaseInvoiceDetailTaxModel.Remark; purchaseInvoiceDetailTaxId = await Create(purchaseInvoiceDetailTax); if (purchaseInvoiceDetailTaxId != 0) { await purchaseInvoiceDetail.UpdatePurchaseInvoiceDetailAmount(purchaseInvoiceDetailTax.PurchaseInvoiceDetId); purchaseInvoiceDetailTax = await GetByIdAsync(w => w.PurchaseInvoiceDetTaxId == purchaseInvoiceDetailTaxModel.PurchaseInvoiceDetTaxId); await purchaseInvoice.UpdatePurchaseInvoiceMasterAmount(purchaseInvoiceDetailTax.PurchaseInvoiceDet.PurchaseInvoiceId); } return(purchaseInvoiceDetailTaxId); // returns. }
public List<PurchaseInvoiceDetailModel> getsellingInvoise(int? id) { string Con = _appSettings.Report_Connection; using (SqlConnection cnn = new SqlConnection(Con)) { SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = @"SELECT PurchaseInvoices.Code , CONVERT(DATE, PurchaseInvoices.Date, 110) , Partners.NameAR , PurchaseInvoiceDetails.StockCount , PurchaseInvoiceDetails.PurchasePrice , PurchaseInvoiceDetails.NetAmmount , SUM(PurchaseInvoiceDetails.StockCount) OVER(ORDER BY PurchaseInvoices.Date ROWS BETWEEN UNBOUNDED PRECEDING AND 0 PRECEDING) as StockBalance FROM dbo.PurchaseInvoices INNER JOIN dbo.PurchaseInvoiceDetails ON PurchaseInvoiceDetails.PurchaseInvoiceID = PurchaseInvoices.PurchaseInvoiceID INNER JOIN dbo.Partners ON Partners.PartnerID = PurchaseInvoiceDetails.PartnerID WHERE PurchaseInvoices.PurchaseOrderID = " + id+""; cnn.Open(); SqlDataReader reader = cmd.ExecuteReader(); List<PurchaseInvoiceDetailModel> PurchaseInvoices = new List<PurchaseInvoiceDetailModel>(); while (reader.Read()) { PurchaseInvoiceDetailModel item = new PurchaseInvoiceDetailModel(); item.Code = reader.GetString(0); item.ExeDate = reader.GetDateTime(1).ToString("d/MM/yyyy"); ; item.PartnerNameAR= reader.GetString(2); item.StockCount = reader.GetFloat(3); item.PurchasePrice = reader.GetDecimal(4); item.NetAmmount = reader.GetDecimal(5); item.StockBalance = reader.GetDouble(6); PurchaseInvoices.Add(item); } reader.Close(); cnn.Close(); return PurchaseInvoices; } }
public async Task <bool> UpdatePurchaseInvoiceDetail(PurchaseInvoiceDetailModel purchaseInvoiceDetailModel) { bool isUpdated = false; // get record. Purchaseinvoicedetail purchaseInvoiceDetail = await GetByIdAsync(w => w.PurchaseInvoiceDetId == purchaseInvoiceDetailModel.PurchaseInvoiceDetId); if (null != purchaseInvoiceDetail) { // assign values. purchaseInvoiceDetail.PurchaseInvoiceId = purchaseInvoiceDetailModel.PurchaseInvoiceId; purchaseInvoiceDetail.SrNo = purchaseInvoiceDetailModel.SrNo; purchaseInvoiceDetail.Description = purchaseInvoiceDetailModel.Description; purchaseInvoiceDetail.UnitOfMeasurementId = purchaseInvoiceDetailModel.UnitOfMeasurementId; purchaseInvoiceDetail.Quantity = purchaseInvoiceDetailModel.Quantity; purchaseInvoiceDetail.PerUnit = purchaseInvoiceDetailModel.PerUnit; purchaseInvoiceDetail.UnitPrice = purchaseInvoiceDetailModel.UnitPrice; purchaseInvoiceDetail.GrossAmountFc = 0; purchaseInvoiceDetail.GrossAmount = 0; purchaseInvoiceDetail.TaxAmountFc = 0; purchaseInvoiceDetail.TaxAmount = 0; purchaseInvoiceDetail.NetAmountFc = 0; purchaseInvoiceDetail.NetAmount = 0; isUpdated = await Update(purchaseInvoiceDetail); } if (isUpdated != false) { await UpdatePurchaseInvoiceDetailAmount(purchaseInvoiceDetailModel.PurchaseInvoiceDetId); await purchaseInvoice.UpdatePurchaseInvoiceMasterAmount(purchaseInvoiceDetail.PurchaseInvoiceId); } return(isUpdated); // returns. }