public Invoice GetInvoiceById(Invoice_RQ _objInvoice) { if (_objInvoice.InvoiceId > 0) { var result = GetInvoiceGeneric(_objInvoice); } return(new Invoice() { }); }
public List <Invoice_RS> GetInvoice(Invoice_RQ _objInvoice) { List <Invoice_RS> _lstInvoice = new List <Invoice_RS>(); try { using (LocalEntity _context = new LocalEntity()) { var search = _context.tblInvoices.AsQueryable(); if (!string.IsNullOrWhiteSpace(_objInvoice.InvoiceNo)) { search = (from x in search where x.InvoiceNo == _objInvoice.InvoiceNo select x).AsQueryable(); } if (_objInvoice.InvoiceDate != null) { search = (from x in search where x.InvoiceDate.Date == _objInvoice.InvoiceDate.Value select x).AsQueryable(); } if (!string.IsNullOrWhiteSpace(_objInvoice.PartyNo)) { search = (from x in search where x.PartyNo == _objInvoice.PartyNo select x).AsQueryable(); } int total = search.Count(); int skip = (_objInvoice.PageNo * (_objInvoice.PageSize ?? 5)); _lstInvoice = (from s in search join p in _context.tblPartyMasters on s.PartyNo equals(p.PartyCode) select new Invoice_RS() { InvoiceId = s.InvoiceId, InvoiceNo = s.InvoiceNo, InvoiceGrandAmt = s.InvoiceGrandAmt, InvoiceGrandQty = Convert.ToString(s.InvoiceGrandQty), InvoiceDate = s.InvoiceDate, PartyName = p.PartyCode, InvoiceCurrency = s.InvoiceCurrency }).OrderBy(x => x.PartyName).Skip(skip).ToList(); } } catch (Exception) { throw; } return(_lstInvoice); }
public List <InvoiceMasterList> GetInvoiceByPartyNo(Invoice_RQ invoice_RQ) { if (invoice_RQ != null) { try { using (LocalEntity _context = new LocalEntity()) { var search = (from x in _context.tblInvoices select x).AsQueryable(); if (!string.IsNullOrWhiteSpace(invoice_RQ.PartyNo)) { search = (from s in search where s.PartyNo == invoice_RQ.PartyNo select s).AsQueryable(); } var result = (from x in search join p in _context.tblPartyMasters on x.PartyNo equals p.PartyCode select new InvoiceMasterList { InvoiceId = x.InvoiceId, InvoiceNo = x.InvoiceNo, PartyName = p.PartyName, InvoiceDate = x.InvoiceDate, InvoiceGrandAmt = x.InvoiceGrandAmt, Remarks = x.Remarks }).ToList(); return(result); } } catch (Exception) { throw; } } return(new List <InvoiceMasterList>() { }); }
public DataSet GetInvoiceToPrint(Invoice_RQ _objInvoice) { DataSet dsInvoice = new DataSet(); if (_objInvoice.InvoiceId > 0) { var result = GetInvoiceGeneric(_objInvoice); if (result != null) { DataTable dtInvoice = new DataTable(); dtInvoice.Columns.Add("InvoiceId"); dtInvoice.Columns.Add("InvoiceNo"); dtInvoice.Columns.Add("PartyNo"); dtInvoice.Columns.Add("BankId"); dtInvoice.Columns.Add("Unit"); dtInvoice.Columns.Add("InvoiceDate"); dtInvoice.Columns.Add("InvoiceCurrency"); dtInvoice.Columns.Add("InvoiceGrandQty"); dtInvoice.Columns.Add("InvoiceGrandAmt"); dtInvoice.Columns.Add("Remark"); dtInvoice.Columns.Add("DeliveryTerms"); dtInvoice.Columns.Add("DeliveryType"); dtInvoice.Columns.Add("Port"); dtInvoice.Columns.Add("PaymentTerms"); dtInvoice.Columns.Add("DeliveryPeriod"); dtInvoice.Columns.Add("WODelivery"); dtInvoice.Columns.Add("Remarks"); dtInvoice.Columns.Add("WORemarks"); dtInvoice.Columns.Add("Note"); dtInvoice.Columns.Add("PartialShip"); dtInvoice.Columns.Add("TransShipment"); #region Invoice DataRow dtrowInvoice = dtInvoice.NewRow(); dtrowInvoice["InvoiceId"] = result.InvoiceId; dtrowInvoice["InvoiceNo"] = result.InvoiceNo; dtrowInvoice["PartyNo"] = result.PartyNo; dtrowInvoice["BankId"] = result.BankId; dtrowInvoice["Unit"] = result.Unit; dtrowInvoice["InvoiceDate"] = result.InvoiceDate; dtrowInvoice["InvoiceCurrency"] = result.InvoiceCurrency; dtrowInvoice["InvoiceGrandQty"] = result.InvoiceGrandQty; dtrowInvoice["InvoiceGrandAmt"] = result.InvoiceGrandAmt; dtrowInvoice["Remark"] = result.Remark; dtrowInvoice["DeliveryTerms"] = result.DeliveryTerms; dtrowInvoice["DeliveryType"] = result.DeliveryType; dtrowInvoice["Port"] = result.Port; dtrowInvoice["PaymentTerms"] = result.PaymentTerms; dtrowInvoice["DeliveryPeriod"] = result.DeliveryPeriod; dtrowInvoice["WODelivery"] = result.WODelivery; dtrowInvoice["Remarks"] = result.Remarks; dtrowInvoice["WORemarks"] = result.WORemarks; dtrowInvoice["Note"] = result.Note; dtrowInvoice["PartialShip"] = result.PartialShip; dtrowInvoice["TransShipment"] = result.TransShipment; dtInvoice.Rows.Add(dtrowInvoice); dsInvoice.Tables.Add(dtInvoice); #endregion #region DataTable for Invoice item DataTable dtInvoiceItem = new DataTable(); dtInvoiceItem.Columns.Add("invoiceOrderItemId"); dtInvoiceItem.Columns.Add("ArtId"); dtInvoiceItem.Columns.Add("ArtNo"); dtInvoiceItem.Columns.Add("Desc"); dtInvoiceItem.Columns.Add("WorkOrderDesc"); dtInvoiceItem.Columns.Add("RefillsLink"); dtInvoiceItem.Columns.Add("Rate"); dtInvoiceItem.Columns.Add("Qty"); dtInvoiceItem.Columns.Add("Amount"); dtInvoiceItem.Columns.Add("Sequence"); dtInvoiceItem.Columns.Add("RefillsLinkId"); if (result._objOrderItem != null && result._objOrderItem.Count() > 0) { foreach (var item in result._objOrderItem) { DataRow dr = dtInvoiceItem.NewRow(); dr["invoiceOrderItemId"] = item.InvoiceItemID; dr["ArtId"] = item.ArtNo; dr["ArtNo"] = item.ArtNo; dr["Desc"] = item.ArtDesc; dr["WorkOrderDesc"] = item.WorkOrderDesc; dr["RefillsLink"] = item.RefileInk; dr["Rate"] = item.Rate; dr["Qty"] = item.Quantity; dr["Amount"] = item.Amount; } } dsInvoice.Tables.Add(dtInvoiceItem); #endregion } } return(dsInvoice); }
public Invoice GetInvoiceByNo(Invoice_RQ _objInvoice) { if (!string.IsNullOrWhiteSpace(_objInvoice.InvoiceNo)) { try { using (LocalEntity _context = new LocalEntity()) { //var search = _context.tblCustomers.(); var search = (from x in _context.tblInvoices where x.InvoiceNo == _objInvoice.InvoiceNo select x).AsQueryable(); string strInvoiceNo = string.Empty; if (search != null) { strInvoiceNo = (from x in search select x.InvoiceNo).FirstOrDefault(); } List <InvoiceItemDetails> _lstOrderitem = new List <InvoiceItemDetails>(); if (strInvoiceNo != string.Empty) { _lstOrderitem = (from x in _context.tbl_InvoiceItemDetails where x.InvoiceNo == strInvoiceNo select new InvoiceItemDetails { InvoiceItemID = x.InvoiceItemID, Amount = x.Amount, ArtDesc = x.ArtDesc, ArtNo = x.ArtNo, InvoiceNo = x.InvoiceNo, Quantity = x.Quantity, Rate = x.Rate, RefileInk = x.RefileInk, WorkOrderDesc = x.WorkOrderDesc } ).ToList(); } //var itemorderdetails var result = (from s in search select new Invoice { InvoiceId = s.InvoiceId, InvoiceNo = s.InvoiceNo, PartyNo = s.PartyNo, BankId = s.BankId, Unit = s.Unit, InvoiceDate = s.InvoiceDate, InvoiceCurrency = s.InvoiceCurrency, InvoiceGrandQty = s.InvoiceGrandQty, InvoiceGrandAmt = s.InvoiceGrandAmt, Remark = s.Remark, DeliveryTerms = s.DeliveryTerms, DeliveryType = s.DeliveryType, Port = s.Port, PaymentTerms = s.PaymentTerms, DeliveryPeriod = s.DeliveryPeriod, WODelivery = s.WODelivery, Remarks = s.Remarks, WORemarks = s.WORemarks, Note = s.Note, PartialShip = s.PartialShip, TransShipment = s.TransShipment, CreatedBy = s.CreatedBy, CreatedOn = s.CreatedOn, EditedBy = s.EditedBy, EditedOn = s.EditedOn, IsActive = s.IsActive }).FirstOrDefault(); if (result != null) { foreach (var item in _lstOrderitem) { result._objOrderItem.Add(item); } } return(result); } } catch (Exception) { throw; } } return(new Invoice() { }); }