예제 #1
0
        public DeclarationVatForm GetVatTaxDeclaration(int quarter, int year)
        {
            DeclarationVatForm result = new DeclarationVatForm();

            VatTaxDeclaration vatTaxDeclaration =
                db.VatTaxDeclarations.FirstOrDefault(m => m.Quarter == quarter && m.Year == year);
            if (vatTaxDeclaration == null)
            {
                result.Quarter = quarter;
                result.Year = year;
                result.CreateDate = new DateTime(year, quarter * 3, 1).AddMonths(1).AddDays(-1);
                // Get StoreInfo
                StoreInfo storeInfo = db.StoreInfoes.FirstOrDefault();
                if (storeInfo != null)
                {
                    result.StoreOwnerName = storeInfo.OwnerName;
                    result.StoreTaxCode = storeInfo.TaxCode;
                    result.StoreAddress = storeInfo.Address;
                    result.StoreDistrict = storeInfo.District;
                    result.StoreProvince = storeInfo.Province;
                    result.StorePhone = storeInfo.Phonenumber;
                    result.StoreFax = storeInfo.Fax;
                    result.StoreEmail = storeInfo.Email;
                }

                int startMonth = quarter * 3 - 2;
                int endMonth = quarter * 3;

                // Get Input Bill
                List<InputBill> inputBillList =
                    db.InputBills.Where(
                        m =>
                            m.ImportDate.Month >= startMonth && m.ImportDate.Month <= endMonth &&
                            m.ImportDate.Year == year)
                        .ToList();
                List<DeclarationVatCategory> inputCategories1 = new List<DeclarationVatCategory>();
                int totalInputCategory1 = 0;
                int totalTaxInputCategory1 = 0;
                if (inputBillList.Count > 0)
                {
                    foreach (InputBill inputBill in inputBillList)
                    {
                        DeclarationVatCategory category1 = new DeclarationVatCategory
                        {
                            Column2 = inputBill.InputBillCode,
                            Column3 = inputBill.ImportDate,
                            Column4 = inputBill.Supplier.SupplierName,
                            Column5 = inputBill.Supplier.SupplierTaxCode,
                            Column6 = inputBill.InputBillAmount,
                            Column7 = inputBill.InputTaxAmount
                        };

                        totalInputCategory1 += (int)inputBill.InputBillAmount;
                        totalTaxInputCategory1 += (int)inputBill.InputTaxAmount;

                        inputCategories1.Add(category1);
                    }
                }

                result.InputCategories1 = inputCategories1;
                result.InputCategories1TotalAmount = totalInputCategory1;
                result.InputCategories1TotalTaxAmount = totalTaxInputCategory1;

                result.InputTotalAmount = totalInputCategory1;
                result.InputTotalTaxAmount = totalTaxInputCategory1;

                // Get Output bill
                List<OutputBill> outputBillList =
                    db.OutputBills.Where(
                        m =>
                            m.ExportDate.Month >= startMonth && m.ExportDate.Month <= endMonth &&
                            m.ExportDate.Year == year).ToList();
                List<DeclarationVatCategory> outputCategories4 = new List<DeclarationVatCategory>();
                int totalOutputCategory4 = 0;
                int totalTaxOutputCategory4 = 0;

                if (outputBillList.Count > 0)
                {
                    foreach (OutputBill outputBill in outputBillList)
                    {
                        DeclarationVatCategory category4 = new DeclarationVatCategory();

                        category4.Column2 = outputBill.OutputBillCode;
                        category4.Column3 = outputBill.ExportDate;
                        category4.Column4 = outputBill.Order.User.Fullname;
                        category4.Column5 = outputBill.Order.User.Customers.ElementAt(0).TaxCode;
                        category4.Column6 = outputBill.OutputBillAmount;
                        category4.Column7 = outputBill.OutputBillTaxAmount;

                        totalOutputCategory4 += (int)outputBill.OutputBillAmount;
                        totalTaxOutputCategory4 += (int)outputBill.OutputBillTaxAmount;

                        outputCategories4.Add(category4);
                    }
                }

                result.OutputCategories4 = outputCategories4;
                result.OutputCategories4TotalAmount = totalOutputCategory4;
                result.OutputCategories4TotalTaxAmount = totalTaxOutputCategory4;

                result.OutputTotalAmount = totalOutputCategory4;
                result.HaveTaxOutputAmount = totalOutputCategory4;
                result.OutputTotalTaxAmount = totalTaxOutputCategory4;

                result.Value25 = result.InputTotalTaxAmount;

                result.Value36 = result.OutputTotalTaxAmount - result.Value25;
                if (result.Value36 >= 0)
                {
                    result.Value40A = result.Value36;
                    result.Value40 = result.Value40A;
                }
                else
                {
                    result.Value41 = -result.Value36;
                    result.Value42 = result.Value41;
                }

                result.Value40 = result.Value40A;
                if (result.InputTotalAmount == 0 && result.OutputCategories1TotalAmount == 0 &&
                    result.HaveTaxOutputAmount == 0)
                {
                    result.Value21 = true;
                }
                else
                {
                    result.Value21 = false;
                }
            }
            else
            {
                result.Quarter = quarter;
                result.Year = year;
                if (vatTaxDeclaration.CreateDate == null)
                {
                    result.CreateDate = new DateTime(year, quarter * 3, 1).AddMonths(1).AddDays(-1);
                }
                else
                {
                    result.CreateDate = vatTaxDeclaration.CreateDate;
                }

                if (vatTaxDeclaration.Value20Date == null)
                {
                    result.Value20Date = new DateTime(2013, 1, 1);
                }
                else
                {
                    result.Value20Date = vatTaxDeclaration.Value20Date.Value;
                }

                result.Value20No = vatTaxDeclaration.Value20No;

                // Get StoreInfo
                StoreInfo storeInfo = db.StoreInfoes.FirstOrDefault();

                if (vatTaxDeclaration.StoreOwnerName.Trim() == "")
                {
                    if (storeInfo != null)
                    {
                        result.StoreOwnerName = storeInfo.OwnerName;
                    }
                }
                else
                {
                    result.StoreOwnerName = vatTaxDeclaration.StoreOwnerName;
                }

                if (vatTaxDeclaration.StoreTaxCode.Trim() == "")
                {
                    if (storeInfo != null)
                    {
                        result.StoreTaxCode = storeInfo.TaxCode;
                    }
                }
                else
                {
                    result.StoreTaxCode = vatTaxDeclaration.StoreTaxCode;
                }

                if (vatTaxDeclaration.StoreAddress.Trim() == "")
                {
                    if (storeInfo != null)
                    {
                        result.StoreAddress = storeInfo.Address;
                    }
                }
                else
                {
                    result.StoreAddress = vatTaxDeclaration.StoreAddress;
                }

                if (vatTaxDeclaration.StoreDistrict.Trim() == "")
                {
                    if (storeInfo != null)
                    {
                        result.StoreDistrict = storeInfo.District;
                    }
                }
                else
                {
                    result.StoreDistrict = vatTaxDeclaration.StoreDistrict;
                }

                if (vatTaxDeclaration.StoreProvince.Trim() == "")
                {
                    if (storeInfo != null)
                    {
                        result.StoreProvince = storeInfo.Province;
                    }
                }
                else
                {
                    result.StoreProvince = vatTaxDeclaration.StoreProvince;
                }

                if (vatTaxDeclaration.StorePhone.Trim() == "")
                {
                    if (storeInfo != null)
                    {
                        result.StorePhone = storeInfo.Phonenumber;
                    }
                }
                else
                {
                    result.StorePhone = vatTaxDeclaration.StorePhone;
                }

                if (vatTaxDeclaration.StoreFax.Trim() == "")
                {
                    if (storeInfo != null)
                    {
                        result.StoreFax = storeInfo.Fax;
                    }
                }
                else
                {
                    result.StoreFax = vatTaxDeclaration.StoreFax;
                }

                if (vatTaxDeclaration.StoreEmail.Trim() == "")
                {
                    if (storeInfo != null)
                    {
                        result.StoreEmail = storeInfo.Email;
                    }
                }
                else
                {
                    result.StoreEmail = vatTaxDeclaration.StoreEmail;
                }

                // Tax agent info
                result.VatAgentOwnerName = vatTaxDeclaration.TaxAgentOwnerName;
                result.VatAgentTaxCode = vatTaxDeclaration.TaxAgentTaxCode;
                result.VatAgentName = vatTaxDeclaration.TaxAgentName;
                result.VatAgentNo = vatTaxDeclaration.TaxAgentNo;
                result.VatAgentAddress = vatTaxDeclaration.TaxAgentAddress;
                result.VatAgentDistrict = vatTaxDeclaration.TaxAgentDistrict;
                result.VatAgentProvince = vatTaxDeclaration.TaxAgentProvince;
                result.VatAgentPhone = vatTaxDeclaration.TaxAgentPhone;
                result.VatAgentFax = vatTaxDeclaration.TaxAgentFax;
                result.VatAgentEmail = vatTaxDeclaration.TaxAgentEmail;

                result.Value21 = (vatTaxDeclaration.Value21 == 1);
                result.Value22 = vatTaxDeclaration.Value22.Value;
                result.Value25 = vatTaxDeclaration.Value25.Value;
                result.Value36 = vatTaxDeclaration.Value36.Value;
                result.Value37 = vatTaxDeclaration.Value37.Value;
                result.Value38 = vatTaxDeclaration.Value38.Value;
                result.Value39 = vatTaxDeclaration.Value39.Value;
                result.Value40 = vatTaxDeclaration.Value40.Value;
                result.Value40A = vatTaxDeclaration.Value40a.Value;
                result.Value40B = vatTaxDeclaration.Value40b.Value;
                result.Value41 = vatTaxDeclaration.Value41.Value;
                result.Value42 = vatTaxDeclaration.Value42.Value;
                result.Value43 = vatTaxDeclaration.Value43.Value;

                #region Input

                if (!vatTaxDeclaration.InputCategory1.Trim().IsEmpty())
                {
                    List<DeclarationVatCategory> inputCategory1List = new List<DeclarationVatCategory>();
                    string[] inputCategory1ListString = vatTaxDeclaration.InputCategory1.Split(';');
                    foreach (string s in inputCategory1ListString)
                    {
                        string[] inputCategory1String = s.Split(',');
                        if (inputCategory1String.Length == 7)
                        {
                            DeclarationVatCategory inputCategory1 = new DeclarationVatCategory();
                            inputCategory1.Column2 = inputCategory1String[0];
                            inputCategory1.Column3 = DateTime.ParseExact(inputCategory1String[1], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                            inputCategory1.Column4 = inputCategory1String[2];
                            inputCategory1.Column5 = inputCategory1String[3];
                            inputCategory1.Column6 = Convert.ToInt32(inputCategory1String[4]);
                            inputCategory1.Column7 = Convert.ToInt32(inputCategory1String[5]);
                            inputCategory1.Column8 = inputCategory1String[6];

                            inputCategory1List.Add(inputCategory1);
                        }
                    }
                    result.InputCategories1 = inputCategory1List;
                }

                if (!vatTaxDeclaration.InputCategory2.Trim().IsEmpty())
                {
                    List<DeclarationVatCategory> inputCategory2List = new List<DeclarationVatCategory>();
                    string[] inputCategory2ListString = vatTaxDeclaration.InputCategory2.Split(';');
                    foreach (string s in inputCategory2ListString)
                    {
                        string[] inputCategory2String = s.Split(',');
                        if (inputCategory2String.Length == 7)
                        {
                            DeclarationVatCategory inputCategory2 = new DeclarationVatCategory();
                            inputCategory2.Column2 = inputCategory2String[0];
                            inputCategory2.Column3 = DateTime.ParseExact(inputCategory2String[1], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                            inputCategory2.Column4 = inputCategory2String[2];
                            inputCategory2.Column5 = inputCategory2String[3];
                            inputCategory2.Column6 = Convert.ToInt32(inputCategory2String[4]);
                            inputCategory2.Column7 = Convert.ToInt32(inputCategory2String[5]);
                            inputCategory2.Column8 = inputCategory2String[6];

                            inputCategory2List.Add(inputCategory2);
                        }
                    }
                    result.InputCategories2 = inputCategory2List;
                }

                if (!vatTaxDeclaration.InputCategory3.Trim().IsEmpty())
                {
                    List<DeclarationVatCategory> inputCategory3List = new List<DeclarationVatCategory>();
                    string[] inputCategory3ListString = vatTaxDeclaration.InputCategory3.Split(';');
                    foreach (string s in inputCategory3ListString)
                    {
                        string[] inputCategory3String = s.Split(',');
                        if (inputCategory3String.Length == 7)
                        {
                            DeclarationVatCategory inputCategory3 = new DeclarationVatCategory();
                            inputCategory3.Column2 = inputCategory3String[0];
                            inputCategory3.Column3 = DateTime.ParseExact(inputCategory3String[1], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                            inputCategory3.Column4 = inputCategory3String[2];
                            inputCategory3.Column5 = inputCategory3String[3];
                            inputCategory3.Column6 = Convert.ToInt32(inputCategory3String[4]);
                            inputCategory3.Column7 = Convert.ToInt32(inputCategory3String[5]);
                            inputCategory3.Column8 = inputCategory3String[6];

                            inputCategory3List.Add(inputCategory3);
                        }
                    }
                    result.InputCategories3 = inputCategory3List;
                }

                #endregion

                #region Output

                if (!vatTaxDeclaration.OutputCategory1.Trim().IsEmpty())
                {
                    List<DeclarationVatCategory> outputCategory1List = new List<DeclarationVatCategory>();
                    string[] outputCategory1ListString = vatTaxDeclaration.OutputCategory1.Split(';');
                    foreach (string s in outputCategory1ListString)
                    {
                        string[] outputCategory1String = s.Split(',');
                        if (outputCategory1String.Length == 7)
                        {
                            DeclarationVatCategory outputCategory1 = new DeclarationVatCategory();
                            outputCategory1.Column2 = outputCategory1String[0];
                            outputCategory1.Column3 = DateTime.ParseExact(outputCategory1String[1], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                            outputCategory1.Column4 = outputCategory1String[2];
                            outputCategory1.Column5 = outputCategory1String[3];
                            outputCategory1.Column6 = Convert.ToInt32(outputCategory1String[4]);
                            outputCategory1.Column7 = Convert.ToInt32(outputCategory1String[5]);
                            outputCategory1.Column8 = outputCategory1String[6];

                            outputCategory1List.Add(outputCategory1);
                        }
                    }
                    result.OutputCategories1 = outputCategory1List;
                }

                if (!vatTaxDeclaration.OutputCategory2.Trim().IsEmpty())
                {
                    List<DeclarationVatCategory> outputCategory2List = new List<DeclarationVatCategory>();
                    string[] outputCategory2ListString = vatTaxDeclaration.OutputCategory2.Split(';');
                    foreach (string s in outputCategory2ListString)
                    {
                        string[] outputCategory2String = s.Split(',');
                        if (outputCategory2String.Length == 7)
                        {
                            DeclarationVatCategory outputCategory2 = new DeclarationVatCategory();
                            outputCategory2.Column2 = outputCategory2String[0];
                            outputCategory2.Column3 = DateTime.ParseExact(outputCategory2String[1], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                            outputCategory2.Column4 = outputCategory2String[2];
                            outputCategory2.Column5 = outputCategory2String[3];
                            outputCategory2.Column6 = Convert.ToInt32(outputCategory2String[4]);
                            outputCategory2.Column7 = Convert.ToInt32(outputCategory2String[5]);
                            outputCategory2.Column8 = outputCategory2String[6];

                            outputCategory2List.Add(outputCategory2);
                        }
                    }
                    result.OutputCategories2 = outputCategory2List;
                }

                if (!vatTaxDeclaration.OutputCategory3.Trim().IsEmpty())
                {
                    List<DeclarationVatCategory> outputCategory3List = new List<DeclarationVatCategory>();
                    string[] outputCategory3ListString = vatTaxDeclaration.OutputCategory3.Split(';');
                    foreach (string s in outputCategory3ListString)
                    {
                        string[] outputCategory3String = s.Split(',');
                        if (outputCategory3String.Length == 7)
                        {
                            DeclarationVatCategory outputCategory3 = new DeclarationVatCategory();
                            outputCategory3.Column2 = outputCategory3String[0];
                            outputCategory3.Column3 = DateTime.ParseExact(outputCategory3String[1], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                            outputCategory3.Column4 = outputCategory3String[2];
                            outputCategory3.Column5 = outputCategory3String[3];
                            outputCategory3.Column6 = Convert.ToInt32(outputCategory3String[4]);
                            outputCategory3.Column7 = Convert.ToInt32(outputCategory3String[5]);
                            outputCategory3.Column8 = outputCategory3String[6];

                            outputCategory3List.Add(outputCategory3);
                        }
                    }
                    result.OutputCategories3 = outputCategory3List;
                }

                if (!vatTaxDeclaration.OutputCategory4.Trim().IsEmpty())
                {
                    List<DeclarationVatCategory> outputCategory4List = new List<DeclarationVatCategory>();
                    string[] outputCategory4ListString = vatTaxDeclaration.OutputCategory4.Split(';');
                    foreach (string s in outputCategory4ListString)
                    {
                        string[] outputCategory4String = s.Split(',');
                        if (outputCategory4String.Length == 7)
                        {
                            DeclarationVatCategory outputCategory4 = new DeclarationVatCategory();
                            outputCategory4.Column2 = outputCategory4String[0];
                            outputCategory4.Column3 = DateTime.ParseExact(outputCategory4String[1], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                            outputCategory4.Column4 = outputCategory4String[2];
                            outputCategory4.Column5 = outputCategory4String[3];
                            outputCategory4.Column6 = Convert.ToInt32(outputCategory4String[4]);
                            outputCategory4.Column7 = Convert.ToInt32(outputCategory4String[5]);
                            outputCategory4.Column8 = outputCategory4String[6];

                            outputCategory4List.Add(outputCategory4);
                        }
                    }
                    result.OutputCategories4 = outputCategory4List;
                }

                #endregion

                result.InputCategories1TotalAmount = vatTaxDeclaration.InputCategory1TotalAmount ?? 0;
                result.InputCategories2TotalAmount = vatTaxDeclaration.InputCategory2TotalAmount ?? 0;
                result.InputCategories3TotalAmount = vatTaxDeclaration.InputCategory3TotalAmount ?? 0;
                result.InputCategories1TotalTaxAmount = vatTaxDeclaration.InputCategory1TotalTaxAmount ?? 0;
                result.InputCategories2TotalTaxAmount = vatTaxDeclaration.InputCategory2TotalTaxAmount ?? 0;
                result.InputCategories3TotalTaxAmount = vatTaxDeclaration.InputCategory3TotalTaxAmount ?? 0;
                result.InputTotalAmount = vatTaxDeclaration.InputTotalAmountValue23;
                result.InputTotalTaxAmount = vatTaxDeclaration.InputTotalTaxAmountValue24;

                result.OutputCategories1TotalAmount = vatTaxDeclaration.OutputCategory1TotalAmountValue26 ?? 0;
                result.OutputCategories2TotalAmount = vatTaxDeclaration.OutputCategory2TotalAmountValue29 ?? 0;
                result.OutputCategories3TotalAmount = vatTaxDeclaration.OutputCategory3TotalAmountValue30 ?? 0;
                result.OutputCategories4TotalAmount = vatTaxDeclaration.OutputCategory4TotalAmountValue32 ?? 0;

                result.OutputCategories3TotalTaxAmount = vatTaxDeclaration.OutputCategory3TotalTaxAmountValue31 ?? 0;
                result.OutputCategories4TotalTaxAmount = vatTaxDeclaration.OutputCategory4TotalTaxAmountValue33 ?? 0;
                result.OutputTotalAmount = vatTaxDeclaration.OutputTotalAmountValue34;
                result.HaveTaxOutputAmount = vatTaxDeclaration.HaveTaxOutputTotalAmountValue27;
                result.OutputTotalTaxAmount = vatTaxDeclaration.OutputTotalTaxAmountValue28;

                if (result.InputTotalAmount == 0 && result.OutputCategories1TotalAmount == 0 &&
                    result.HaveTaxOutputAmount == 0)
                {
                    result.Value21 = true;
                }
                else
                {
                    result.Value21 = false;
                }
            }
            return result;
        }
예제 #2
0
        public ActionResult ExportVatTaxDeclaration(FormCollection form)
        {
            try
            {

                #region Get data from Form
                string taxQuarter = form["taxQuarter"];
                string taxYear = form["taxYear"];

                string storeOwnerName = form["storeOwnerName"];
                string storeTaxcode = form["storeTaxcode"].Replace(",", "");
                string storeAddress = form["storeAddress"];
                string storeDistrict = form["storeDistrict"];
                string storeProvince = form["storeProvince"];
                string storePhone = form["storePhone"];
                string storeFax = form["storeFax"];
                string storeEmail = form["storeEmail"];

                string vatAgentOwnerName = form["vatAgentOwnerName"];
                string vatAgentName = form["agentName"];
                string vatAgentTaxCode = form["agentTaxCode"].Replace(",", "");
                string vatAgentNo = form["agentNo"];
                string vatAgentAddress = form["vatAgentAddress"];
                string vatAgentDistrict = form["vatAgentDistrict"];
                string vatAgentProvince = form["vatAgentProvince"];
                string vatAgentPhone = form["vatAgentPhone"];
                string vatAgentFax = form["vatAgentFax"];
                string vatAgentEmail = form["vatAgentEmail"];

                string value20No = form["value20No"];
                string value20Date = form["value20Date"];
                string value21 = form["value21"];
                string value22 = form["value22"].Replace(".", "");
                string value25 = form["value25"].Replace(".", "");
                string value36 = form["value36"].Replace(".", "");
                string value37 = form["value37"].Replace(".", "");
                string value38 = form["value38"].Replace(".", "");
                string value39 = form["value39"].Replace(".", "");
                string value40a = form["value40a"].Replace(".", "");
                string value40b = form["value40b"].Replace(".", "");
                string value40 = form["value40"].Replace(".", "");
                string value41 = form["value41"].Replace(".", "");
                string value42 = form["value42"].Replace(".", "");
                string value43 = form["value43"].Replace(".", "");

                string signName = form["signName"];
                string createDate = form["createDate"];
                string createLocation = form["createLocation"];

                string outputCategory1Column2 = form["output_category1_column2"];
                string outputCategory1Column3 = form["output_category1_column3"];
                string outputCategory1Column4 = form["output_category1_column4"];
                string outputCategory1Column5 = form["output_category1_column5"];
                string outputCategory1Column6 = form["output_category1_column6"];
                string outputCategory1Column7 = form["output_category1_column7"];
                string outputCategory1Column8 = form["output_category1_column8"];

                string outputCategory2Column2 = form["output_category2_column2"];
                string outputCategory2Column3 = form["output_category2_column3"];
                string outputCategory2Column4 = form["output_category2_column4"];
                string outputCategory2Column5 = form["output_category2_column5"];
                string outputCategory2Column6 = form["output_category2_column6"];
                string outputCategory2Column7 = form["output_category2_column7"];
                string outputCategory2Column8 = form["output_category2_column8"];

                string outputCategory3Column2 = form["output_category3_column2"];
                string outputCategory3Column3 = form["output_category3_column3"];
                string outputCategory3Column4 = form["output_category3_column4"];
                string outputCategory3Column5 = form["output_category3_column5"];
                string outputCategory3Column6 = form["output_category3_column6"];
                string outputCategory3Column7 = form["output_category3_column7"];
                string outputCategory3Column8 = form["output_category3_column8"];

                string outputCategory4Column2 = form["output_category4_column2"];
                string outputCategory4Column3 = form["output_category4_column3"];
                string outputCategory4Column4 = form["output_category4_column4"];
                string outputCategory4Column5 = form["output_category4_column5"];
                string outputCategory4Column6 = form["output_category4_column6"];
                string outputCategory4Column7 = form["output_category4_column7"];
                string outputCategory4Column8 = form["output_category4_column8"];

                string inputCategory1Column2 = form["input_category1_column2"];
                string inputCategory1Column3 = form["input_category1_column3"];
                string inputCategory1Column4 = form["input_category1_column4"];
                string inputCategory1Column5 = form["input_category1_column5"];
                string inputCategory1Column6 = form["input_category1_column6"];
                string inputCategory1Column7 = form["input_category1_column7"];
                string inputCategory1Column8 = form["input_category1_column8"];

                string inputCategory2Column2 = form["input_category2_column2"];
                string inputCategory2Column3 = form["input_category2_column3"];
                string inputCategory2Column4 = form["input_category2_column4"];
                string inputCategory2Column5 = form["input_category2_column5"];
                string inputCategory2Column6 = form["input_category2_column6"];
                string inputCategory2Column7 = form["input_category2_column7"];
                string inputCategory2Column8 = form["input_category2_column8"];

                string inputCategory3Column2 = form["input_category3_column2"];
                string inputCategory3Column3 = form["input_category3_column3"];
                string inputCategory3Column4 = form["input_category3_column4"];
                string inputCategory3Column5 = form["input_category3_column5"];
                string inputCategory3Column6 = form["input_category3_column6"];
                string inputCategory3Column7 = form["input_category3_column7"];
                string inputCategory3Column8 = form["input_category3_column8"];

                #endregion

                #region Process Data

                DeclarationVatForm vatForm = new DeclarationVatForm();

                #region Output

                int totalOutputAmount = 0;
                int haveTaxTotalOutputAmount = 0;
                int totalTaxOutputAmount = 0;

                #region OutputCategory1

                List<DeclarationVatCategory> outputCategory1List = new List<DeclarationVatCategory>();

                if (outputCategory1Column4 != null)
                {
                    string[] outputCategory1Column2Array = outputCategory1Column2.Split(',');
                    string[] outputCategory1Column3Array = outputCategory1Column3.Split(',');
                    string[] outputCategory1Column4Array = outputCategory1Column4.Split(',');
                    string[] outputCategory1Column5Array = outputCategory1Column5.Split(',');
                    string[] outputCategory1Column6Array = outputCategory1Column6.Split(',');
                    string[] outputCategory1Column7Array = outputCategory1Column7.Split(',');
                    string[] outputCategory1Column8Array = outputCategory1Column8.Split(',');

                    int totalOutputCategory1 = 0;

                    for (int i = 0; i < outputCategory1Column4Array.Length; i++)
                    {
                        DeclarationVatCategory outputCategory1 = new DeclarationVatCategory();

                        outputCategory1.Column2 = outputCategory1Column2Array[i];
                        outputCategory1.Column3 = DateTime.ParseExact(outputCategory1Column3Array[i], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                        outputCategory1.Column4 = outputCategory1Column4Array[i];
                        outputCategory1.Column5 = outputCategory1Column5Array[i];
                        outputCategory1.Column6 = Convert.ToInt32(outputCategory1Column6Array[i].Replace(".", ""));
                        outputCategory1.Column7 = Convert.ToInt32(outputCategory1Column7Array[i].Replace(".", ""));
                        outputCategory1.Column8 = outputCategory1Column8Array[i];

                        int categoryColumn6Number = Convert.ToInt32(outputCategory1Column6Array[i].Replace(".", ""));
                        totalOutputCategory1 += categoryColumn6Number;

                        outputCategory1List.Add(outputCategory1);
                    }

                    vatForm.OutputCategories1TotalAmount = totalOutputCategory1;

                    totalOutputAmount += totalOutputCategory1;
                }

                vatForm.OutputCategories1 = outputCategory1List;

                #endregion

                #region OutputCategory2

                List<DeclarationVatCategory> outputCategory2List = new List<DeclarationVatCategory>();

                if (outputCategory2Column4 != null)
                {
                    string[] outputCategory2Column2Array = outputCategory2Column2.Split(',');
                    string[] outputCategory2Column3Array = outputCategory2Column3.Split(',');
                    string[] outputCategory2Column4Array = outputCategory2Column4.Split(',');
                    string[] outputCategory2Column5Array = outputCategory2Column5.Split(',');
                    string[] outputCategory2Column6Array = outputCategory2Column6.Split(',');
                    string[] outputCategory2Column7Array = outputCategory2Column7.Split(',');
                    string[] outputCategory2Column8Array = outputCategory2Column8.Split(',');

                    int totalOutputCategory2 = 0;

                    for (int i = 0; i < outputCategory2Column4Array.Length; i++)
                    {
                        DeclarationVatCategory outputCategory2 = new DeclarationVatCategory();

                        outputCategory2.Column2 = outputCategory2Column2Array[i];
                        outputCategory2.Column3 = DateTime.ParseExact(outputCategory2Column3Array[i], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                        outputCategory2.Column4 = outputCategory2Column4Array[i];
                        outputCategory2.Column5 = outputCategory2Column5Array[i];
                        outputCategory2.Column6 = Convert.ToInt32(outputCategory2Column6Array[i].Replace(".", ""));
                        outputCategory2.Column7 = Convert.ToInt32(outputCategory2Column7Array[i].Replace(".", ""));
                        outputCategory2.Column8 = outputCategory2Column8Array[i];

                        int categoryColumn6Number = Convert.ToInt32(outputCategory2Column6Array[i].Replace(".", ""));
                        totalOutputCategory2 += categoryColumn6Number;

                        outputCategory2List.Add(outputCategory2);
                    }

                    vatForm.OutputCategories2TotalAmount = totalOutputCategory2;

                    haveTaxTotalOutputAmount += totalOutputCategory2;
                    totalOutputAmount += totalOutputCategory2;
                }

                vatForm.OutputCategories2 = outputCategory2List;

                #endregion

                #region OutputCategory3

                List<DeclarationVatCategory> outputCategory3List = new List<DeclarationVatCategory>();

                if (outputCategory3Column4 != null)
                {
                    string[] outputCategory3Column2Array = outputCategory3Column2.Split(',');
                    string[] outputCategory3Column3Array = outputCategory3Column3.Split(',');
                    string[] outputCategory3Column4Array = outputCategory3Column4.Split(',');
                    string[] outputCategory3Column5Array = outputCategory3Column5.Split(',');
                    string[] outputCategory3Column6Array = outputCategory3Column6.Split(',');
                    string[] outputCategory3Column7Array = outputCategory3Column7.Split(',');
                    string[] outputCategory3Column8Array = outputCategory3Column8.Split(',');

                    int totalOutputCategory3 = 0;
                    int totalTaxOutputCategory3 = 0;

                    for (int i = 0; i < outputCategory3Column4Array.Length; i++)
                    {
                        DeclarationVatCategory outputCategory3 = new DeclarationVatCategory();

                        outputCategory3.Column2 = outputCategory3Column2Array[i];
                        outputCategory3.Column3 = DateTime.ParseExact(outputCategory3Column3Array[i], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                        outputCategory3.Column4 = outputCategory3Column4Array[i];
                        outputCategory3.Column5 = outputCategory3Column5Array[i];
                        outputCategory3.Column6 = Convert.ToInt32(outputCategory3Column6Array[i].Replace(".", ""));
                        outputCategory3.Column7 = Convert.ToInt32(outputCategory3Column7Array[i].Replace(".", ""));
                        outputCategory3.Column8 = outputCategory3Column8Array[i];

                        int categoryColumn6Number = Convert.ToInt32(outputCategory3Column6Array[i].Replace(".", ""));
                        totalOutputCategory3 += categoryColumn6Number;

                        int categoryColumn7Number = Convert.ToInt32(outputCategory3Column7Array[i].Replace(".", ""));
                        totalTaxOutputCategory3 += categoryColumn7Number;

                        outputCategory3List.Add(outputCategory3);
                    }

                    vatForm.OutputCategories3TotalAmount = totalOutputCategory3;
                    vatForm.OutputCategories3TotalTaxAmount = totalTaxOutputCategory3;

                    totalOutputAmount += totalOutputCategory3;
                    haveTaxTotalOutputAmount += totalOutputCategory3;
                    totalTaxOutputAmount += totalTaxOutputCategory3;
                }

                vatForm.OutputCategories3 = outputCategory3List;

                #endregion

                #region OutputCategory4

                List<DeclarationVatCategory> outputCategory4List = new List<DeclarationVatCategory>();

                if (outputCategory4Column4 != null)
                {
                    string[] outputCategory4Column2Array = outputCategory4Column2.Split(',');
                    string[] outputCategory4Column3Array = outputCategory4Column3.Split(',');
                    string[] outputCategory4Column4Array = outputCategory4Column4.Split(',');
                    string[] outputCategory4Column5Array = outputCategory4Column5.Split(',');
                    string[] outputCategory4Column6Array = outputCategory4Column6.Split(',');
                    string[] outputCategory4Column7Array = outputCategory4Column7.Split(',');
                    string[] outputCategory4Column8Array = outputCategory4Column8.Split(',');

                    int totalOutputCategory4 = 0;
                    int totalTaxOutputCategory4 = 0;

                    for (int i = 0; i < outputCategory4Column4Array.Length; i++)
                    {
                        DeclarationVatCategory outputCategory4 = new DeclarationVatCategory();

                        outputCategory4.Column2 = outputCategory4Column2Array[i];
                        outputCategory4.Column3 = DateTime.ParseExact(outputCategory4Column3Array[i], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                        outputCategory4.Column4 = outputCategory4Column4Array[i];
                        outputCategory4.Column5 = outputCategory4Column5Array[i];
                        outputCategory4.Column6 = Convert.ToInt32(outputCategory4Column6Array[i].Replace(".", ""));
                        outputCategory4.Column7 = Convert.ToInt32(outputCategory4Column7Array[i].Replace(".", ""));
                        outputCategory4.Column8 = outputCategory4Column8Array[i];

                        int categoryColumn6Number = Convert.ToInt32(outputCategory4Column6Array[i].Replace(".", ""));
                        totalOutputCategory4 += categoryColumn6Number;

                        int categoryColumn7Number = Convert.ToInt32(outputCategory4Column7Array[i].Replace(".", ""));
                        totalTaxOutputCategory4 += categoryColumn7Number;

                        outputCategory4List.Add(outputCategory4);
                    }

                    vatForm.OutputCategories4TotalAmount = totalOutputCategory4;
                    vatForm.OutputCategories4TotalTaxAmount = totalTaxOutputCategory4;

                    totalOutputAmount += totalOutputCategory4;
                    haveTaxTotalOutputAmount += totalOutputCategory4;
                    totalTaxOutputAmount += totalTaxOutputCategory4;
                }

                vatForm.OutputCategories4 = outputCategory4List;

                #endregion

                vatForm.OutputTotalAmount = totalOutputAmount;
                vatForm.OutputTotalTaxAmount = totalTaxOutputAmount;
                vatForm.HaveTaxOutputAmount = haveTaxTotalOutputAmount;

                #endregion

                #region Input

                int totalInputAmount = 0;
                int totalTaxInputAmount = 0;

                #region InputCategory1

                List<DeclarationVatCategory> inputCategory1List = new List<DeclarationVatCategory>();

                if (inputCategory1Column4 != null)
                {
                    string[] inputCategory1Column2Array = inputCategory1Column2.Split(',');
                    string[] inputCategory1Column3Array = inputCategory1Column3.Split(',');
                    string[] inputCategory1Column4Array = inputCategory1Column4.Split(',');
                    string[] inputCategory1Column5Array = inputCategory1Column5.Split(',');
                    string[] inputCategory1Column6Array = inputCategory1Column6.Split(',');
                    string[] inputCategory1Column7Array = inputCategory1Column7.Split(',');
                    string[] inputCategory1Column8Array = inputCategory1Column8.Split(',');

                    int totalInputCategory1 = 0;
                    int totalTaxInputCategory1 = 0;

                    for (int i = 0; i < inputCategory1Column4Array.Length; i++)
                    {
                        DeclarationVatCategory inputCategory1 = new DeclarationVatCategory();

                        inputCategory1.Column2 = inputCategory1Column2Array[i];
                        inputCategory1.Column3 = DateTime.ParseExact(inputCategory1Column3Array[i], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                        inputCategory1.Column4 = inputCategory1Column4Array[i];
                        inputCategory1.Column5 = inputCategory1Column5Array[i];
                        inputCategory1.Column6 = Convert.ToInt32(inputCategory1Column6Array[i].Replace(".", ""));
                        inputCategory1.Column7 = Convert.ToInt32(inputCategory1Column7Array[i].Replace(".", ""));
                        inputCategory1.Column8 = inputCategory1Column8Array[i];

                        int categoryColumn6Number = Convert.ToInt32(inputCategory1Column6Array[i].Replace(".", ""));
                        totalInputCategory1 += categoryColumn6Number;

                        int categoryColumn7Number = Convert.ToInt32(inputCategory1Column7Array[i].Replace(".", ""));
                        totalTaxInputCategory1 += categoryColumn7Number;

                        inputCategory1List.Add(inputCategory1);
                    }

                    vatForm.InputCategories1TotalAmount = totalInputCategory1;
                    vatForm.InputCategories1TotalTaxAmount = totalTaxInputCategory1;

                    totalInputAmount += totalInputCategory1;
                    totalTaxInputAmount += totalTaxInputCategory1;
                }

                vatForm.InputCategories1 = inputCategory1List;

                #endregion

                #region InputCategory2

                List<DeclarationVatCategory> inputCategory2List = new List<DeclarationVatCategory>();

                if (inputCategory2Column4 != null)
                {
                    string[] inputCategory2Column2Array = inputCategory2Column2.Split(',');
                    string[] inputCategory2Column3Array = inputCategory2Column3.Split(',');
                    string[] inputCategory2Column4Array = inputCategory2Column4.Split(',');
                    string[] inputCategory2Column5Array = inputCategory2Column5.Split(',');
                    string[] inputCategory2Column6Array = inputCategory2Column6.Split(',');
                    string[] inputCategory2Column7Array = inputCategory2Column7.Split(',');
                    string[] inputCategory2Column8Array = inputCategory2Column8.Split(',');

                    int totalInputCategory2 = 0;
                    int totalTaxInputCategory2 = 0;

                    for (int i = 0; i < inputCategory2Column4Array.Length; i++)
                    {
                        DeclarationVatCategory inputCategory2 = new DeclarationVatCategory();

                        inputCategory2.Column2 = inputCategory2Column2Array[i];
                        inputCategory2.Column3 = DateTime.ParseExact(inputCategory2Column3Array[i], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                        inputCategory2.Column4 = inputCategory2Column4Array[i];
                        inputCategory2.Column5 = inputCategory2Column5Array[i];
                        inputCategory2.Column6 = Convert.ToInt32(inputCategory2Column6Array[i].Replace(".", ""));
                        inputCategory2.Column7 = Convert.ToInt32(inputCategory2Column7Array[i].Replace(".", ""));
                        inputCategory2.Column8 = inputCategory2Column8Array[i];

                        int categoryColumn6Number = Convert.ToInt32(inputCategory2Column6Array[i].Replace(".", ""));
                        totalInputCategory2 += categoryColumn6Number;

                        int categoryColumn7Number = Convert.ToInt32(inputCategory2Column7Array[i].Replace(".", ""));
                        totalTaxInputCategory2 += categoryColumn7Number;

                        inputCategory2List.Add(inputCategory2);
                    }

                    vatForm.InputCategories2TotalAmount = totalInputCategory2;
                    vatForm.InputCategories2TotalTaxAmount = totalTaxInputCategory2;

                    totalInputAmount += totalInputCategory2;
                    totalTaxInputAmount += totalTaxInputCategory2;
                }

                vatForm.InputCategories2 = inputCategory2List;

                #endregion

                #region InputCategory3

                List<DeclarationVatCategory> inputCategory3List = new List<DeclarationVatCategory>();

                if (inputCategory3Column4 != null)
                {
                    string[] inputCategory3Column2Array = inputCategory3Column2.Split(',');
                    string[] inputCategory3Column3Array = inputCategory3Column3.Split(',');
                    string[] inputCategory3Column4Array = inputCategory3Column4.Split(',');
                    string[] inputCategory3Column5Array = inputCategory3Column5.Split(',');
                    string[] inputCategory3Column6Array = inputCategory3Column6.Split(',');
                    string[] inputCategory3Column7Array = inputCategory3Column7.Split(',');
                    string[] inputCategory3Column8Array = inputCategory3Column8.Split(',');

                    int totalInputCategory3 = 0;
                    int totalTaxInputCategory3 = 0;

                    for (int i = 0; i < inputCategory3Column4Array.Length; i++)
                    {
                        DeclarationVatCategory inputCategory3 = new DeclarationVatCategory();

                        inputCategory3.Column2 = inputCategory3Column2Array[i];
                        inputCategory3.Column3 = DateTime.ParseExact(inputCategory3Column3Array[i], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                        inputCategory3.Column4 = inputCategory3Column4Array[i];
                        inputCategory3.Column5 = inputCategory3Column5Array[i];
                        inputCategory3.Column6 = Convert.ToInt32(inputCategory3Column6Array[i].Replace(".", ""));
                        inputCategory3.Column7 = Convert.ToInt32(inputCategory3Column7Array[i].Replace(".", ""));
                        inputCategory3.Column8 = inputCategory3Column8Array[i];

                        int categoryColumn6Number = Convert.ToInt32(inputCategory3Column6Array[i].Replace(".", ""));
                        totalInputCategory3 += categoryColumn6Number;

                        int categoryColumn7Number = Convert.ToInt32(inputCategory3Column7Array[i].Replace(".", ""));
                        totalTaxInputCategory3 += categoryColumn7Number;

                        inputCategory3List.Add(inputCategory3);
                    }

                    vatForm.InputCategories3TotalAmount = totalInputCategory3;
                    vatForm.InputCategories3TotalTaxAmount = totalTaxInputCategory3;

                }

                vatForm.InputCategories3 = inputCategory3List;

                #endregion

                vatForm.InputTotalAmount = totalInputAmount;
                vatForm.InputTotalTaxAmount = totalTaxInputAmount;

                #endregion

                #endregion

                #region Create XML File

                XElement root = new XElement("HSoThueDTu");

                XElement HSoKhaiThue = new XElement("HSoKhaiThue");
                HSoKhaiThue.Add(new XAttribute("id", "ID_18"));

                XElement TTinChung = new XElement("TTinChung");

                XElement TTinDVu = new XElement("TTinDVu");

                XElement maDVu = new XElement("maDVu", "HTKK");
                TTinDVu.Add(maDVu);
                XElement tenDVu = new XElement("tenDVu", "HTKK");
                TTinDVu.Add(tenDVu);
                XElement pbanDVu = new XElement("pbanDVu", "3.3.4");
                TTinDVu.Add(pbanDVu);

                TTinChung.Add(TTinDVu);

                XElement TTinTKhaiThue = new XElement("TTinTKhaiThue");

                XElement TKhaiThue = new XElement("TKhaiThue");

                XElement maTKhai = new XElement("maTKhai", "01");
                TKhaiThue.Add(maTKhai);

                XElement tenTKhai = new XElement("tenTKhai", "TỜ KHAI THUẾ GIÁ TRỊ GIA TĂNG (Mẫu số 01/GTGT)");
                TKhaiThue.Add(tenTKhai);

                XElement moTaBMau = new XElement("moTaBMau", "(Ban hành kèm theo Thông tư số 119/2014/TT-BTC ngày 25/8/2014 của Bộ Tài chính)");
                TKhaiThue.Add(moTaBMau);

                XElement pbanTKhaiXML = new XElement("pbanTKhaiXML", "2.0.7");
                TKhaiThue.Add(pbanTKhaiXML);

                XElement loaiTKhai = new XElement("loaiTKhai", "C");
                TKhaiThue.Add(loaiTKhai);

                XElement soLan = new XElement("soLan", "0");
                TKhaiThue.Add(soLan);

                XElement KyKKhaiThue = new XElement("KyKKhaiThue");

                XElement kieuKy = new XElement("kieuKy", "Q");
                KyKKhaiThue.Add(kieuKy);

                XElement kyKKhai = new XElement("kyKKhai", taxQuarter + "/" + taxYear);
                KyKKhaiThue.Add(kyKKhai);

                XElement kyKKhaiTuNgay = new XElement("kyKKhaiTuNgay", "01/" + (Convert.ToInt32(taxQuarter) * 3 - 2) + "/" + taxYear);
                KyKKhaiThue.Add(kyKKhaiTuNgay);

                XElement kyKKhaiDenNgay = new XElement("kyKKhaiDenNgay", new DateTime(Convert.ToInt32(taxYear), (Convert.ToInt32(taxQuarter) * 3), 1).AddMonths(1).AddDays(-1).ToString("dd/MM/yyyy"));
                KyKKhaiThue.Add(kyKKhaiDenNgay);

                XElement kyKKhaiTuThang = new XElement("kyKKhaiTuThang");
                KyKKhaiThue.Add(kyKKhaiTuThang);

                XElement kyKKhaiDenThang = new XElement("kyKKhaiDenThang");
                KyKKhaiThue.Add(kyKKhaiDenThang);

                TKhaiThue.Add(KyKKhaiThue);

                XElement maCQTNoiNop = new XElement("maCQTNoiNop");
                TKhaiThue.Add(maCQTNoiNop);

                XElement tenCQTNoiNop = new XElement("tenCQTNoiNop", "Chi cục Thuế Quận 12");
                TKhaiThue.Add(tenCQTNoiNop);

                XElement ngayLapTKhai = new XElement("ngayLapTKhai", createDate);
                TKhaiThue.Add(ngayLapTKhai);

                XElement GiaHan = new XElement("GiaHan");

                XElement maLyDoGiaHan = new XElement("maLyDoGiaHan");
                GiaHan.Add(maLyDoGiaHan);

                XElement lyDoGiaHan = new XElement("lyDoGiaHan");
                GiaHan.Add(lyDoGiaHan);

                TKhaiThue.Add(GiaHan);

                XElement nguoiKy = new XElement("nguoiKy", signName);
                TKhaiThue.Add(nguoiKy);

                XElement ngayKy = new XElement("ngayKy", createDate);
                TKhaiThue.Add(ngayKy);

                XElement nganhNgheKD = new XElement("nganhNgheKD");
                TKhaiThue.Add(nganhNgheKD);

                TTinTKhaiThue.Add(TKhaiThue);

                XElement NNT = new XElement("NNT");

                XElement mst = new XElement("mst", storeTaxcode);
                NNT.Add(mst);

                XElement tenNNT = new XElement("tenNNT", storeOwnerName);
                NNT.Add(tenNNT);

                XElement dchiNNT = new XElement("dchiNNT", storeAddress);
                NNT.Add(dchiNNT);

                XElement phuongXa = new XElement("phuongXa");
                NNT.Add(phuongXa);

                XElement maHuyenNNT = new XElement("maHuyenNNT");
                NNT.Add(maHuyenNNT);

                XElement tenHuyenNNT = new XElement("tenHuyenNNT", storeDistrict);
                NNT.Add(tenHuyenNNT);

                XElement maTinhNNT = new XElement("maTinhNNT");
                NNT.Add(maTinhNNT);

                XElement tenTinhNNT = new XElement("tenTinhNNT", storeProvince);
                NNT.Add(tenTinhNNT);

                XElement dthoaiNNT = new XElement("dthoaiNNT", storePhone);
                NNT.Add(dthoaiNNT);

                XElement faxNNT = new XElement("faxNNT", storeFax);
                NNT.Add(faxNNT);

                XElement emailNNT = new XElement("emailNNT", storeEmail);
                NNT.Add(emailNNT);

                TTinTKhaiThue.Add(NNT);

                XElement DLyThue = new XElement("DLyThue");

                XElement mstDLyThue = new XElement("mstDLyThue", vatAgentTaxCode);
                DLyThue.Add(mstDLyThue);

                XElement tenDLyThue = new XElement("tenDLyThue", vatAgentOwnerName);
                DLyThue.Add(tenDLyThue);

                XElement dchiDLyThue = new XElement("dchiDLyThue", vatAgentAddress);
                DLyThue.Add(dchiDLyThue);

                XElement maHuyenDLyThue = new XElement("maHuyenDLyThue");
                DLyThue.Add(maHuyenDLyThue);

                XElement tenHuyenDLyThue = new XElement("tenHuyenDLyThue", vatAgentDistrict);
                DLyThue.Add(tenHuyenDLyThue);

                XElement maTinhDLyThue = new XElement("maTinhDLyThue");
                DLyThue.Add(maTinhDLyThue);

                XElement tenTinhDLyThue = new XElement("tenTinhDLyThue", vatAgentProvince);
                DLyThue.Add(tenTinhDLyThue);

                XElement dthoaiDLyThue = new XElement("dthoaiDLyThue", vatAgentPhone);
                DLyThue.Add(dthoaiDLyThue);

                XElement faxDLyThue = new XElement("faxDLyThue", vatAgentFax);
                DLyThue.Add(faxDLyThue);

                XElement emailDLyThue = new XElement("emailDLyThue", vatAgentEmail);
                DLyThue.Add(emailDLyThue);

                XElement soHDongDLyThue = new XElement("soHDongDLyThue", value20No);
                DLyThue.Add(soHDongDLyThue);

                XElement ngayKyHDDLyThue = new XElement("ngayKyHDDLyThue", value20Date);
                DLyThue.Add(ngayKyHDDLyThue);

                XElement NVienDLy = new XElement("NVienDLy");

                XElement tenNVienDLyThue = new XElement("tenNVienDLyThue", vatAgentName);
                NVienDLy.Add(tenNVienDLyThue);

                XElement cchiHNghe = new XElement("cchiHNghe", vatAgentNo);
                NVienDLy.Add(cchiHNghe);

                DLyThue.Add(NVienDLy);

                TTinTKhaiThue.Add(DLyThue);

                TTinChung.Add(TTinTKhaiThue);

                HSoKhaiThue.Add(TTinChung);

                XElement CTieuTKhaiChinh = new XElement("CTieuTKhaiChinh");

                XElement tieuMucHachToan = new XElement("tieuMucHachToan", "1701");
                CTieuTKhaiChinh.Add(tieuMucHachToan);

                XElement ct21 = new XElement("ct21", value21);
                CTieuTKhaiChinh.Add(ct21);

                XElement ct22 = new XElement("ct22", value22);
                CTieuTKhaiChinh.Add(ct22);

                XElement GiaTriVaThueGTGTHHDVMuaVao = new XElement("GiaTriVaThueGTGTHHDVMuaVao");

                XElement ct23 = new XElement("ct23", vatForm.InputTotalAmount);
                GiaTriVaThueGTGTHHDVMuaVao.Add(ct23);

                XElement ct24 = new XElement("ct24", vatForm.InputTotalTaxAmount);
                GiaTriVaThueGTGTHHDVMuaVao.Add(ct24);

                CTieuTKhaiChinh.Add(GiaTriVaThueGTGTHHDVMuaVao);

                XElement ct25 = new XElement("ct25", value25);
                CTieuTKhaiChinh.Add(ct25);

                XElement ct26 = new XElement("ct26", vatForm.OutputCategories1TotalAmount);
                CTieuTKhaiChinh.Add(ct26);

                XElement HHDVBRaChiuThueGTGT = new XElement("HHDVBRaChiuThueGTGT");

                XElement ct27 = new XElement("ct27", vatForm.HaveTaxOutputAmount);
                HHDVBRaChiuThueGTGT.Add(ct27);

                XElement ct28 = new XElement("ct28", vatForm.OutputTotalTaxAmount);
                HHDVBRaChiuThueGTGT.Add(ct28);

                CTieuTKhaiChinh.Add(HHDVBRaChiuThueGTGT);

                XElement ct29 = new XElement("ct29", vatForm.OutputCategories2TotalAmount);
                CTieuTKhaiChinh.Add(ct29);

                XElement HHDVBRaChiuTSuat5 = new XElement("HHDVBRaChiuTSuat5");

                XElement ct30 = new XElement("ct30", vatForm.OutputCategories3TotalAmount);
                HHDVBRaChiuTSuat5.Add(ct30);

                XElement ct31 = new XElement("ct31", vatForm.OutputCategories3TotalTaxAmount);
                HHDVBRaChiuTSuat5.Add(ct31);

                CTieuTKhaiChinh.Add(HHDVBRaChiuTSuat5);

                XElement HHDVBRaChiuTSuat10 = new XElement("HHDVBRaChiuTSuat10");

                XElement ct32 = new XElement("ct32", vatForm.OutputCategories4TotalAmount);
                HHDVBRaChiuTSuat10.Add(ct32);

                XElement ct33 = new XElement("ct33", vatForm.OutputCategories4TotalTaxAmount);
                HHDVBRaChiuTSuat10.Add(ct33);

                CTieuTKhaiChinh.Add(HHDVBRaChiuTSuat10);

                XElement TongDThuVaThueGTGTHHDVBRa = new XElement("TongDThuVaThueGTGTHHDVBRa");

                XElement ct34 = new XElement("ct34", vatForm.OutputTotalAmount);
                TongDThuVaThueGTGTHHDVBRa.Add(ct34);

                XElement ct35 = new XElement("ct35", vatForm.OutputTotalTaxAmount);
                TongDThuVaThueGTGTHHDVBRa.Add(ct35);

                CTieuTKhaiChinh.Add(TongDThuVaThueGTGTHHDVBRa);

                XElement ct36 = new XElement("ct36", value36);
                CTieuTKhaiChinh.Add(ct36);

                XElement ct37 = new XElement("ct37", value37);
                CTieuTKhaiChinh.Add(ct37);

                XElement ct38 = new XElement("ct38", value38);
                CTieuTKhaiChinh.Add(ct38);

                XElement ct39 = new XElement("ct39", value39);
                CTieuTKhaiChinh.Add(ct39);

                XElement ct40 = new XElement("ct40", value40);
                CTieuTKhaiChinh.Add(ct40);

                XElement ct40a = new XElement("ct40a", value40a);
                CTieuTKhaiChinh.Add(ct40a);

                XElement ct40b = new XElement("ct40b", value40b);
                CTieuTKhaiChinh.Add(ct40b);

                XElement ct41 = new XElement("ct41", value41);
                CTieuTKhaiChinh.Add(ct41);

                XElement ct42 = new XElement("ct42", value42);
                CTieuTKhaiChinh.Add(ct42);

                XElement ct43 = new XElement("ct43", value43);
                CTieuTKhaiChinh.Add(ct43);

                HSoKhaiThue.Add(CTieuTKhaiChinh);

                XElement PLuc = new XElement("PLuc");

                #region PL01_1_GTGT
                XElement PL01_1_GTGT = new XElement("PL01_1_GTGT");

                XElement HHDVKChiuThue = new XElement("HHDVKChiuThue");

                XElement ChiTietHHDVKChiuThue = new XElement("ChiTietHHDVKChiuThue");
                if (vatForm.OutputCategories1 != null && vatForm.OutputCategories1.Count > 0)
                {
                    for (int i = 0; i < vatForm.OutputCategories1.Count; i++)
                    {
                        XElement HDonBRa = new XElement("HDonBRa");
                        HDonBRa.Add(new XAttribute("id", "ID_" + (i + 1)));

                        XElement kyHieuMauHDon = new XElement("kyHieuMauHDon");
                        HDonBRa.Add(kyHieuMauHDon);

                        XElement kyHieuHDon = new XElement("kyHieuHDon");
                        HDonBRa.Add(kyHieuHDon);

                        XElement soHDon = new XElement("soHDon", vatForm.OutputCategories1.ElementAt(i).Column2);
                        HDonBRa.Add(soHDon);

                        XElement ngayPHanh = new XElement("ngayPHanh", vatForm.OutputCategories1.ElementAt(i).Column3.ToString("yyyy-MM-dd"));
                        HDonBRa.Add(ngayPHanh);

                        XElement tenNMUA = new XElement("tenNMUA", vatForm.OutputCategories1.ElementAt(i).Column4);
                        HDonBRa.Add(tenNMUA);

                        XElement mstNMUA = new XElement("mstNMUA", vatForm.OutputCategories1.ElementAt(i).Column5);
                        HDonBRa.Add(mstNMUA);

                        XElement matHang = new XElement("matHang");
                        HDonBRa.Add(matHang);

                        XElement dsoBanChuaThue = new XElement("dsoBanChuaThue", vatForm.OutputCategories1.ElementAt(i).Column6);
                        HDonBRa.Add(dsoBanChuaThue);

                        XElement thueGTGT = new XElement("thueGTGT", vatForm.OutputCategories1.ElementAt(i).Column7);
                        HDonBRa.Add(thueGTGT);

                        XElement ghiChu = new XElement("ghiChu", vatForm.OutputCategories1.ElementAt(i).Column8);

                        ChiTietHHDVKChiuThue.Add(HDonBRa);
                    }
                }

                HHDVKChiuThue.Add(ChiTietHHDVKChiuThue);

                XElement tongDThuBRaKChiuThue = new XElement("tongDThuBRaKChiuThue", vatForm.OutputCategories1TotalAmount);
                HHDVKChiuThue.Add(tongDThuBRaKChiuThue);

                PL01_1_GTGT.Add(HHDVKChiuThue);

                #region 0%

                XElement HHDVThue0 = new XElement("HHDVThue0");

                XElement ChiTietHHDVThue0 = new XElement("ChiTietHHDVThue0");
                if (vatForm.OutputCategories2 != null && vatForm.OutputCategories2.Count > 0)
                {
                    for (int i = 0; i < vatForm.OutputCategories2.Count; i++)
                    {
                        XElement HDonBRa = new XElement("HDonBRa");
                        HDonBRa.Add(new XAttribute("id", "ID_" + (i + 1)));

                        XElement kyHieuMauHDon = new XElement("kyHieuMauHDon");
                        HDonBRa.Add(kyHieuMauHDon);

                        XElement kyHieuHDon = new XElement("kyHieuHDon");
                        HDonBRa.Add(kyHieuHDon);

                        XElement soHDon = new XElement("soHDon", vatForm.OutputCategories2.ElementAt(i).Column2);
                        HDonBRa.Add(soHDon);

                        XElement ngayPHanh = new XElement("ngayPHanh", vatForm.OutputCategories2.ElementAt(i).Column3.ToString("yyyy-MM-dd"));
                        HDonBRa.Add(ngayPHanh);

                        XElement tenNMUA = new XElement("tenNMUA", vatForm.OutputCategories2.ElementAt(i).Column4);
                        HDonBRa.Add(tenNMUA);

                        XElement mstNMUA = new XElement("mstNMUA", vatForm.OutputCategories2.ElementAt(i).Column5);
                        HDonBRa.Add(mstNMUA);

                        XElement matHang = new XElement("matHang");
                        HDonBRa.Add(matHang);

                        XElement dsoBanChuaThue = new XElement("dsoBanChuaThue", vatForm.OutputCategories2.ElementAt(i).Column6);
                        HDonBRa.Add(dsoBanChuaThue);

                        XElement thueGTGT = new XElement("thueGTGT", vatForm.OutputCategories2.ElementAt(i).Column7);
                        HDonBRa.Add(thueGTGT);

                        XElement ghiChu = new XElement("ghiChu", vatForm.OutputCategories2.ElementAt(i).Column8);

                        ChiTietHHDVThue0.Add(HDonBRa);
                    }
                }

                HHDVThue0.Add(ChiTietHHDVThue0);

                XElement tongDThuBRaThue0 = new XElement("tongDThuBRaKChiuThue", vatForm.OutputCategories1TotalAmount);
                HHDVThue0.Add(tongDThuBRaThue0);

                XElement tongThueBRaThue0 = new XElement("tongThueBRaThue0", "0");
                HHDVThue0.Add(tongThueBRaThue0);

                PL01_1_GTGT.Add(HHDVThue0);

                #endregion

                #region 5%

                XElement HHDVThue5 = new XElement("HHDVThue5");

                XElement ChiTietHHDVThue5 = new XElement("ChiTietHHDVThue5");
                if (vatForm.OutputCategories3 != null && vatForm.OutputCategories3.Count > 0)
                {
                    for (int i = 0; i < vatForm.OutputCategories3.Count; i++)
                    {
                        XElement HDonBRa = new XElement("HDonBRa");
                        HDonBRa.Add(new XAttribute("id", "ID_" + (i + 1)));

                        XElement kyHieuMauHDon = new XElement("kyHieuMauHDon");
                        HDonBRa.Add(kyHieuMauHDon);

                        XElement kyHieuHDon = new XElement("kyHieuHDon");
                        HDonBRa.Add(kyHieuHDon);

                        XElement soHDon = new XElement("soHDon", vatForm.OutputCategories3.ElementAt(i).Column2);
                        HDonBRa.Add(soHDon);

                        XElement ngayPHanh = new XElement("ngayPHanh", vatForm.OutputCategories3.ElementAt(i).Column3.ToString("yyyy-MM-dd"));
                        HDonBRa.Add(ngayPHanh);

                        XElement tenNMUA = new XElement("tenNMUA", vatForm.OutputCategories3.ElementAt(i).Column4);
                        HDonBRa.Add(tenNMUA);

                        XElement mstNMUA = new XElement("mstNMUA", vatForm.OutputCategories3.ElementAt(i).Column5);
                        HDonBRa.Add(mstNMUA);

                        XElement matHang = new XElement("matHang");
                        HDonBRa.Add(matHang);

                        XElement dsoBanChuaThue = new XElement("dsoBanChuaThue", vatForm.OutputCategories3.ElementAt(i).Column6);
                        HDonBRa.Add(dsoBanChuaThue);

                        XElement thueGTGT = new XElement("thueGTGT", vatForm.OutputCategories3.ElementAt(i).Column7);
                        HDonBRa.Add(thueGTGT);

                        XElement ghiChu = new XElement("ghiChu", vatForm.OutputCategories3.ElementAt(i).Column8);

                        ChiTietHHDVThue5.Add(HDonBRa);
                    }
                }

                HHDVThue5.Add(ChiTietHHDVThue5);

                XElement tongDThuBRaThue5 = new XElement("tongDThuBRaThue5", vatForm.OutputCategories3TotalAmount);
                HHDVThue5.Add(tongDThuBRaThue5);

                XElement tongThueBRaThue5 = new XElement("tongThueBRaThue5", vatForm.OutputCategories3TotalTaxAmount);
                HHDVThue5.Add(tongThueBRaThue5);

                PL01_1_GTGT.Add(HHDVThue5);

                #endregion

                #region 10%

                XElement HHDVThue10 = new XElement("HHDVThue10");

                XElement ChiTietHHDVThue10 = new XElement("ChiTietHHDVThue10");
                if (vatForm.OutputCategories4 != null && vatForm.OutputCategories4.Count > 0)
                {
                    for (int i = 0; i < vatForm.OutputCategories4.Count; i++)
                    {
                        XElement HDonBRa = new XElement("HDonBRa");
                        HDonBRa.Add(new XAttribute("id", "ID_" + (i + 1)));

                        XElement kyHieuMauHDon = new XElement("kyHieuMauHDon");
                        HDonBRa.Add(kyHieuMauHDon);

                        XElement kyHieuHDon = new XElement("kyHieuHDon");
                        HDonBRa.Add(kyHieuHDon);

                        XElement soHDon = new XElement("soHDon", vatForm.OutputCategories4.ElementAt(i).Column2);
                        HDonBRa.Add(soHDon);

                        XElement ngayPHanh = new XElement("ngayPHanh", vatForm.OutputCategories4.ElementAt(i).Column3.ToString("yyyy-MM-dd"));
                        HDonBRa.Add(ngayPHanh);

                        XElement tenNMUA = new XElement("tenNMUA", vatForm.OutputCategories4.ElementAt(i).Column4);
                        HDonBRa.Add(tenNMUA);

                        XElement mstNMUA = new XElement("mstNMUA", vatForm.OutputCategories4.ElementAt(i).Column5);
                        HDonBRa.Add(mstNMUA);

                        XElement matHang = new XElement("matHang");
                        HDonBRa.Add(matHang);

                        XElement dsoBanChuaThue = new XElement("dsoBanChuaThue", vatForm.OutputCategories4.ElementAt(i).Column6);
                        HDonBRa.Add(dsoBanChuaThue);

                        XElement thueGTGT = new XElement("thueGTGT", vatForm.OutputCategories4.ElementAt(i).Column7);
                        HDonBRa.Add(thueGTGT);

                        XElement ghiChu = new XElement("ghiChu", vatForm.OutputCategories4.ElementAt(i).Column8);

                        ChiTietHHDVThue10.Add(HDonBRa);
                    }
                }

                HHDVThue10.Add(ChiTietHHDVThue10);

                XElement tongDThuBRaThue10 = new XElement("tongDThuBRaThue10", vatForm.OutputCategories4TotalAmount);
                HHDVThue10.Add(tongDThuBRaThue10);

                XElement tongThueBRaThue10 = new XElement("tongThueBRaThue10", vatForm.OutputCategories4TotalTaxAmount);
                HHDVThue10.Add(tongThueBRaThue10);

                PL01_1_GTGT.Add(HHDVThue10);

                #endregion

                XElement HHDVBRaKhongTHop = new XElement("HHDVBRaKhongTHop");

                XElement ChiTietHHDVBRaKhongTHop = new XElement("ChiTietHHDVBRaKhongTHop");
                HHDVBRaKhongTHop.Add(ChiTietHHDVBRaKhongTHop);

                XElement tongDThuBRaKoKKhai = new XElement("tongDThuBRaKoKKhai", "0");
                HHDVBRaKhongTHop.Add(tongDThuBRaKoKKhai);

                XElement tongThueBRaKoKKhai = new XElement("tongThueBRaKoKKhai", "0");
                HHDVBRaKhongTHop.Add(HHDVBRaKhongTHop);

                PL01_1_GTGT.Add(HHDVBRaKhongTHop);

                XElement tongDThuBRa = new XElement("tongDThuBRa", vatForm.OutputTotalAmount);
                PL01_1_GTGT.Add(tongDThuBRa);

                XElement tongDThuBRaChiuThue = new XElement("tongDThuBRaChiuThue", vatForm.HaveTaxOutputAmount);
                PL01_1_GTGT.Add(tongDThuBRaChiuThue);

                XElement tongThueBRa = new XElement("tongThueBRa", vatForm.OutputTotalTaxAmount);
                PL01_1_GTGT.Add(tongThueBRa);

                PLuc.Add(PL01_1_GTGT);
                #endregion

                #region PL01_2_GTGT
                XElement PL01_2_GTGT = new XElement("PL01_2_GTGT");
                #region HHDVDRieng

                XElement HHDVDRieng = new XElement("HHDVDRieng");

                XElement ChiTietHHDVDRieng = new XElement("ChiTietHHDVDRieng");
                if (vatForm.InputCategories1 != null && vatForm.InputCategories1.Count > 0)
                {
                    for (int i = 0; i < vatForm.InputCategories1.Count; i++)
                    {
                        XElement HDonMVao = new XElement("HDonMVao");
                        HDonMVao.Add(new XAttribute("id", "ID_" + (i + 1)));

                        XElement kyHieuMauHDon = new XElement("kyHieuMauHDon");
                        HDonMVao.Add(kyHieuMauHDon);

                        XElement kyHieuHDon = new XElement("kyHieuHDon");
                        HDonMVao.Add(kyHieuHDon);

                        XElement soHDon = new XElement("soHDon", vatForm.InputCategories1.ElementAt(i).Column2);
                        HDonMVao.Add(soHDon);

                        XElement ngayPHanh = new XElement("ngayPHanh", vatForm.InputCategories1.ElementAt(i).Column3.ToString("yyyy-MM-dd"));
                        HDonMVao.Add(ngayPHanh);

                        XElement tenNBAN = new XElement("tenNBAN", vatForm.InputCategories1.ElementAt(i).Column4);
                        HDonMVao.Add(tenNBAN);

                        XElement mstNBAN = new XElement("mstNBAN", vatForm.InputCategories1.ElementAt(i).Column5);
                        HDonMVao.Add(mstNBAN);

                        XElement matHang = new XElement("matHang");
                        HDonMVao.Add(matHang);

                        XElement thueSuat = new XElement("thueSuat", "0");
                        HDonMVao.Add(thueSuat);

                        XElement dsoMuaChuaThue = new XElement("dsoMuaChuaThue", vatForm.InputCategories1.ElementAt(i).Column6);
                        HDonMVao.Add(dsoMuaChuaThue);

                        XElement thueGTGT = new XElement("thueGTGT", vatForm.InputCategories1.ElementAt(i).Column7);
                        HDonMVao.Add(thueGTGT);

                        XElement ghiChu = new XElement("ghiChu", vatForm.InputCategories1.ElementAt(i).Column8);

                        ChiTietHHDVDRieng.Add(HDonMVao);
                    }
                }

                HHDVDRieng.Add(ChiTietHHDVDRieng);

                XElement tongGTriMVao = new XElement("tongGTriMVao", vatForm.InputCategories1TotalAmount);
                HHDVDRieng.Add(tongGTriMVao);

                XElement tongThueMVao = new XElement("tongThueMVao", vatForm.InputCategories1TotalTaxAmount);
                HHDVDRieng.Add(tongThueMVao);

                PL01_2_GTGT.Add(HHDVDRieng);
                #endregion

                #region HHDVKhongKTru

                XElement HHDVKhongKTru = new XElement("HHDVKhongKTru");

                XElement ChiTietHHDVKhongKTru = new XElement("ChiTietHHDVKhongKTru");
                HHDVKhongKTru.Add(HHDVKhongKTru);

                XElement tongGTriMVao1 = new XElement("tongGTriMVao", "0");
                HHDVKhongKTru.Add(tongGTriMVao1);

                XElement tongThueMVao1 = new XElement("tongThueMVao", "0");
                HHDVKhongKTru.Add(tongThueMVao1);

                PL01_2_GTGT.Add(HHDVKhongKTru);

                #endregion

                #region HHDVDChung

                XElement HHDVDChung = new XElement("HHDVDChung");

                XElement ChiTietHHDVDChung = new XElement("ChiTietHHDVDChung");
                if (vatForm.InputCategories2 != null && vatForm.InputCategories2.Count > 0)
                {
                    for (int i = 0; i < vatForm.InputCategories2.Count; i++)
                    {
                        XElement HDonMVao = new XElement("HDonMVao");
                        HDonMVao.Add(new XAttribute("id", "ID_" + (i + 1)));

                        XElement kyHieuMauHDon = new XElement("kyHieuMauHDon");
                        HDonMVao.Add(kyHieuMauHDon);

                        XElement kyHieuHDon = new XElement("kyHieuHDon");
                        HDonMVao.Add(kyHieuHDon);

                        XElement soHDon = new XElement("soHDon", vatForm.InputCategories2.ElementAt(i).Column2);
                        HDonMVao.Add(soHDon);

                        XElement ngayPHanh = new XElement("ngayPHanh", vatForm.InputCategories2.ElementAt(i).Column3.ToString("yyyy-MM-dd"));
                        HDonMVao.Add(ngayPHanh);

                        XElement tenNBAN = new XElement("tenNBAN", vatForm.InputCategories2.ElementAt(i).Column4);
                        HDonMVao.Add(tenNBAN);

                        XElement mstNBAN = new XElement("mstNBAN", vatForm.InputCategories2.ElementAt(i).Column5);
                        HDonMVao.Add(mstNBAN);

                        XElement matHang = new XElement("matHang");
                        HDonMVao.Add(matHang);

                        XElement thueSuat = new XElement("thueSuat", "0");
                        HDonMVao.Add(thueSuat);

                        XElement dsoMuaChuaThue = new XElement("dsoMuaChuaThue", vatForm.InputCategories2.ElementAt(i).Column6);
                        HDonMVao.Add(dsoMuaChuaThue);

                        XElement thueGTGT = new XElement("thueGTGT", vatForm.InputCategories2.ElementAt(i).Column7);
                        HDonMVao.Add(thueGTGT);

                        XElement ghiChu = new XElement("ghiChu", vatForm.InputCategories2.ElementAt(i).Column8);

                        ChiTietHHDVDChung.Add(HDonMVao);
                    }
                }

                HHDVDChung.Add(ChiTietHHDVDChung);

                XElement tongGTriMVao3 = new XElement("tongGTriMVao", vatForm.InputCategories2TotalAmount);
                HHDVDChung.Add(tongGTriMVao3);

                XElement tongThueMVao3 = new XElement("tongThueMVao", vatForm.InputCategories2TotalTaxAmount);
                HHDVDChung.Add(tongThueMVao3);

                PL01_2_GTGT.Add(HHDVDChung);
                #endregion

                #region HHDVKTru

                XElement HHDVKTru = new XElement("HHDVKTru");

                XElement ChiTietHHDVKTru = new XElement("ChiTietHHDVKTru");
                HHDVKTru.Add(ChiTietHHDVKTru);

                XElement tongGTriMVao2 = new XElement("tongGTriMVao", "0");
                HHDVKTru.Add(tongGTriMVao2);

                XElement tongThueMVao2 = new XElement("tongThueMVao", "0");
                HHDVKTru.Add(tongThueMVao2);

                PL01_2_GTGT.Add(HHDVKTru);

                #endregion

                #region HHDVMVaoKhongTHop

                XElement HHDVMVaoKhongTHop = new XElement("HHDVMVaoKhongTHop");

                XElement ChiTietHHDVMVaoKhongTHop = new XElement("ChiTietHHDVMVaoKhongTHop");
                HHDVMVaoKhongTHop.Add(ChiTietHHDVKTru);

                XElement tongGTriMVao4 = new XElement("tongGTriMVao", "0");
                HHDVMVaoKhongTHop.Add(tongGTriMVao4);

                XElement tongThueMVao4 = new XElement("tongThueMVao", "0");
                HHDVMVaoKhongTHop.Add(tongThueMVao4);

                PL01_2_GTGT.Add(HHDVMVaoKhongTHop);

                #endregion

                XElement tongGTriMVao5 = new XElement("tongGTriMVao", vatForm.InputTotalAmount);
                PL01_2_GTGT.Add(tongGTriMVao5);

                XElement tongThueMVao5 = new XElement("tongThueMVao", vatForm.InputTotalTaxAmount);
                PL01_2_GTGT.Add(tongThueMVao5);

                PLuc.Add(PL01_2_GTGT);
                #endregion

                HSoKhaiThue.Add(PLuc);

                root.Add(HSoKhaiThue);

                var xs = new XmlSerializer(root.GetType());
                var stream = new MemoryStream();
                var streamWriter = new StreamWriter(stream, System.Text.Encoding.UTF8);

                xs.Serialize(streamWriter, root);
                stream.Position = 0;
                return File(stream, "application/xml", "VAT_Quy" + taxQuarter + "_" + taxYear + ".xml");

                #endregion
            }
            catch (Exception)
            {
                return RedirectToAction("ManageError", "Error");
            }
        }