Example #1
0
        public int ChangeTndn(FormCollection form)
        {
            try
            {
                string tndnRateString = form["tndnRate"];
                string beginDateString = form["tndnBeginDate"];
                if (!(tndnRateString.IsEmpty() || beginDateString.IsEmpty()))
                {
                    int tndnRate;

                    if (!(int.TryParse(tndnRateString, out tndnRate)))
                    {
                        return 0;
                    }
                    DateTime beginDate;
                    DateTime.TryParse(beginDateString, out beginDate);
                    if (!(DateTime.TryParse(beginDateString, out beginDate)))
                    {
                        return 0;
                    }
                    TaxBusiness taxBusiness = new TaxBusiness();
                    bool rs = taxBusiness.ChangeTndn(tndnRate, beginDate);
                    return rs ? 1 : 0;
                }
                return 0;
            }
            catch (Exception)
            {
                return 0;
            }
        }
Example #2
0
 public int CancelVatTaxDeclaration(int quarter, int year)
 {
     try
     {
         TaxBusiness business = new TaxBusiness();
         return (business.CancelVatTaxDeclaration(quarter, year) ? 1 : 0);
     }
     catch (Exception)
     {
         return 0;
     }
 }
Example #3
0
 public int CancelTndnTaxDeclaration(int year)
 {
     try
     {
         TaxBusiness business = new TaxBusiness();
         return (business.CancelTndnTaxDeclaration(year) ? 1 : 0);
     }
     catch (Exception)
     {
         return 0;
     }
 }
Example #4
0
        public ActionResult VatTaxDeclaration(int quarter, int year)
        {
            try
            {
                TaxBusiness business = new TaxBusiness();
                DeclarationVatForm result = business.GetVatTaxDeclaration(quarter, year);

                return View(result);
            }
            catch (Exception)
            {
                return RedirectToAction("ManageError", "Error");
            }
        }
Example #5
0
        public ActionResult TndnTaxDeclaration(int year)
        {
            try
            {
                TaxBusiness business = new TaxBusiness();
                TndnTaxDeclaration result = business.GeTndnTaxDeclaration(year);

                return View(result);
            }
            catch (Exception)
            {
                return RedirectToAction("ManageError", "Error");
            }
        }
