//CertificateManager CM; //CustometTaxDetailManager tax; //InvoiceDetailSavingManager InvoicesaveManager; //InvoiceDetailSaving invoice; public List <M_InvoiceDetails> getAllInvoice(string Start, string End, string Status, string ParentId) { try { List <M_InvoiceDetails> Requests = new List <M_InvoiceDetails>(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getAllInvoiceResult> lst = datacontext._getAllInvoice(Start, End, Status, ParentId); foreach (_getAllInvoiceResult result in lst) { M_InvoiceDetails req = new M_InvoiceDetails(); req.Customer_Name = result.CustomerName; req.Customer_Id = result.CustomerId; Requests.Add(req); } } return(Requests); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public List <M_InvoiceDetails> getInvoiceDetail_Certs(string Status, String StartDate, string EndDate, string CusId, string CetrificateRateId) { try { List <M_InvoiceDetails> Requests = new List <M_InvoiceDetails>(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getInvoiceDetails_CertificateResult> lst = datacontext._getInvoiceDetails_Certificate(Status, StartDate, EndDate, CusId, CetrificateRateId); foreach (_getInvoiceDetails_CertificateResult result in lst) { M_InvoiceDetails req = new M_InvoiceDetails(); req.Customer_Id = result.CustomerId; req.Consignee_ = result.Consignee; req.Consignor_ = result.Consignor; req.Created_Date = result.CreatedDate.Value.ToString(); req.Rate_ = result.Rates; req.Request_Id = result.RequestId; req.Is_SVAT = result.IsSVat; Requests.Add(req); } } return(Requests); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public M_InvoiceView getInvoice_HeaderNData(string InvoiceNo) { try { M_InvoiceView req = new M_InvoiceView(); req.InvoiceNo = InvoiceNo; using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getInvoiceHeaderResult> lst = datacontext._getInvoiceHeader(InvoiceNo); foreach (_getInvoiceHeaderResult result in lst) { req.Customer_Name = result.CustomerName; req.ClientId = result.CustomerId; req.InvoicedDate = result.CreatedDate.ToString("dd/MMM/yyyy"); req.Address1 = result.Address1; req.Address2 = result.Address2; req.Address3 = result.Address3; req.FromDate = result.FromDate.ToString("dd/MMM/yyyy"); req.ToDate = result.ToDate.ToString("dd/MMM/yyyy"); req.IsTaxInvoice = result.IsTaxInvoice; req.GrossTotal = Math.Round(result.GrossTotal, 2).ToString(); req.InvoiceTotal = Math.Round(result.InvoiceTotal, 2).ToString(); } System.Data.Linq.ISingleResult <_getInvoiceBodyResult> bdy = datacontext._getInvoiceBody(InvoiceNo); foreach (_getInvoiceBodyResult result in bdy) { M_InvoiceDetails In = new M_InvoiceDetails(); decimal value = Math.Round(result.UnitCharge, 2); In.Certificate_ID = result.CertificateId; In.Request_Id = result.RequestNo; In.Rate_ = value; In.Consignee_ = result.Consignee; In.Consignor_ = result.Consignor; In.Created_Date = result.CreatedDate.ToShortDateString(); req.InvoiceBody.Add(In); } System.Data.Linq.ISingleResult <_getInvoiceTaxResult> tx = datacontext._getInvoiceTax(InvoiceNo); foreach (_getInvoiceTaxResult result in tx) { M_TaxNRates In = new M_TaxNRates(); decimal value = Math.Round(result.Amount, 2); In.RateID = result.TaxCode; In.TaxPresentage = result.TaxPercentage; In.RateValue = value; req.InvoicTaxs.Add(In); } } return(req); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }