public List <M_TaxNRates> getTaxDetails(string IsActive, string IsVat)
{
try
{
List <M_TaxNRates> taxdetail = new List <M_TaxNRates>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getTaxDetailsResult> lst = datacontext._getTaxDetails(IsActive, IsVat);
foreach (_getTaxDetailsResult result in lst)
{
M_TaxNRates tax = new M_TaxNRates();
tax.RateName = result.TaxName;
tax.RateValue = result.TaxPercentage;
tax.RateID = result.TaxCode;
tax.Priority = Convert.ToInt32(result.TaxPriority);
taxdetail.Add(tax);
}
}
return(taxdetail);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public bool AddRateData(M_TaxNRates req)
{
try
{
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
datacontext.Connection.Open();
try
{
datacontext.Transaction = datacontext.Connection.BeginTransaction();
datacontext._setChildNewRates(req.CustomerID, req.RateID, req.RateValue);
datacontext.SubmitChanges();
datacontext.Transaction.Commit();
return(true);
}
catch (Exception ex)
{
datacontext.Transaction.Rollback();
ErrorLog.LogError(ex);
return(false);
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(false);
}
}
public List <M_TaxNRates> getCustomerRates(string CustometId)
{
try
{
List <M_TaxNRates> Requests = new List <M_TaxNRates>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getChildDeafaultRatesResult> lst = datacontext._getChildDeafaultRates(CustometId);
foreach (_getChildDeafaultRatesResult result in lst)
{
M_TaxNRates req = new M_TaxNRates();
req.RateID = result.RateId;
req.RateName = result.RateName;
req.RateValue = result.RateValue;
req.CustomerID = result.CustomerId;
Requests.Add(req);
}
}
return(Requests);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public JsonResult setAddRate(M_TaxNRates Model)
{
bool result = false;
try
{
result = CustomerOBj.AddRateData(Model);
}
catch (Exception Ex)
{
ErrorLog.LogError(Ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public bool setInvoiceTaxDetails(M_TaxNRates req)
{
try
{
DBLinqDataContext datacontext = new DBLinqDataContext();
datacontext.Connection.ConnectionString = Connection_;
datacontext._setInvoiceTax(req.InvoiceId, req.RateID, req.RateValue, req.CreatedBy, req.TaxPresentage);
return(true);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(false);
}
}
public ActionResult GenarateInvoice(DateTime S, DateTime E, string C)
{
/*Start get data for Calculate And Insert to invoice Header for get Invoice No*/
String Start = S.ToString("yyyyMMdd");
String End = E.ToString("yyyyMMdd");
/*end make date for corrct format*/
String Certi_Status = "A";//Certificate Status
String SDoc_Status = "A";
String AttachSheetId = System.Configuration.ConfigurationManager.AppSettings["AttachedSheetId"];
String CertificateRateId = System.Configuration.ConfigurationManager.AppSettings["CertificateRateId"]; //get Certificate Rate Id from Web Config
String SupDocCertificateRateId = System.Configuration.ConfigurationManager.AppSettings["SupDocCertificateRateId"]; //get Certificate Rate Id from Web Config
String InvoiceRateId = System.Configuration.ConfigurationManager.AppSettings["InvoiceRateId"]; //get Invoice Rate Id
String OtherRateId = System.Configuration.ConfigurationManager.AppSettings["OtherRateId"]; //get Other Rate Id
String SupDocOtherRateId = System.Configuration.ConfigurationManager.AppSettings["SupdocOtherRateId"]; //get Supprting Document Id for Other Rate
String SupsDocInvoiceRateId = System.Configuration.ConfigurationManager.AppSettings["SupdocInvoiceRateId"]; //get Supporting Document id For Invoice Rate
String VATCode = System.Configuration.ConfigurationManager.AppSettings["VatCode"];
M_InvoiceData Invo_data = new M_InvoiceData();
Invo_data.CustomerId = C;
Invo_data.Start = Start;
Invo_data.End = End;
Invo_data.InvoiceRateId = InvoiceRateId;
Invo_data.OtherRateId = OtherRateId;
Invo_data.SupDocInvoiceRateId = SupsDocInvoiceRateId;
Invo_data.SupDocOtherRateId = SupDocOtherRateId;
Invo_data.AttachSheetId = AttachSheetId;
Invo_data.SupportingDocStatus = SDoc_Status;
Invo_data.StartDate = S;
Invo_data.EndDate = E;
decimal Cost_Certificate = 0;
decimal Cost_SupprotDoc = 0;
decimal BeforTax_Total = 0;
/*start get Certificate Data*/
decimal TaxCount = 0;
decimal AfterTax_Total = 0;
string Is_SVat = string.Empty;
string checkTaxInvoice = "N";
foreach (var requst in objInv.getInvoiceDetail_Certs(Certi_Status, Start, End, C, CertificateRateId))
{
Cost_Certificate += requst.Rate_; // Calculate Certificate cost befor tax
Is_SVat = requst.Is_SVAT;
}
/*start get Suporting Document Data*/
foreach (var supporting in objSDApp.getSuuportingDocumentApproval(Invo_data))
{
Cost_SupprotDoc += supporting.Rate_;
}
BeforTax_Total = Cost_Certificate + Cost_SupprotDoc;//get gross total=Total Certificate value+total Supproting Document Value
AfterTax_Total = BeforTax_Total;
Invo_data.GrossTotal = BeforTax_Total;
if (Is_SVat.Equals("Y"))
{
foreach (var money in objInv.getTaxDetails("Y", "Y"))
{
decimal presentage = money.RateValue;
TaxCount = presentage * AfterTax_Total / 100;
AfterTax_Total += TaxCount;
checkTaxInvoice = "Y";
}
}
else
{
foreach (var money in objInv.getTaxDetails("Y", VATCode))
{
decimal presentage = money.RateValue;
TaxCount = presentage * AfterTax_Total / 100;
AfterTax_Total += TaxCount;
checkTaxInvoice = "Y";
}
}
Invo_data.InvoiceTotal = AfterTax_Total;
Invo_data.IsTaxInvoice = checkTaxInvoice;
Invo_data.PrintCount = 0;
Invo_data.Createdby = "Admin";
string Invoice_No = objInv.setInvoiceHeader(Invo_data);
/*end get Suporting Document Data*/
M_InvoiceData objInde = new M_InvoiceData();
/*start set Value for Invoice detail Table*/
foreach (var requst in objInv.getInvoiceDetail_Certs(Certi_Status, Start, End, Invo_data.CustomerId, CertificateRateId))
{
/*---------------insert value to detail table------------------*/
objInde.RequestId = requst.Request_Id;
objInde.invoiceNo = Invoice_No;
objInde.Rate = requst.Rate_;
objInde.Createdby = "Admin";
objInv.setInvoiceDetails(objInde);
}
/*end set Value for Invoice detail Table*/
foreach (var supporting in objSDApp.getSuuportingDocumentApproval(Invo_data))
{
string RateId = supporting.Rate_Id;
// string SuportingId = supporting.SupportingDocument_Id;
M_SupportDocument CRH = new M_SupportDocument();
CRH.ClientID_ = Invo_data.CustomerId;
CRH.Invoice_No = Invoice_No;
CRH.Request_ID = supporting.Request_ID;
CRH.Rate_Id = RateId;
CRH.Rate_ = supporting.Rate_;
CRH.Created_By = "Admin";
objInv.setInvoiceRate(CRH);
/*end to set Invoice rate Table*/
}
decimal TaxCounts = 0;
decimal NetTotal = BeforTax_Total;
if (Is_SVat.Equals("Y"))
{
foreach (var money in objInv.getTaxDetails("Y", "Y"))
{
/*---------------------insert value to invoice tax------------------*/
decimal presentage = money.RateValue;
TaxCounts = presentage * BeforTax_Total / 100;
NetTotal = NetTotal + TaxCounts;
M_TaxNRates taxdeta = new M_TaxNRates();
taxdeta.InvoiceId = Invoice_No;
taxdeta.RateID = money.RateID;
taxdeta.RateValue = TaxCounts;
taxdeta.CreatedBy = "Admin";
taxdeta.TaxPresentage = presentage;
objInv.setInvoiceTaxDetails(taxdeta);
}
}
else
{
foreach (var money in objInv.getTaxDetails("Y", VATCode))
{
/*---------------------insert value to invoice tax------------------*/
decimal presentage = money.RateValue;
TaxCounts = presentage * BeforTax_Total / 100;
NetTotal = NetTotal + TaxCounts;
M_TaxNRates taxdeta = new M_TaxNRates();
taxdeta.InvoiceId = Invoice_No;
taxdeta.RateID = money.RateID;
taxdeta.RateValue = TaxCounts;
taxdeta.CreatedBy = "Admin";
taxdeta.TaxPresentage = presentage;
objInv.setInvoiceTaxDetails(taxdeta);
}
}
return(RedirectToAction("InvoiceView", new { Invo = Invoice_No }));
}
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);
}
}