Example #6
0
        public int SaveVatTaxDeclaration(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 ProcessData

                Models.VatTaxDeclaration taxDeclaration = new VatTaxDeclaration();

                taxDeclaration.Quarter = Convert.ToInt32(taxQuarter);
                taxDeclaration.Year = Convert.ToInt32(taxYear);

                taxDeclaration.StoreOwnerName = storeOwnerName;
                taxDeclaration.StoreTaxCode = storeTaxcode;
                taxDeclaration.StoreAddress = storeAddress;
                taxDeclaration.StoreDistrict = storeDistrict;
                taxDeclaration.StoreProvince = storeProvince;
                taxDeclaration.StorePhone = storePhone;
                taxDeclaration.StoreEmail = storeEmail;
                taxDeclaration.StoreFax = storeFax;

                taxDeclaration.TaxAgentOwnerName = vatAgentOwnerName;
                taxDeclaration.TaxAgentTaxCode = vatAgentTaxCode;
                taxDeclaration.TaxAgentAddress = vatAgentAddress;
                taxDeclaration.TaxAgentDistrict = vatAgentDistrict;
                taxDeclaration.TaxAgentProvince = vatAgentProvince;
                taxDeclaration.TaxAgentPhone = vatAgentPhone;
                taxDeclaration.TaxAgentEmail = vatAgentEmail;
                taxDeclaration.TaxAgentFax = vatAgentFax;
                taxDeclaration.TaxAgentName = vatAgentName;
                taxDeclaration.TaxAgentNo = vatAgentNo;

                taxDeclaration.CreateLocation = createLocation;
                taxDeclaration.CreateDate = DateTime.ParseExact(createDate, "yyyy-MM-dd", CultureInfo.InvariantCulture);
                taxDeclaration.SignName = signName;
                taxDeclaration.Value20No = value20No;
                taxDeclaration.Value20Date = DateTime.ParseExact(value20Date, "yyyy-MM-dd", CultureInfo.InvariantCulture);

                taxDeclaration.Value21 = Convert.ToInt32(value21);
                taxDeclaration.Value22 = Convert.ToInt32(value22);
                taxDeclaration.Value25 = Convert.ToInt32(value25);
                taxDeclaration.Value36 = Convert.ToInt32(value36);
                taxDeclaration.Value37 = Convert.ToInt32(value37);
                taxDeclaration.Value38 = Convert.ToInt32(value38);
                taxDeclaration.Value39 = Convert.ToInt32(value39);
                taxDeclaration.Value40 = Convert.ToInt32(value40);
                taxDeclaration.Value40a = Convert.ToInt32(value40a);
                taxDeclaration.Value40b = Convert.ToInt32(value40b);
                taxDeclaration.Value41 = Convert.ToInt32(value41);
                taxDeclaration.Value42 = Convert.ToInt32(value42);
                taxDeclaration.Value43 = Convert.ToInt32(value43);

                #region Output

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

                #region OutputCategory1

                string outputCategory1 = "";

                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++)
                    {
                        string eachOutputCategory1 = "";

                        eachOutputCategory1 += outputCategory1Column2Array[i] + ",";
                        eachOutputCategory1 += outputCategory1Column3Array[i] + ",";
                        eachOutputCategory1 += outputCategory1Column4Array[i] + ",";
                        eachOutputCategory1 += outputCategory1Column5Array[i] + ",";
                        eachOutputCategory1 += outputCategory1Column6Array[i].Replace(".", "") + ",";
                        eachOutputCategory1 += outputCategory1Column7Array[i].Replace(".", "") + ",";
                        eachOutputCategory1 += outputCategory1Column8Array[i];

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

                        outputCategory1 += eachOutputCategory1 + ";";
                    }

                    taxDeclaration.OutputCategory1TotalAmountValue26 = totalOutputCategory1;

                    totalOutputAmount += totalOutputCategory1;
                }

                taxDeclaration.OutputCategory1 = outputCategory1;

                #endregion

                #region OutputCategory2

                string outputCategory2 = "";

                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++)
                    {
                        string eachOutputCategory2 = "";

                        eachOutputCategory2 += outputCategory2Column2Array[i] + ",";
                        eachOutputCategory2 += outputCategory2Column3Array[i] + ",";
                        eachOutputCategory2 += outputCategory2Column4Array[i] + ",";
                        eachOutputCategory2 += outputCategory2Column5Array[i] + ",";
                        eachOutputCategory2 += outputCategory2Column6Array[i].Replace(".", "") + ",";
                        eachOutputCategory2 += outputCategory2Column7Array[i].Replace(".", "") + ",";
                        eachOutputCategory2 += outputCategory2Column8Array[i];

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

                        outputCategory2 += eachOutputCategory2 + ";";
                    }

                    taxDeclaration.OutputCategory2TotalAmountValue29 = totalOutputCategory2;

                    haveTaxTotalOutputAmount += totalOutputCategory2;
                    totalOutputAmount += totalOutputCategory2;
                }

                taxDeclaration.OutputCategory2 = outputCategory2;

                #endregion

                #region OutputCategory3

                string outputCategory3List = "";

                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++)
                    {
                        string outputCategory3 = "";

                        outputCategory3 += outputCategory3Column2Array[i] + ",";
                        outputCategory3 += outputCategory3Column3Array[i] + ",";
                        outputCategory3 += outputCategory3Column4Array[i] + ",";
                        outputCategory3 += outputCategory3Column5Array[i] + ",";
                        outputCategory3 += outputCategory3Column6Array[i].Replace(".", "") + ",";
                        outputCategory3 += outputCategory3Column7Array[i].Replace(".", "") + ",";
                        outputCategory3 += outputCategory3Column8Array[i];

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

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

                        outputCategory3List += outputCategory3 + ";";
                    }

                    taxDeclaration.OutputCategory3TotalAmountValue30 = totalOutputCategory3;
                    taxDeclaration.OutputCategory3TotalTaxAmountValue31 = totalTaxOutputCategory3;

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

                taxDeclaration.OutputCategory3 = outputCategory3List;

                #endregion

                #region OutputCategory4

                string outputCategory4List = "";

                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++)
                    {
                        string outputCategory4 = "";

                        outputCategory4 += outputCategory4Column2Array[i] + ",";
                        outputCategory4 += outputCategory4Column3Array[i] + ",";
                        outputCategory4 += outputCategory4Column4Array[i] + ",";
                        outputCategory4 += outputCategory4Column5Array[i] + ",";
                        outputCategory4 += outputCategory4Column6Array[i].Replace(".", "") + ",";
                        outputCategory4 += outputCategory4Column7Array[i].Replace(".", "") + ",";
                        outputCategory4 += outputCategory4Column8Array[i];

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

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

                        outputCategory4List += outputCategory4 + ";";
                    }

                    taxDeclaration.OutputCategory4TotalAmountValue32 = totalOutputCategory4;
                    taxDeclaration.OutputCategory4TotalTaxAmountValue33 = totalTaxOutputCategory4;

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

                taxDeclaration.OutputCategory4 = outputCategory4List;

                #endregion

                taxDeclaration.OutputTotalAmountValue34 = totalOutputAmount;
                taxDeclaration.OutputTotalTaxAmountValue28 = totalTaxOutputAmount;
                taxDeclaration.HaveTaxOutputTotalAmountValue27 = haveTaxTotalOutputAmount;

                #endregion

                #region Input

                int totalInputAmount = 0;
                int totalTaxInputAmount = 0;

                #region InputCategory1

                string inputCategory1List = "";

                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++)
                    {
                        string inputCategory1 = "";

                        inputCategory1 += inputCategory1Column2Array[i] + ",";
                        inputCategory1 += inputCategory1Column3Array[i] + ",";
                        inputCategory1 += inputCategory1Column4Array[i] + ",";
                        inputCategory1 += inputCategory1Column5Array[i] + ",";
                        inputCategory1 += inputCategory1Column6Array[i].Replace(".", "") + ",";
                        inputCategory1 += inputCategory1Column7Array[i].Replace(".", "") + ",";
                        inputCategory1 += inputCategory1Column8Array[i];

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

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

                        inputCategory1List += inputCategory1 + ";";
                    }

                    taxDeclaration.InputCategory1TotalAmount = totalInputCategory1;
                    taxDeclaration.InputCategory1TotalTaxAmount = totalTaxInputCategory1;

                    totalInputAmount += totalInputCategory1;
                    totalTaxInputAmount += totalTaxInputCategory1;
                }

                taxDeclaration.InputCategory1 = inputCategory1List;

                #endregion

                #region InputCategory2

                string inputCategory2List = "";

                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++)
                    {
                        string inputCategory2 = "";

                        inputCategory2 += inputCategory2Column2Array[i] + ",";
                        inputCategory2 += inputCategory2Column3Array[i] + ",";
                        inputCategory2 += inputCategory2Column4Array[i] + ",";
                        inputCategory2 += inputCategory2Column5Array[i] + ",";
                        inputCategory2 += inputCategory2Column6Array[i].Replace(".", "") + ",";
                        inputCategory2 += inputCategory2Column7Array[i].Replace(".", "") + ",";
                        inputCategory2 += inputCategory2Column8Array[i];

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

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

                        inputCategory2List += inputCategory2 + ";";
                    }

                    taxDeclaration.InputCategory2TotalAmount = totalInputCategory2;
                    taxDeclaration.InputCategory2TotalTaxAmount = totalTaxInputCategory2;

                    totalInputAmount += totalInputCategory2;
                    totalTaxInputAmount += totalTaxInputCategory2;
                }

                taxDeclaration.InputCategory2 = inputCategory2List;

                #endregion

                #region InputCategory3

                string inputCategory3List = "";

                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++)
                    {
                        string inputCategory3 = "";

                        inputCategory3 += inputCategory3Column2Array[i] + ",";
                        inputCategory3 += inputCategory3Column3Array[i] + ",";
                        inputCategory3 += inputCategory3Column4Array[i] + ",";
                        inputCategory3 += inputCategory3Column5Array[i] + ",";
                        inputCategory3 += inputCategory3Column6Array[i].Replace(".", "") + ",";
                        inputCategory3 += inputCategory3Column7Array[i].Replace(".", "") + ",";
                        inputCategory3 += inputCategory3Column8Array[i];

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

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

                        inputCategory3List += inputCategory3 + ";";
                    }

                    taxDeclaration.InputCategory3TotalAmount = totalInputCategory3;
                    taxDeclaration.InputCategory3TotalTaxAmount = totalTaxInputCategory3;

                }

                taxDeclaration.InputCategory3 = inputCategory3List;

                #endregion

                taxDeclaration.InputTotalAmountValue23 = totalInputAmount;
                taxDeclaration.InputTotalTaxAmountValue24 = totalTaxInputAmount;

                #endregion

                #endregion

                TaxBusiness business = new TaxBusiness();
                return business.SaveVatTaxDeclaration(taxDeclaration) ? 1 : 0;
            }
            catch (Exception)
            {
                return 0;
            }
        }
