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()
{
});
}
