/****************** Make XML file *********************************/
private void GetVat15XMLFile()
{
objDALVAT15 = new DALVAT15();
var dicVat15Detail = objDALVAT15.GetVat15AllDetails(Common.Common.globalPartyTIN, 1, globalReturnedType);
if (dicVat15Detail.Count > 0)
{
List<BLLVAT15> lstMainVat15Detail = dicVat15Detail[0];
List<BLLVAT15> lstSubVat15Detail = dicVat15Detail[1];
string fileName = "VAT15_File_" + Common.Common.globalPartyTIN + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString();
string filePath = System.IO.Directory.GetParent(System.Windows.Forms.Application.ExecutablePath).Parent.Parent.FullName;
filePath = filePath + "\\XML Files\\" + fileName + ".xml";
XmlTextWriter xWriter = new XmlTextWriter(filePath, Encoding.UTF8);
xWriter.WriteStartDocument();
xWriter.WriteStartElement("VAT15Form");
xWriter.WriteStartElement("CommonDetails");
xWriter.WriteElementString("PartyTIN", Common.Common.globalPartyTIN);
xWriter.WriteElementString("PartyName", globalPartyName);
xWriter.WriteElementString("PartyAddress", globalPartyAddress);
xWriter.WriteElementString("MonthID", DateTime.Now.Month.ToString());
xWriter.WriteElementString("QuarterID", globalReturnedType.ToString());
xWriter.WriteElementString("YearID", DateTime.Now.Year.ToString());
xWriter.WriteEndElement();
xWriter.WriteStartElement("VAT15Details");
xWriter.WriteStartElement("Root");
xWriter.WriteElementString("Vat15ID", lstMainVat15Detail[0].Vat15ID.ToString());
xWriter.WriteElementString("SalesA", lstMainVat15Detail[0].SalesA.ToString("#.##"));
xWriter.WriteElementString("SalesB", lstMainVat15Detail[0].SalesB.ToString("#.##"));
xWriter.WriteElementString("SalesC", lstMainVat15Detail[0].SalesC.ToString("#.##"));
xWriter.WriteElementString("SalesD", lstMainVat15Detail[0].SalesD.ToString("#.##"));
xWriter.WriteElementString("SalesE", lstMainVat15Detail[0].SalesE.ToString("#.##"));
xWriter.WriteElementString("SalesF", lstMainVat15Detail[0].SalesF.ToString("#.##"));
xWriter.WriteElementString("SalesG", lstMainVat15Detail[0].SalesG.ToString("#.##"));
xWriter.WriteElementString("SalesH", lstMainVat15Detail[0].SalesH.ToString("#.##"));
xWriter.WriteElementString("PurchaseA", lstMainVat15Detail[0].PurchaseA.ToString("#.##"));
xWriter.WriteElementString("PurchaseB", lstMainVat15Detail[0].PurchaseB.ToString("#.##"));
xWriter.WriteElementString("PurchaseC", lstMainVat15Detail[0].PurchaseC.ToString("#.##"));
xWriter.WriteElementString("PurchaseD", lstMainVat15Detail[0].PurchaseD.ToString("#.##"));
xWriter.WriteElementString("PurchaseE", lstMainVat15Detail[0].PurchaseE.ToString("#.##"));
xWriter.WriteElementString("PurchaseF", lstMainVat15Detail[0].PurchaseF.ToString("#.##"));
xWriter.WriteElementString("PurchaseG", lstMainVat15Detail[0].PurchaseG.ToString("#.##"));
xWriter.WriteElementString("PurchaseH", lstMainVat15Detail[0].PurchaseH.ToString("#.##"));
xWriter.WriteElementString("PurchaseI", lstMainVat15Detail[0].PurchaseI.ToString("#.##"));
xWriter.WriteElementString("OutputTaxA", lstMainVat15Detail[0].OutputTaxA.ToString("#.##"));
xWriter.WriteElementString("OutputTaxB", lstMainVat15Detail[0].OutputTaxB.ToString("#.##"));
xWriter.WriteElementString("OutputTaxC", lstMainVat15Detail[0].OutputTaxC.ToString("#.##"));
xWriter.WriteElementString("OutputTaxD", lstMainVat15Detail[0].OutputTaxD.ToString("#.##"));
xWriter.WriteElementString("ITConActBasisA", lstMainVat15Detail[0].ITConActBasisA.ToString("#.##"));
xWriter.WriteElementString("ITConActBasisB", lstMainVat15Detail[0].ITConActBasisB.ToString("#.##"));
xWriter.WriteElementString("ITConActBasisC", lstMainVat15Detail[0].ITConActBasisC.ToString("#.##"));
xWriter.WriteElementString("ITConActBasisD", lstMainVat15Detail[0].ITConActBasisD.ToString("#.##"));
xWriter.WriteElementString("ITConActBasisE", lstMainVat15Detail[0].ITConActBasisE.ToString("#.##"));
xWriter.WriteElementString("ITConActBasisF", lstMainVat15Detail[0].ITConActBasisF.ToString("#.##"));
xWriter.WriteElementString("ITConActBasisG", lstMainVat15Detail[0].ITConActBasisG.ToString("#.##"));
xWriter.WriteElementString("ITConActBasisH", lstMainVat15Detail[0].ITConActBasisH.ToString("#.##"));
xWriter.WriteElementString("ITConActBasisI", lstMainVat15Detail[0].ITConActBasisI.ToString("#.##"));
xWriter.WriteElementString("ITConActBasisJ", lstMainVat15Detail[0].ITConActBasisJ.ToString("#.##"));
xWriter.WriteElementString("ITConNatBasisA", lstMainVat15Detail[0].ITConNatBasisA.ToString("#.##"));
xWriter.WriteElementString("ITConNatBasisB", lstMainVat15Detail[0].ITConNatBasisB.ToString("#.##"));
xWriter.WriteElementString("ITConNatBasisC", lstMainVat15Detail[0].ITConNatBasisC.ToString("#.##"));
xWriter.WriteElementString("ITConNatBasisD", lstMainVat15Detail[0].ITConNatBasisD.ToString("#.##"));
xWriter.WriteElementString("ITConNatBasisE", lstMainVat15Detail[0].ITConNatBasisE.ToString("#.##"));
xWriter.WriteElementString("ITConNatBasisF", lstMainVat15Detail[0].ITConNatBasisF.ToString("#.##"));
xWriter.WriteElementString("ITConNatBasisG", lstMainVat15Detail[0].ITConNatBasisG.ToString("#.##"));
xWriter.WriteElementString("ITConNatBasisH", lstMainVat15Detail[0].ITConNatBasisH.ToString("#.##"));
xWriter.WriteElementString("ExcessITCA", lstMainVat15Detail[0].ExcessITCA.ToString("#.##"));
xWriter.WriteElementString("ExcessITCB", lstMainVat15Detail[0].ExcessITCB.ToString("#.##"));
xWriter.WriteElementString("ExcessITCC", lstMainVat15Detail[0].ExcessITCC.ToString("#.##"));
xWriter.WriteElementString("ExcessITCD", lstMainVat15Detail[0].ExcessITCD.ToString("#.##"));
xWriter.WriteElementString("ExcessITCE", lstMainVat15Detail[0].ExcessITCE.ToString("#.##"));
xWriter.WriteElementString("ExcessITCF", lstMainVat15Detail[0].ExcessITCF.ToString("#.##"));
xWriter.WriteElementString("ExcessITCG", lstMainVat15Detail[0].ExcessITCG.ToString("#.##"));
xWriter.WriteElementString("ExcessITCH", lstMainVat15Detail[0].ExcessITCH.ToString("#.##"));
xWriter.WriteEndElement();
xWriter.WriteEndElement();
xWriter.WriteStartElement("ChallanDetails");
if (lstSubVat15Detail.Count > 0)
{
for (int r = 0; r <= lstSubVat15Detail.Count - 1; r++)
{
xWriter.WriteStartElement("Root");
xWriter.WriteElementString("Vat15ID", lstSubVat15Detail[r].Vat15ID.ToString());
xWriter.WriteElementString("ChallanID", lstSubVat15Detail[r].ChallanID.ToString());
xWriter.WriteElementString("PaymentType", lstSubVat15Detail[r].PaymentType.ToString());
xWriter.WriteElementString("ChallanNo", lstSubVat15Detail[r].ChallanNo.ToString());
xWriter.WriteElementString("ChallanDate", lstSubVat15Detail[r].ChallanDate.ToString("MMddyy"));
xWriter.WriteElementString("BankTreasury", lstSubVat15Detail[r].BankTreasury.ToString());
xWriter.WriteElementString("BranchCode", lstSubVat15Detail[r].BranchCode.ToString());
xWriter.WriteElementString("ChallanAmount", lstSubVat15Detail[r].ChallanAmount.ToString("#.##"));
xWriter.WriteEndElement();
}
}
xWriter.WriteEndElement();
xWriter.WriteEndElement();
xWriter.WriteEndDocument();
xWriter.Close();
lstXmlName.Add(filePath);
}
}
/******************Get Data From XML *********************************/
string appPath = HttpRuntime.AppDomainAppPath + "UploadedXMLFiles\\" + fileName;
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(appPath);
using (var stringWriter = new StringWriter())
using (var xmlTextWriter = XmlWriter.Create(stringWriter))
{
xmlDoc.WriteTo(xmlTextWriter);
xmlTextWriter.Flush();
XMLFile = stringWriter.GetStringBuilder().ToString();
}
string[] arrformName = fileName.Split('_');
string formName = string.Empty;
if (arrformName.Length > 0)
{
formName = arrformName[0].ToString();
string selectNode = "/" + formName + "Form";
if (formName.ToLower() == "vat15worksheetfile")
selectNode = "/Vat15WorksheetForm";
GlobalDataForRFS(xmlDoc, selectNode);
}
private void GlobalDataForRFS(XmlDocument xdXml, string selectNode)
{
XmlNodeList xnNodes = xdXml.SelectNodes(selectNode);
foreach (XmlNode node in xnNodes)
{
XmlNodeList paerentChildNodes = node.ChildNodes;
foreach (XmlNode parentchild in paerentChildNodes)
{
switch (parentchild.Name)
{
case "CommonDetails":
XmlNodeList childNodes = parentchild.ChildNodes;
foreach (XmlNode child in childNodes)
{
switch (child.Name)
{
case "PartyTIN":
globalPartyTIN = child.InnerText.ToString();
break;
case "PartyName":
child.InnerText.ToString();
break;
case "PartyAddress":
child.InnerText.ToString();
break;
case "MonthID":
globalMonthID = Convert.ToInt32(child.InnerText.ToString());
break;
case "QuarterID":
globalQuarterID = Convert.ToInt32(child.InnerText.ToString());
break;
case "YearID":
globalYearID = Convert.ToInt32(child.InnerText.ToString());
break;
}
}
childNodes = null;
break;
}
}
}
}
No comments:
Post a Comment