Example #7
0
        public int SaveTndnTaxTndnTaxDeclaration(FormCollection form)
        {
            try
            {
                #region Get Data from Form
                string taxYear = form["taxYear"];

                string createDate = form["createDate"];
                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 signName = form["signName"];
                string maxRevenueRatio = form["maxRevenueRatio"];

                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 value22No = form["value22No"];
                string value22Date = form["value22Date"];

                string valueA1 = form["valueA1"].Replace(".", "");

                string valueB1 = form["valueB1"].Replace(".", "");
                string valueB2 = form["valueB2"].Replace(".", "");
                string valueB3 = form["valueB3"].Replace(".", "");
                string valueB4 = form["valueB4"].Replace(".", "");
                string valueB5 = form["valueB5"].Replace(".", "");
                string valueB6 = form["valueB6"].Replace(".", "");
                string valueB7 = form["valueB7"].Replace(".", "");
                string valueB8 = form["valueB8"].Replace(".", "");
                string valueB9 = form["valueB9"].Replace(".", "");
                string valueB10 = form["valueB10"].Replace(".", "");
                string valueB11 = form["valueB11"].Replace(".", "");
                string valueB12 = form["valueB12"].Replace(".", "");
                string valueB13 = form["valueB13"].Replace(".", "");
                string valueB14 = form["valueB14"].Replace(".", "");

                string valueC1 = form["valueC1"].Replace(".", "");
                string valueC2 = form["valueC2"].Replace(".", "");
                string valueC3 = form["valueC3"].Replace(".", "");
                string valueC3a = form["valueC3a"].Replace(".", "");
                string valueC3b = form["valueC3b"].Replace(".", "");
                string valueC4 = form["valueC4"].Replace(".", "");
                string valueC5 = form["valueC5"].Replace(".", "");
                string valueC6 = form["valueC6"].Replace(".", "");
                string valueC7 = form["valueC7"].Replace(".", "");
                string valueC8 = form["valueC8"].Replace(".", "");
                string valueC9 = form["valueC9"].Replace(".", "");
                string valueC9a = form["valueC9a"].Replace(".", "");
                string valueC10 = form["valueC10"].Replace(".", "");
                string valueC11 = form["valueC11"].Replace(".", "");
                string valueC12 = form["valueC12"].Replace(".", "");
                string valueC13 = form["valueC13"].Replace(".", "");
                string valueC14 = form["valueC14"].Replace(".", "");
                string valueC15 = form["valueC15"].Replace(".", "");
                string valueC16 = form["valueC16"].Replace(".", "");

                string valueD = form["valueD"].Replace(".", "");
                string valueD1 = form["valueD1"].Replace(".", "");
                string valueD2 = form["valueD2"].Replace(".", "");
                string valueD3 = form["valueD3"].Replace(".", "");

                string valueE = form["valueE"].Replace(".", "");
                string valueE1 = form["valueE1"].Replace(".", "");
                string valueE2 = form["valueE2"].Replace(".", "");
                string valueE3 = form["valueE3"].Replace(".", "");

                string valueG = form["valueG"].Replace(".", "");
                string valueG1 = form["valueG1"].Replace(".", "");
                string valueG2 = form["valueG2"].Replace(".", "");
                string valueG3 = form["valueG3"].Replace(".", "");

                string valueH = form["valueH"].Replace(".", "");
                string valueI = form["valueI"].Replace(".", "");

                string valueL1 = form["valueL1"];
                string valueL2Code = form["valueL2Code"];
                string valueL3 = form["valueL3"];
                string valueL4 = form["valueL4"].Replace(".", "");
                string valueL5 = form["valueL5"].Replace(".", "");

                string valueM1DayQuantity = form["valueM1DayQuantity"];
                string valueM1FromDate = form["valueM1FromDate"];
                string valueM1ToDate = form["valueM1ToDate"];
                string valueM2 = form["valueM2"].Replace(".", "");

                string value1 = form["value01"].Replace(".", "");
                string value2 = form["value02"].Replace(".", "");
                string value3 = form["value03"].Replace(".", "");
                string value4 = form["value04"].Replace(".", "");
                string value5 = form["value05"].Replace(".", "");
                string value6 = form["value06"].Replace(".", "");
                string value7 = form["value07"].Replace(".", "");
                string value8 = form["value08"].Replace(".", "");
                string value9 = form["value09"].Replace(".", "");
                string value10 = form["value10"].Replace(".", "");
                string value11 = form["value11"].Replace(".", "");
                string value12 = form["value12"].Replace(".", "");
                string value13 = form["value13"].Replace(".", "");
                string value14 = form["value14"].Replace(".", "");
                string value15 = form["value15"].Replace(".", "");
                string value16 = form["value16"].Replace(".", "");
                string value17 = form["value17"].Replace(".", "");
                string value18 = form["value18"].Replace(".", "");
                string value19 = form["value19"].Replace(".", "");
                #endregion

                #region Create TndnTaxDeclaration Model and Save

                TndnTaxDeclaration tndn = new TndnTaxDeclaration();

                tndn.Year = Convert.ToInt32(taxYear.Trim());
                if (maxRevenueRatio.Trim().Length > 0)
                {
                    tndn.MaxRevenueRatio = Convert.ToInt32(maxRevenueRatio.Trim());
                }
                else
                {
                    tndn.MaxRevenueRatio = 0;
                }

                tndn.StoreOwnerName = storeOwnerName;
                tndn.StoreTaxCode = storeTaxcode;
                tndn.StoreAddress = storeAddress;
                tndn.StoreDistrict = storeDistrict;
                tndn.StoreProvince = storeProvince;
                tndn.StorePhone = storePhone;
                tndn.StoreFax = storeFax;
                tndn.StoreEmail = storeEmail;

                tndn.TaxAgentTaxCode = vatAgentTaxCode;
                tndn.TaxAgentName = vatAgentName;
                tndn.TaxAgentOwnerName = vatAgentOwnerName;
                tndn.TaxAgentNo = vatAgentNo;
                tndn.TaxAgentAddress = vatAgentAddress;
                tndn.TaxAgentDistrict = vatAgentDistrict;
                tndn.TaxAgentProvince = vatAgentProvince;
                tndn.TaxAgentPhone = vatAgentPhone;
                tndn.TaxAgentFax = vatAgentFax;
                tndn.TaxAgentEmail = vatAgentEmail;
                tndn.SignName = signName;
                if (!createDate.Trim().IsEmpty())
                {
                    tndn.CreateDate = DateTime.ParseExact(createDate, "yyyy-MM-dd", CultureInfo.InvariantCulture);
                }

                if (value22No.Trim().Length > 0)
                {
                    tndn.Value22No = Convert.ToInt32(value22No);
                }
                if (!value22Date.Trim().IsEmpty())
                {
                    tndn.Value22Date = DateTime.ParseExact(value22Date, "yyyy-MM-dd", CultureInfo.InvariantCulture);
                }

                tndn.ValueA1 = Convert.ToInt32(valueA1);
                tndn.ValueB1 = Convert.ToInt32(valueB1);
                tndn.ValueB2 = Convert.ToInt32(valueB2);
                tndn.ValueB3 = Convert.ToInt32(valueB3);
                tndn.ValueB4 = Convert.ToInt32(valueB4);
                tndn.ValueB5 = Convert.ToInt32(valueB5);
                tndn.ValueB6 = Convert.ToInt32(valueB6);
                tndn.ValueB7 = Convert.ToInt32(valueB7);
                tndn.ValueB8 = Convert.ToInt32(valueB8);
                tndn.ValueB9 = Convert.ToInt32(valueB9);
                tndn.ValueB10 = Convert.ToInt32(valueB10);
                tndn.ValueB11 = Convert.ToInt32(valueB11);
                tndn.ValueB12 = Convert.ToInt32(valueB12);
                tndn.ValueB13 = Convert.ToInt32(valueB13);
                tndn.ValueB14 = Convert.ToInt32(valueB14);

                tndn.ValueC1 = Convert.ToInt32(valueC1);
                tndn.ValueC2 = Convert.ToInt32(valueC2);
                tndn.ValueC3 = Convert.ToInt32(valueC3);
                tndn.ValueC3a = Convert.ToInt32(valueC3a);
                tndn.ValueC3b = Convert.ToInt32(valueC3b);
                tndn.ValueC4 = Convert.ToInt32(valueC4);
                tndn.ValueC5 = Convert.ToInt32(valueC5);
                tndn.ValueC6 = Convert.ToInt32(valueC6);
                tndn.ValueC7 = Convert.ToInt32(valueC7);
                tndn.ValueC8 = Convert.ToInt32(valueC8);
                tndn.ValueC9 = Convert.ToInt32(valueC9);
                tndn.ValueC9a = Convert.ToInt32(valueC9a);
                tndn.ValueC10 = Convert.ToInt32(valueC10);
                tndn.ValueC11 = Convert.ToInt32(valueC11);
                tndn.ValueC12 = Convert.ToInt32(valueC12);
                tndn.ValueC13 = Convert.ToInt32(valueC13);
                tndn.ValueC14 = Convert.ToInt32(valueC14);
                tndn.ValueC15 = Convert.ToInt32(valueC15);
                tndn.ValueC16 = Convert.ToInt32(valueC16);

                tndn.ValueD = Convert.ToInt32(valueD);
                tndn.ValueD1 = Convert.ToInt32(valueD1);
                tndn.ValueD2 = Convert.ToInt32(valueD2);
                tndn.ValueD3 = Convert.ToInt32(valueD3);

                tndn.ValueE = Convert.ToInt32(valueE);
                tndn.ValueE1 = Convert.ToInt32(valueE1);
                tndn.ValueE2 = Convert.ToInt32(valueE2);
                tndn.ValueE3 = Convert.ToInt32(valueE3);

                tndn.ValueG = Convert.ToInt32(valueG);
                tndn.ValueG1 = Convert.ToInt32(valueG1);
                tndn.ValueG2 = Convert.ToInt32(valueG2);
                tndn.ValueG3 = Convert.ToInt32(valueG3);

                tndn.ValueH = Convert.ToInt32(valueH);
                tndn.ValueI = Convert.ToInt32(valueI);

                if (valueL1 != null && valueL1.Equals("on"))
                {
                    tndn.ValueL1 = true;
                    tndn.ValueL2No = Convert.ToInt32(valueL2Code);
                    tndn.ValueL3 = DateTime.ParseExact(valueL3, "yyyy-MM-dd", CultureInfo.InvariantCulture);
                    tndn.ValueL4 = Convert.ToInt32(valueL4);
                    tndn.ValueL5 = Convert.ToInt32(valueL5);
                }
                else
                {
                    tndn.ValueL1 = false;
                }

                if (!valueM1FromDate.IsEmpty())
                {
                    tndn.ValueM1FromDate = DateTime.ParseExact(valueM1FromDate, "yyyy-MM-dd", CultureInfo.InvariantCulture);
                }

                if (!valueM1ToDate.IsEmpty())
                {
                    tndn.ValueM1ToDate = DateTime.ParseExact(valueM1FromDate, "yyyy-MM-dd", CultureInfo.InvariantCulture);
                }

                tndn.ValueM2 = Convert.ToInt32(valueM2);

                tndn.Value1 = Convert.ToInt32(value1);
                tndn.Value2 = Convert.ToInt32(value2);
                tndn.Value3 = Convert.ToInt32(value3);
                tndn.Value4 = Convert.ToInt32(value4);
                tndn.Value5 = Convert.ToInt32(value5);
                tndn.Value6 = Convert.ToInt32(value6);
                tndn.Value7 = Convert.ToInt32(value7);
                tndn.Value8 = Convert.ToInt32(value8);
                tndn.Value9 = Convert.ToInt32(value9);
                tndn.Value10 = Convert.ToInt32(value10);
                tndn.Value11 = Convert.ToInt32(value11);
                tndn.Value12 = Convert.ToInt32(value12);
                tndn.Value13 = Convert.ToInt32(value13);
                tndn.Value14 = Convert.ToInt32(value14);
                tndn.Value15 = Convert.ToInt32(value15);
                tndn.Value16 = Convert.ToInt32(value16);
                tndn.Value17 = Convert.ToInt32(value17);
                tndn.Value18 = Convert.ToInt32(value18);
                tndn.Value19 = Convert.ToInt32(value19);

                TaxBusiness business = new TaxBusiness();
                return business.SaveTndnTaxDeclaration(tndn) ? 1 : 0;

                #endregion
            }
            catch (Exception)
            {
                return 0;
            }
        }
