CSV


SUBMITTED BY: dbzdivik

DATE: Nov. 27, 2015, 5:27 a.m.

FORMAT: C

SIZE: 6.3 kB

HITS: 8426

  1. using System;
  2. using System.Text;
  3. using System.Windows.Forms;
  4. using System.IO;
  5. namespace CSV
  6. {
  7. public partial class VSC : Form
  8. {
  9. public VSC()
  10. {
  11. InitializeComponent();
  12. }
  13. void ClearAllText(Control con)
  14. {
  15. foreach (Control c in con.Controls)
  16. {
  17. if (c is TextBox)
  18. ((TextBox)c).Clear();
  19. else if (c is ComboBox)
  20. ((ComboBox)c).ResetText();
  21. else
  22. ClearAllText(c);
  23. }
  24. }
  25. private void Clear_Click(object sender, EventArgs e)
  26. {
  27. ClearAllText(this);
  28. }
  29. private void Save_Click(object sender, EventArgs e)
  30. {
  31. string filePath = FN.Text + ".csv";
  32. if (File.Exists(filePath))
  33. File.Delete(filePath);
  34. else
  35. File.Create(filePath).Close();
  36. try
  37. {
  38. if (T1.Text.Trim() == "NULL_IDCARD")
  39. MessageBox.Show("Select ID Card Type");
  40. else if (string.IsNullOrEmpty(P1.Text) || string.IsNullOrEmpty(A1.Text) || string.IsNullOrEmpty(S1.Text) || string.IsNullOrEmpty(B1.Text) || string.IsNullOrEmpty(F1.Text) || string.IsNullOrEmpty(N1.Text))
  41. MessageBox.Show("Passenger Detail Missing","CSV");
  42. if (!string.IsNullOrEmpty(P1.Text) || !string.IsNullOrEmpty(A1.Text) || !string.IsNullOrEmpty(S1.Text) || !string.IsNullOrEmpty(B1.Text) || !string.IsNullOrEmpty(F1.Text) || !string.IsNullOrEmpty(N1.Text))
  43. {
  44. var pax = P1.Text;
  45. var age = A1.Text;
  46. var sex = S1.Text;
  47. var berth = B1.Text;
  48. var meal = F1.Text;
  49. var id = T1.Text;
  50. var number = N1.Text;
  51. string delimiter = ";";
  52. string[][] output = new string[][]
  53. {
  54. new string[]{pax,age,sex,berth,meal,id,number}
  55. };
  56. int length = output.GetLength(0);
  57. StringBuilder sb = new StringBuilder();
  58. for (int index = 0; index < length; index++)
  59. sb.AppendLine(string.Join(delimiter, output[index]));
  60. File.AppendAllText(filePath, sb.ToString());
  61. }
  62. if (!string.IsNullOrEmpty(P2.Text) || !string.IsNullOrEmpty(A2.Text) || !string.IsNullOrEmpty(S2.Text) || !string.IsNullOrEmpty(B2.Text) || !string.IsNullOrEmpty(N2.Text))
  63. {
  64. var pax = P2.Text;
  65. var age = A2.Text;
  66. var sex = S2.Text;
  67. var berth = B2.Text;
  68. var meal = F2.Text;
  69. var id = T2.Text;
  70. var number = N2.Text;
  71. string delimiter = ";";
  72. string[][] output = new string[][]
  73. {
  74. new string[]{pax,age,sex,berth,meal,id,number}
  75. };
  76. int length = output.GetLength(0);
  77. StringBuilder sb = new StringBuilder();
  78. for (int index = 0; index < length; index++)
  79. sb.AppendLine(string.Join(delimiter, output[index]));
  80. File.AppendAllText(filePath, sb.ToString());
  81. if (string.IsNullOrEmpty(P2.Text) || string.IsNullOrEmpty(A2.Text) || string.IsNullOrEmpty(S2.Text) || string.IsNullOrEmpty(B2.Text) || string.IsNullOrEmpty(F2.Text))
  82. MessageBox.Show("Passenger Detail Missing", "CSV");
  83. }
  84. if (!string.IsNullOrEmpty(P3.Text) || !string.IsNullOrEmpty(A3.Text) || !string.IsNullOrEmpty(S3.Text) || !string.IsNullOrEmpty(B3.Text) || !string.IsNullOrEmpty(F3.Text))
  85. {
  86. var pax = P3.Text;
  87. var age = A3.Text;
  88. var sex = S3.Text;
  89. var berth = B3.Text;
  90. var meal = F3.Text;
  91. var id = T3.Text;
  92. var number = N3.Text;
  93. string delimiter = ";";
  94. string[][] output = new string[][]
  95. {
  96. new string[]{pax,age,sex,berth,meal,id,number}
  97. };
  98. int length = output.GetLength(0);
  99. StringBuilder sb = new StringBuilder();
  100. for (int index = 0; index < length; index++)
  101. sb.AppendLine(string.Join(delimiter, output[index]));
  102. File.AppendAllText(filePath, sb.ToString());
  103. }
  104. if (!string.IsNullOrEmpty(P4.Text) || !string.IsNullOrEmpty(A4.Text) || !string.IsNullOrEmpty(S4.Text) || !string.IsNullOrEmpty(B4.Text) || !string.IsNullOrEmpty(F4.Text))
  105. {
  106. var pax = P4.Text;
  107. var age = A4.Text;
  108. var sex = S4.Text;
  109. var berth = B4.Text;
  110. var meal = F4.Text;
  111. var id = T4.Text;
  112. var number = N4.Text;
  113. string delimiter = ";";
  114. string[][] output = new string[][]
  115. {
  116. new string[]{pax,age,sex,berth,meal,id,number}
  117. };
  118. int length = output.GetLength(0);
  119. StringBuilder sb = new StringBuilder();
  120. for (int index = 0; index < length; index++)
  121. sb.AppendLine(string.Join(delimiter, output[index]));
  122. File.AppendAllText(filePath, sb.ToString());
  123. }
  124. if (Open.Checked == true)
  125. {
  126. MessageBox.Show("File Saved, Exiting Application & Launching Flash", "CSV");
  127. System.Diagnostics.Process.Start("CK.exe");
  128. Application.Exit();
  129. }
  130. }
  131. catch (IOException ex)
  132. {
  133. MessageBox.Show(ex.ToString());
  134. }
  135. }
  136. }
  137. }

comments powered by Disqus