//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);
}
}