Example #8
0
 // GET: Tax
 public ActionResult Index()
 {
     try
     {
         ViewBag.Title = "Báo cáo thuế";
         ViewBag.TreeView = "report";
         ViewBag.TreeViewMenu = "taxRepory";
         TaxBusiness taxBusiness = new TaxBusiness();
         TaxRateViewModel taxRate = taxBusiness.GetTaxRate();
         return View(taxRate);
     }
     catch (Exception)
     {
         return RedirectToAction("ManageError", "Error");
     }
 }
Example #9
0
        public ActionResult ExportXmlTndnTaxDeclaration(FormCollection form)
        {
            try
            {
                #region Get Data from Form
                string taxYear = form["taxYear"];

                //Store Info Not get from form; Get from DB
                BMAEntities db = new BMAEntities();

                string createDate = form["createDate"];
                string vatAgentOwnerName = form["vatAgentOwnerName"];
                string vatAgentName = form["agentName"];
                string vatAgentTaxCodeString = form["agentTaxCode"];
                string vatAgentTaxCode = "";
                if (vatAgentTaxCodeString != null)
                {
                    vatAgentTaxCode = vatAgentTaxCodeString.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 signName = form["signName"];
                string maxRevenueRatio = form["maxRevenueRatio"];

                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 value22No = form["value22No"];
                string value22Date = form["value22Date"];

                string valueA1 = form["valueA1"].Replace(".", "");

                string valueB1 = form["valueB1"].Replace(".", "");
                string valueB2 = form["valueB2"].Replace(".", "");
                string valueB3 = form["valueB3"].Replace(".", "");
                string valueB4 = form["valueB4"].Replace(".", "");
                string valueB5 = form["valueB5"].Replace(".", "");
                string valueB6 = form["valueB6"].Replace(".", "");
                string valueB7 = form["valueB7"].Replace(".", "");
                string valueB8 = form["valueB8"].Replace(".", "");
                string valueB9 = form["valueB9"].Replace(".", "");
                string valueB10 = form["valueB10"].Replace(".", "");
                string valueB11 = form["valueB11"].Replace(".", "");
                string valueB12 = form["valueB12"].Replace(".", "");
                string valueB13 = form["valueB13"].Replace(".", "");
                string valueB14 = form["valueB14"].Replace(".", "");

                string valueC1 = form["valueC1"].Replace(".", "");
                string valueC2 = form["valueC2"].Replace(".", "");
                string valueC3 = form["valueC3"].Replace(".", "");
                string valueC3a = form["valueC3a"].Replace(".", "");
                string valueC3b = form["valueC3b"].Replace(".", "");
                string valueC4 = form["valueC4"].Replace(".", "");
                string valueC5 = form["valueC5"].Replace(".", "");
                string valueC6 = form["valueC6"].Replace(".", "");
                string valueC7 = form["valueC7"].Replace(".", "");
                string valueC8 = form["valueC8"].Replace(".", "");
                string valueC9 = form["valueC9"].Replace(".", "");
                string valueC9a = form["valueC9a"].Replace(".", "");
                string valueC10 = form["valueC10"].Replace(".", "");
                string valueC11 = form["valueC11"].Replace(".", "");
                string valueC12 = form["valueC12"].Replace(".", "");
                string valueC13 = form["valueC13"].Replace(".", "");
                string valueC14 = form["valueC14"].Replace(".", "");
                string valueC15 = form["valueC15"].Replace(".", "");
                string valueC16 = form["valueC16"].Replace(".", "");

                string valueD = form["valueD"].Replace(".", "");
                string valueD1 = form["valueD1"].Replace(".", "");
                string valueD2 = form["valueD2"].Replace(".", "");
                string valueD3 = form["valueD3"].Replace(".", "");

                string valueE = form["valueE"].Replace(".", "");
                string valueE1 = form["valueE1"].Replace(".", "");
                string valueE2 = form["valueE2"].Replace(".", "");
                string valueE3 = form["valueE3"].Replace(".", "");

                string valueG = form["valueG"].Replace(".", "");
                string valueG1 = form["valueG1"].Replace(".", "");
                string valueG2 = form["valueG2"].Replace(".", "");
                string valueG3 = form["valueG3"].Replace(".", "");

                string valueH = form["valueH"].Replace(".", "");
                string valueI = form["valueI"].Replace(".", "");

                string valueL1 = form["valueL1"];
                string valueL2Code = form["valueL2Code"];
                string valueL3 = form["valueL3"];
                string valueL4 = form["valueL4"].Replace(".", "");
                string valueL5 = form["valueL5"].Replace(".", "");

                string valueM1DayQuantity = form["valueM1DayQuantity"];
                string valueM1FromDate = form["valueM1FromDate"];
                string valueM1ToDate = form["valueM1ToDate"];
                string valueM2 = form["valueM2"].Replace(".", "");

                string value1 = form["value01"].Replace(".", "");
                string value2 = form["value02"].Replace(".", "");
                string value3 = form["value03"].Replace(".", "");
                string value4 = form["value04"].Replace(".", "");
                string value5 = form["value05"].Replace(".", "");
                string value6 = form["value06"].Replace(".", "");
                string value7 = form["value07"].Replace(".", "");
                string value8 = form["value08"].Replace(".", "");
                string value9 = form["value09"].Replace(".", "");
                string value10 = form["value10"].Replace(".", "");
                string value11 = form["value11"].Replace(".", "");
                string value12 = form["value12"].Replace(".", "");
                string value13 = form["value13"].Replace(".", "");
                string value14 = form["value14"].Replace(".", "");
                string value15 = form["value15"].Replace(".", "");
                string value16 = form["value16"].Replace(".", "");
                string value17 = form["value17"].Replace(".", "");
                string value18 = form["value18"].Replace(".", "");
                string value19 = form["value19"].Replace(".", "");
                #endregion

                #region Create TndnTaxDeclaration Model and Save

                TndnTaxDeclaration tndn = new TndnTaxDeclaration();

                tndn.Year = Convert.ToInt32(taxYear.Trim());
                if (maxRevenueRatio.Trim().Length > 0)
                {
                    tndn.MaxRevenueRatio = Convert.ToInt32(maxRevenueRatio.Trim());
                }
                else
                {
                    tndn.MaxRevenueRatio = 0;
                }

                tndn.StoreOwnerName = storeOwnerName;
                tndn.StoreTaxCode = storeTaxcode;
                tndn.StoreAddress = storeAddress;
                tndn.StoreDistrict = storeDistrict;
                tndn.StoreProvince = storeProvince;
                tndn.StorePhone = storePhone;
                tndn.StoreFax = storeFax;
                tndn.StoreEmail = storeEmail;

                tndn.TaxAgentTaxCode = vatAgentTaxCode;
                tndn.TaxAgentName = vatAgentName;
                tndn.TaxAgentOwnerName = vatAgentOwnerName;
                tndn.TaxAgentNo = vatAgentNo;
                tndn.TaxAgentAddress = vatAgentAddress;
                tndn.TaxAgentDistrict = vatAgentDistrict;
                tndn.TaxAgentProvince = vatAgentProvince;
                tndn.TaxAgentPhone = vatAgentPhone;
                tndn.TaxAgentFax = vatAgentFax;
                tndn.TaxAgentEmail = vatAgentEmail;
                tndn.SignName = signName;
                if (!createDate.Trim().IsEmpty())
                {
                    tndn.CreateDate = DateTime.ParseExact(createDate, "yyyy-MM-dd", CultureInfo.InvariantCulture);
                }

                if (!value22No.Trim().IsEmpty())
                {
                    tndn.Value22No = Convert.ToInt32(value22No);
                }

                if (!value22Date.Trim().IsEmpty())
                {
                    tndn.Value22Date = DateTime.ParseExact(value22Date, "yyyy-MM-dd", CultureInfo.InvariantCulture);
                }

                tndn.ValueA1 = Convert.ToInt32(valueA1);
                tndn.ValueB1 = Convert.ToInt32(valueB1);
                tndn.ValueB2 = Convert.ToInt32(valueB2);
                tndn.ValueB3 = Convert.ToInt32(valueB3);
                tndn.ValueB4 = Convert.ToInt32(valueB4);
                tndn.ValueB5 = Convert.ToInt32(valueB5);
                tndn.ValueB6 = Convert.ToInt32(valueB6);
                tndn.ValueB7 = Convert.ToInt32(valueB7);
                tndn.ValueB8 = Convert.ToInt32(valueB8);
                tndn.ValueB9 = Convert.ToInt32(valueB9);
                tndn.ValueB10 = Convert.ToInt32(valueB10);
                tndn.ValueB11 = Convert.ToInt32(valueB11);
                tndn.ValueB12 = Convert.ToInt32(valueB12);
                tndn.ValueB13 = Convert.ToInt32(valueB13);
                tndn.ValueB14 = Convert.ToInt32(valueB14);

                tndn.ValueC1 = Convert.ToInt32(valueC1);
                tndn.ValueC2 = Convert.ToInt32(valueC2);
                tndn.ValueC3 = Convert.ToInt32(valueC3);
                tndn.ValueC3a = Convert.ToInt32(valueC3a);
                tndn.ValueC3b = Convert.ToInt32(valueC3b);
                tndn.ValueC4 = Convert.ToInt32(valueC4);
                tndn.ValueC5 = Convert.ToInt32(valueC5);
                tndn.ValueC6 = Convert.ToInt32(valueC6);
                tndn.ValueC7 = Convert.ToInt32(valueC7);
                tndn.ValueC8 = Convert.ToInt32(valueC8);
                tndn.ValueC9 = Convert.ToInt32(valueC9);
                tndn.ValueC9a = Convert.ToInt32(valueC9a);
                tndn.ValueC10 = Convert.ToInt32(valueC10);
                tndn.ValueC11 = Convert.ToInt32(valueC11);
                tndn.ValueC12 = Convert.ToInt32(valueC12);
                tndn.ValueC13 = Convert.ToInt32(valueC13);
                tndn.ValueC14 = Convert.ToInt32(valueC14);
                tndn.ValueC15 = Convert.ToInt32(valueC15);
                tndn.ValueC16 = Convert.ToInt32(valueC16);

                tndn.ValueD = Convert.ToInt32(valueD);
                tndn.ValueD1 = Convert.ToInt32(valueD1);
                tndn.ValueD2 = Convert.ToInt32(valueD2);
                tndn.ValueD3 = Convert.ToInt32(valueD3);

                tndn.ValueE = Convert.ToInt32(valueE);
                tndn.ValueE1 = Convert.ToInt32(valueE1);
                tndn.ValueE2 = Convert.ToInt32(valueE2);
                tndn.ValueE3 = Convert.ToInt32(valueE3);

                tndn.ValueG = Convert.ToInt32(valueG);
                tndn.ValueG1 = Convert.ToInt32(valueG1);
                tndn.ValueG2 = Convert.ToInt32(valueG2);
                tndn.ValueG3 = Convert.ToInt32(valueG3);

                tndn.ValueH = Convert.ToInt32(valueH);
                tndn.ValueI = Convert.ToInt32(valueI);

                if (valueL1 != null && valueL1.Equals("on"))
                {
                    tndn.ValueL1 = true;
                    tndn.ValueL2No = Convert.ToInt32(valueL2Code);
                    tndn.ValueL3 = DateTime.ParseExact(valueL3, "yyyy-MM-dd", CultureInfo.InvariantCulture);
                    tndn.ValueL4 = Convert.ToInt32(valueL4);
                    tndn.ValueL5 = Convert.ToInt32(valueL5);
                }
                else
                {
                    tndn.ValueL1 = false;
                }

                if (!valueM1FromDate.IsEmpty())
                {
                    tndn.ValueM1FromDate = DateTime.ParseExact(valueM1FromDate, "yyyy-MM-dd", CultureInfo.InvariantCulture);
                }

                if (!valueM1ToDate.IsEmpty())
                {
                    tndn.ValueM1ToDate = DateTime.ParseExact(valueM1FromDate, "yyyy-MM-dd", CultureInfo.InvariantCulture);
                }

                tndn.ValueM2 = Convert.ToInt32(valueM2);

                tndn.Value1 = Convert.ToInt32(value1);
                tndn.Value2 = Convert.ToInt32(value2);
                tndn.Value3 = Convert.ToInt32(value3);
                tndn.Value4 = Convert.ToInt32(value4);
                tndn.Value5 = Convert.ToInt32(value5);
                tndn.Value6 = Convert.ToInt32(value6);
                tndn.Value7 = Convert.ToInt32(value7);
                tndn.Value8 = Convert.ToInt32(value8);
                tndn.Value9 = Convert.ToInt32(value9);
                tndn.Value10 = Convert.ToInt32(value10);
                tndn.Value11 = Convert.ToInt32(value11);
                tndn.Value12 = Convert.ToInt32(value12);
                tndn.Value13 = Convert.ToInt32(value13);
                tndn.Value14 = Convert.ToInt32(value14);
                tndn.Value15 = Convert.ToInt32(value15);
                tndn.Value16 = Convert.ToInt32(value16);
                tndn.Value17 = Convert.ToInt32(value17);
                tndn.Value18 = Convert.ToInt32(value18);
                tndn.Value19 = Convert.ToInt32(value19);

                TaxBusiness business = new TaxBusiness();
                business.SaveTndnTaxDeclaration(tndn);

                #endregion

                #region Create XML File

                XElement root = new XElement("HSoThueDTu");

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

                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", "03");
                TKhaiThue.Add(maTKhai);

                XElement tenTKhai = new XElement("tenTKhai", "TỜ KHAI QUYẾT TOÁN THUẾ THU NHẬP DOANH NGHIỆP (Mẫu số 03/TNDN)");
                TKhaiThue.Add(tenTKhai);

                XElement moTaBMau = new XElement("moTaBMau", "(Ban hành kèm theo Thông tư số 151/2014/TT-BTC  ngày 10/10/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", "Y");
                KyKKhaiThue.Add(kieuKy);

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

                XElement kyKKhaiTuNgay = new XElement("kyKKhaiTuNgay", "01/01/" + taxYear);
                KyKKhaiThue.Add(kyKKhaiTuNgay);

                XElement kyKKhaiDenNgay = new XElement("kyKKhaiDenNgay", "31/12/" + taxYear);
                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);
                if (valueL1 != null && valueL1.Equals("on"))
                {
                    XElement GiaHan = new XElement("GiaHan");
                    if (valueL2Code.Equals("01"))
                    {
                        XElement lyDoGiaHan = new XElement("lyDoGiaHan", "Doanh nghiệp có quy mô nhỏ và vừa");
                        GiaHan.Add(lyDoGiaHan);
                    }
                    if (valueL2Code.Equals("02"))
                    {
                        XElement lyDoGiaHan = new XElement("lyDoGiaHan", "Doanh nghiệp sử dụng nhiều lao động");
                        GiaHan.Add(lyDoGiaHan);
                    }
                    if (valueL2Code.Equals("99"))
                    {
                        XElement lyDoGiaHan = new XElement("lyDoGiaHan", "Lý do khác");
                        GiaHan.Add(lyDoGiaHan);
                    }

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

                    TKhaiThue.Add(GiaHan);

                }
                else
                {
                    XElement GiaHan = new XElement("GiaHan");

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

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

                    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", tndn.StoreTaxCode);
                NNT.Add(mst);

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

                XElement dchiNNT = new XElement("dchiNNT", tndn.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", tndn.StoreDistrict);
                NNT.Add(tenHuyenNNT);

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

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

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

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

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

                TTinTKhaiThue.Add(NNT);

                XElement DLyThue = new XElement("DLyThue");

                XElement mstDLyThue = new XElement("mstDLyThue", vatAgentTaxCode.Replace(",", ""));
                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", value22No);
                DLyThue.Add(soHDongDLyThue);

                XElement ngayKyHDDLyThue = new XElement("ngayKyHDDLyThue", value22Date);
                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", "1052");
                CTieuTKhaiChinh.Add(tieuMucHachToan);

                XElement doanhNghiepCoQuyMoVuaVaNho = new XElement("doanhNghiepCoQuyMoVuaVaNho", "1");
                CTieuTKhaiChinh.Add(doanhNghiepCoQuyMoVuaVaNho);

                XElement doanhNghiepCoCSoHToanPThuoc = new XElement("doanhNghiepCoCSoHToanPThuoc", "0");
                CTieuTKhaiChinh.Add(doanhNghiepCoCSoHToanPThuoc);

                XElement doanhNghiepKeKhaiTTinLienKet = new XElement("doanhNghiepKeKhaiTTinLienKet", "0");
                CTieuTKhaiChinh.Add(doanhNghiepKeKhaiTTinLienKet);

                XElement ct_04_ma = new XElement("ct_04_ma", "C");
                CTieuTKhaiChinh.Add(ct_04_ma);

                XElement ct_04_ten = new XElement("ct_04_ten", "Công nghiệp chế biến, chế tạo");
                CTieuTKhaiChinh.Add(ct_04_ten);

                XElement ct_05 = new XElement("ct_05", maxRevenueRatio);
                CTieuTKhaiChinh.Add(ct_05);

                XElement ctA1 = new XElement("ctA1", valueA1);
                CTieuTKhaiChinh.Add(ctA1);

                XElement ctB1 = new XElement("ctB1", valueB1);
                CTieuTKhaiChinh.Add(ctB1);
                XElement ctB2 = new XElement("ctB2", valueB2);
                CTieuTKhaiChinh.Add(ctB2);
                XElement ctB3 = new XElement("ctB3", valueB3);
                CTieuTKhaiChinh.Add(ctB3);
                XElement ctB4 = new XElement("ctB4", valueB4);
                CTieuTKhaiChinh.Add(ctB4);
                XElement ctB5 = new XElement("ctB5", valueB5);
                CTieuTKhaiChinh.Add(ctB5);
                XElement ctB6 = new XElement("ctB6", valueB6);
                CTieuTKhaiChinh.Add(ctB6);
                XElement ctB7 = new XElement("ctB7", valueB7);
                CTieuTKhaiChinh.Add(ctB7);
                XElement ctB8 = new XElement("ctB8", valueB8);
                CTieuTKhaiChinh.Add(ctB8);
                XElement ctB9 = new XElement("ctB9", valueB9);
                CTieuTKhaiChinh.Add(ctB9);
                XElement ctB10 = new XElement("ctB10", valueB10);
                CTieuTKhaiChinh.Add(ctB10);
                XElement ctB11 = new XElement("ctB11", valueB11);
                CTieuTKhaiChinh.Add(ctB11);
                XElement ctB12 = new XElement("ctB12", valueB12);
                CTieuTKhaiChinh.Add(ctB12);
                XElement ctB13 = new XElement("ctB13", valueB13);
                CTieuTKhaiChinh.Add(ctB13);
                XElement ctB14 = new XElement("ctB14", valueB14);
                CTieuTKhaiChinh.Add(ctB14);

                XElement ctC1 = new XElement("ctC1", valueC1);
                CTieuTKhaiChinh.Add(ctC1);
                XElement ctC2 = new XElement("ctC2", valueC2);
                CTieuTKhaiChinh.Add(ctC2);
                XElement ctC3 = new XElement("ctC3", valueC3);
                CTieuTKhaiChinh.Add(ctC3);
                XElement ctC3a = new XElement("ctC3a", valueC3a);
                CTieuTKhaiChinh.Add(ctC3a);
                XElement ctC3b = new XElement("ctC3b", valueC3b);
                CTieuTKhaiChinh.Add(ctC3b);
                XElement ctC4 = new XElement("ctC4", valueC4);
                CTieuTKhaiChinh.Add(ctC4);
                XElement ctC5 = new XElement("ctC5", valueC5);
                CTieuTKhaiChinh.Add(ctC5);
                XElement ctC6 = new XElement("ctC6", valueC6);
                CTieuTKhaiChinh.Add(ctC6);
                XElement ctC7 = new XElement("ctC7", valueC7);
                CTieuTKhaiChinh.Add(ctC7);
                XElement ctC8 = new XElement("ctC8", valueC8);
                CTieuTKhaiChinh.Add(ctC8);
                XElement ctC9 = new XElement("ctC9", valueC9);
                CTieuTKhaiChinh.Add(ctC9);
                XElement ctC9a = new XElement("ctC9a", valueC9a);
                CTieuTKhaiChinh.Add(ctC9a);
                XElement ctC10 = new XElement("ctC10", valueC10);
                CTieuTKhaiChinh.Add(ctC10);
                XElement ctC11 = new XElement("ctC11", valueC11);
                CTieuTKhaiChinh.Add(ctC11);
                XElement ctC12 = new XElement("ctC12", valueC12);
                CTieuTKhaiChinh.Add(ctC12);
                XElement ctC13 = new XElement("ctC13", valueC13);
                CTieuTKhaiChinh.Add(ctC13);
                XElement ctC14 = new XElement("ctC14", valueC14);
                CTieuTKhaiChinh.Add(ctC14);
                XElement ctC15 = new XElement("ctC15", valueC15);
                CTieuTKhaiChinh.Add(ctC15);
                XElement ctC16 = new XElement("ctC16", valueC16);
                CTieuTKhaiChinh.Add(ctC16);

                XElement ctD = new XElement("ctD", valueD);
                CTieuTKhaiChinh.Add(ctD);
                XElement ctD1 = new XElement("ctD1", valueD1);
                CTieuTKhaiChinh.Add(ctD1);
                XElement ctD2 = new XElement("ctD2", valueD2);
                CTieuTKhaiChinh.Add(ctD2);
                XElement ctD3 = new XElement("ctD3", valueD3);
                CTieuTKhaiChinh.Add(ctD3);

                XElement ctE = new XElement("ctE", valueE);
                CTieuTKhaiChinh.Add(ctE);
                XElement ctE1 = new XElement("ctE1", valueE1);
                CTieuTKhaiChinh.Add(ctE1);
                XElement ctE2 = new XElement("ctE2", valueE2);
                CTieuTKhaiChinh.Add(ctE2);
                XElement ctE3 = new XElement("ctE3", valueE3);
                CTieuTKhaiChinh.Add(ctE3);

                XElement ctG = new XElement("ctG", valueG);
                CTieuTKhaiChinh.Add(ctG);
                XElement ctG1 = new XElement("ctG1", valueG1);
                CTieuTKhaiChinh.Add(ctG1);
                XElement ctG2 = new XElement("ctG2", valueG2);
                CTieuTKhaiChinh.Add(ctG2);
                XElement ctG3 = new XElement("ctG3", valueG3);
                CTieuTKhaiChinh.Add(ctG3);

                XElement ctH = new XElement("ctH", valueH);
                CTieuTKhaiChinh.Add(ctH);
                XElement ctI = new XElement("ctI", valueI);
                CTieuTKhaiChinh.Add(ctI);

                XElement GiaHanNopThue = new XElement("GiaHanNopThue");

                if (valueL1 != null && valueL1.Equals("on"))
                {
                    XElement ctL1 = new XElement("ctL1", "1");
                    GiaHanNopThue.Add(ctL1);

                    XElement ctL2_ma = new XElement("ctL2_ma", valueL2Code);
                    GiaHanNopThue.Add(ctL2_ma);

                    if (valueL2Code.Equals("01"))
                    {
                        XElement ctL2_ten = new XElement("ctL2_ten", "Doanh nghiệp có quy mô nhỏ và vừa");
                        GiaHanNopThue.Add(ctL2_ten);
                    }
                    if (valueL2Code.Equals("02"))
                    {
                        XElement ctL2_ten = new XElement("ctL2_ten", "Doanh nghiệp sử dụng nhiều lao động");
                        GiaHanNopThue.Add(ctL2_ten);
                    }
                    if (valueL2Code.Equals("99"))
                    {
                        XElement ctL2_ten = new XElement("ctL2_ten", "Lý do khác");
                        GiaHanNopThue.Add(ctL2_ten);
                    }

                    XElement ctL3 = new XElement("ctL3",
                        (valueL3.Trim().Length > 0
                            ? DateTime.ParseExact(valueL3, "dd/MM/yyyy", CultureInfo.InvariantCulture)
                                .ToString("yyyy-MM-dd")
                            : ""));
                    GiaHanNopThue.Add(ctL3);

                    XElement ctL4 = new XElement("ctL4", valueL4);
                    GiaHanNopThue.Add(ctL4);

                    XElement ctL5 = new XElement("ctL5", valueL5);
                    GiaHanNopThue.Add(ctL5);
                }
                else
                {
                    XElement ctL1 = new XElement("ctL1", "0");
                    GiaHanNopThue.Add(ctL1);

                    XElement ctL2_ma = new XElement("ctL2_ma");
                    GiaHanNopThue.Add(ctL2_ma);

                    XElement ctL2_ten = new XElement("ctL2_ten");
                    GiaHanNopThue.Add(ctL2_ten);

                    XElement ctL3 = new XElement("ctL3");
                    GiaHanNopThue.Add(ctL3);

                    XElement ctL4 = new XElement("ctL4");
                    GiaHanNopThue.Add(ctL4);

                    XElement ctL5 = new XElement("ctL5");
                    GiaHanNopThue.Add(ctL5);
                }

                CTieuTKhaiChinh.Add(GiaHanNopThue);

                XElement TienChamNop = new XElement("TienChamNop");

                XElement CTM1 = new XElement("CTM1");

                XElement soNgay = new XElement("soNgay", valueM1DayQuantity);
                CTM1.Add(soNgay);

                XElement tuNgay = new XElement("tuNgay", (valueM1FromDate.Trim().Length > 0 ? DateTime.ParseExact(valueM1FromDate, "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd") : ""));
                CTM1.Add(tuNgay);

                XElement denNgay = new XElement("denNgay", (valueM1ToDate.Trim().Length > 0 ? DateTime.ParseExact(valueM1ToDate, "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd") : ""));
                CTM1.Add(denNgay);

                TienChamNop.Add(CTM1);

                XElement ctM2 = new XElement("ctM2", valueM2);
                TienChamNop.Add(ctM2);

                CTieuTKhaiChinh.Add(TienChamNop);

                XElement TaiLieu_Guikem = new XElement("TaiLieu_Guikem");
                CTieuTKhaiChinh.Add(TaiLieu_Guikem);

                HSoKhaiThue.Add(CTieuTKhaiChinh);

                XElement PLuc = new XElement("PLuc");

                XElement PL03_1A_TNDN = new XElement("PL03_1A_TNDN");

                XElement ct01 = new XElement("ct01", value1);
                PL03_1A_TNDN.Add(ct01);

                XElement ct02 = new XElement("ct02", value2);
                PL03_1A_TNDN.Add(ct02);

                XElement ct03 = new XElement("ct03", value3);
                PL03_1A_TNDN.Add(ct03);

                XElement ct04 = new XElement("ct04", value4);
                PL03_1A_TNDN.Add(ct04);

                XElement ct05 = new XElement("ct05", value5);
                PL03_1A_TNDN.Add(ct05);

                XElement ct06 = new XElement("ct06", value6);
                PL03_1A_TNDN.Add(ct06);

                XElement ct07 = new XElement("ct07", value7);
                PL03_1A_TNDN.Add(ct07);

                XElement ct08 = new XElement("ct08", value8);
                PL03_1A_TNDN.Add(ct08);

                XElement ct09 = new XElement("ct09", value9);
                PL03_1A_TNDN.Add(ct09);

                XElement ct10 = new XElement("ct10", value10);
                PL03_1A_TNDN.Add(ct10);

                XElement ct11 = new XElement("ct11", value11);
                PL03_1A_TNDN.Add(ct11);

                XElement ct12 = new XElement("ct12", value12);
                PL03_1A_TNDN.Add(ct12);

                XElement ct13 = new XElement("ct13", value13);
                PL03_1A_TNDN.Add(ct13);

                XElement ct14 = new XElement("ct14", value14);
                PL03_1A_TNDN.Add(ct14);

                XElement ct15 = new XElement("ct15", value15);
                PL03_1A_TNDN.Add(ct15);

                XElement ct16 = new XElement("ct16", value16);
                PL03_1A_TNDN.Add(ct16);

                XElement ct17 = new XElement("ct17", value17);
                PL03_1A_TNDN.Add(ct17);

                XElement ct18 = new XElement("ct18", value18);
                PL03_1A_TNDN.Add(ct18);

                XElement ct19 = new XElement("ct19", value19);
                PL03_1A_TNDN.Add(ct19);

                PLuc.Add(PL03_1A_TNDN);

                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", "TNDN" + taxYear + ".xml");

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