PageRenderTime 51ms CodeModel.GetById 8ms RepoModel.GetById 0ms app.codeStats 0ms

/BaliEnterpriseSystems/BaliEnterpriseSystems/BestObjects/BestStudents.cs

https://github.com/sirivedula/BEST
C# | 435 lines | 386 code | 49 blank | 0 comment | 2 complexity | 05347657d2afb063714968abcb00eeb5 MD5 | raw file
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Linq;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.HtmlControls;
  9. using System.Web.UI.WebControls;
  10. using System.Web.UI.WebControls.WebParts;
  11. using System.Xml.Linq;
  12. namespace BaliEnterpriseSystems.BestObjects
  13. {
  14. public class BestStudents : BestTable
  15. {
  16. public BestStudents()
  17. {
  18. this.TableName = "BestStudents";
  19. this.SecurityPage = "Student - Information";
  20. TableFields.Add(new BestField(){ fieldName="guidfield", displayField=false, fieldHeader="Guid", fieldType="System.Guid", paramOledbType= System.Data.OleDb.OleDbType.Guid, fieldSize = 40 });
  21. TableFields.Add(new BestField(){ fieldName="lastChange", displayField=false, fieldHeader="Last Change", fieldType="System.DateTime", paramOledbType= System.Data.OleDb.OleDbType.DBTime, fieldSize=20 });
  22. TableFields.Add(new BestField(){ fieldName="lastChangeUser", displayField=false, fieldHeader="Last Change User", fieldType="System.String", paramOledbType= System.Data.OleDb.OleDbType.VarChar, fieldSize=128});
  23. TableFields.Add(new BestField(){ fieldName="StudentId", displayField=true, fieldHeader="Student Id", fieldType="System.String", paramOledbType= System.Data.OleDb.OleDbType.VarChar, fieldSize=50});
  24. TableFields.Add(new BestField(){ fieldName="CenterId", displayField=true, fieldHeader="Center Id", fieldType="System.String", paramOledbType= System.Data.OleDb.OleDbType.VarChar, fieldSize=50});
  25. TableFields.Add(new BestField(){ fieldName="firstName", displayField=true, fieldHeader="First Name", fieldType="System.String", paramOledbType= System.Data.OleDb.OleDbType.VarChar, fieldSize=50});
  26. TableFields.Add(new BestField(){ fieldName="lastName", displayField=true, fieldHeader="Last Name", fieldType="System.String", paramOledbType= System.Data.OleDb.OleDbType.VarChar, fieldSize=50});
  27. TableFields.Add(new BestField(){ fieldName="middleName", displayField=true, fieldHeader="Middle Name", fieldType="System.String", paramOledbType= System.Data.OleDb.OleDbType.VarChar, fieldSize=50});
  28. TableFields.Add(new BestField() { fieldName = "parentName", displayField = true, fieldHeader = "Parent Name", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 80 });
  29. TableFields.Add(new BestField(){ fieldName="address1", displayField=false, fieldHeader="Address 1", fieldType="System.String", paramOledbType= System.Data.OleDb.OleDbType.VarChar, fieldSize=50});
  30. TableFields.Add(new BestField() { fieldName = "address2", displayField = false, fieldHeader = "Address 2", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
  31. TableFields.Add(new BestField() { fieldName = "city", displayField = false, fieldHeader = "City", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
  32. TableFields.Add(new BestField() { fieldName = "state", displayField = false, fieldHeader = "State", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 2 });
  33. TableFields.Add(new BestField() { fieldName = "zip", displayField = false, fieldHeader = "Zip", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 15 });
  34. TableFields.Add(new BestField() { fieldName = "cellPhone", displayField = true, fieldHeader = "Cell Phone", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 15 });
  35. TableFields.Add(new BestField() { fieldName = "workPhone", displayField = true, fieldHeader = "Work Phone", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 15 });
  36. TableFields.Add(new BestField() { fieldName = "homePhone", displayField = true, fieldHeader = "Home Phone", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 15 });
  37. TableFields.Add(new BestField() { fieldName = "emailId", displayField = true, fieldHeader = "Contact EMail", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 80 });
  38. TableFields.Add(new BestField() { fieldName = "gender", displayField = true, fieldHeader = "Gender", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 10 });
  39. TableFields.Add(new BestField() { fieldName = "programGuid", displayField = false, fieldHeader = "Program Guid", fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, fieldSize = 40 });
  40. TableFields.Add(new BestField() { fieldName = "Hours", displayField = false, fieldHeader = "Hours", fieldType = "System.Decimal", paramOledbType = System.Data.OleDb.OleDbType.Decimal, fieldSize = 18, Precision = 12, scale=2 });
  41. TableFields.Add(new BestField() { fieldName = "hourType", displayField = false, fieldHeader = "Hour Type", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 10 });
  42. TableFields.Add(new BestField() { fieldName = "Amount", displayField = false, fieldHeader = "Amount", fieldType = "System.Decimal", paramOledbType = System.Data.OleDb.OleDbType.Decimal, fieldSize = 18, Precision = 12, scale = 2 });
  43. TableFields.Add(new BestField() { fieldName = "amountType", displayField = false, fieldHeader = "Amount Type", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 10 });
  44. TableFields.Add(new BestField() { fieldName = "joinDate", displayField = false, fieldHeader = "Join Date", fieldType = "System.DateTime", paramOledbType = System.Data.OleDb.OleDbType.DBDate, fieldSize = 10 });
  45. TableFields.Add(new BestField() { fieldName = "birthDate", displayField = false, fieldHeader = "Birth Date", fieldType = "System.DateTime", paramOledbType = System.Data.OleDb.OleDbType.DBDate, fieldSize = 10 });
  46. TableFields.Add(new BestField() { fieldName = "guardianName", displayField = false, fieldHeader = "Guardian Name", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
  47. TableFields.Add(new BestField() { fieldName = "school", displayField = false, fieldHeader = "School", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
  48. TableFields.Add(new BestField() { fieldName = "grade", displayField = false, fieldHeader = "Grade", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
  49. }
  50. public Guid guidfield
  51. {
  52. get
  53. {
  54. return new Guid(CurrentRow.Fields["guidfield"].fieldValue);
  55. }
  56. set
  57. {
  58. CurrentRow.Fields["guidfield"].fieldValue = value.ToString();
  59. }
  60. }
  61. public DateTime lastChange
  62. {
  63. get
  64. {
  65. return Convert.ToDateTime(CurrentRow.Fields["lastChange"].fieldValue);
  66. }
  67. set
  68. {
  69. CurrentRow.Fields["lastChange"].fieldValue = value.ToString("MM/dd/yyyy HH:mm:ss");
  70. }
  71. }
  72. public string lastChangeUser
  73. {
  74. get
  75. {
  76. return CurrentRow.Fields["lastChangeUser"].fieldValue;
  77. }
  78. set
  79. {
  80. CurrentRow.Fields["lastChangeUser"].fieldValue = value;
  81. }
  82. }
  83. public string StudentId
  84. {
  85. get
  86. {
  87. return CurrentRow.Fields["StudentId"].fieldValue;
  88. }
  89. set
  90. {
  91. CurrentRow.Fields["StudentId"].fieldValue = value;
  92. }
  93. }
  94. public string CenterId
  95. {
  96. get
  97. {
  98. return CurrentRow.Fields["CenterId"].fieldValue;
  99. }
  100. set
  101. {
  102. CurrentRow.Fields["CenterId"].fieldValue = value;
  103. }
  104. }
  105. public string firstName
  106. {
  107. get
  108. {
  109. return CurrentRow.Fields["firstName"].fieldValue;
  110. }
  111. set
  112. {
  113. CurrentRow.Fields["firstName"].fieldValue = value;
  114. }
  115. }
  116. public string lastName
  117. {
  118. get
  119. {
  120. return CurrentRow.Fields["lastName"].fieldValue;
  121. }
  122. set
  123. {
  124. CurrentRow.Fields["lastName"].fieldValue = value;
  125. }
  126. }
  127. public string middleName
  128. {
  129. get
  130. {
  131. return CurrentRow.Fields["middleName"].fieldValue;
  132. }
  133. set
  134. {
  135. CurrentRow.Fields["middleName"].fieldValue = value;
  136. }
  137. }
  138. public string parentName
  139. {
  140. get
  141. {
  142. return CurrentRow.Fields["parentName"].fieldValue;
  143. }
  144. set
  145. {
  146. CurrentRow.Fields["parentName"].fieldValue = value;
  147. }
  148. }
  149. public string address1
  150. {
  151. get
  152. {
  153. return CurrentRow.Fields["address1"].fieldValue;
  154. }
  155. set
  156. {
  157. CurrentRow.Fields["address1"].fieldValue = value;
  158. }
  159. }
  160. public string address2
  161. {
  162. get
  163. {
  164. return CurrentRow.Fields["address2"].fieldValue;
  165. }
  166. set
  167. {
  168. CurrentRow.Fields["address2"].fieldValue = value;
  169. }
  170. }
  171. public string city
  172. {
  173. get
  174. {
  175. return CurrentRow.Fields["city"].fieldValue;
  176. }
  177. set
  178. {
  179. CurrentRow.Fields["city"].fieldValue = value;
  180. }
  181. }
  182. public string state
  183. {
  184. get
  185. {
  186. return CurrentRow.Fields["state"].fieldValue;
  187. }
  188. set
  189. {
  190. CurrentRow.Fields["state"].fieldValue = value;
  191. }
  192. }
  193. public string zip
  194. {
  195. get
  196. {
  197. return CurrentRow.Fields["zip"].fieldValue;
  198. }
  199. set
  200. {
  201. CurrentRow.Fields["zip"].fieldValue = value;
  202. }
  203. }
  204. public string cellPhone
  205. {
  206. get
  207. {
  208. return CurrentRow.Fields["cellPhone"].fieldValue;
  209. }
  210. set
  211. {
  212. CurrentRow.Fields["cellPhone"].fieldValue = value;
  213. }
  214. }
  215. public string emailId
  216. {
  217. get
  218. {
  219. return CurrentRow.Fields["emailId"].fieldValue;
  220. }
  221. set
  222. {
  223. CurrentRow.Fields["emailId"].fieldValue = value;
  224. }
  225. }
  226. public string workPhone
  227. {
  228. get
  229. {
  230. return CurrentRow.Fields["workPhone"].fieldValue;
  231. }
  232. set
  233. {
  234. CurrentRow.Fields["workPhone"].fieldValue = value;
  235. }
  236. }
  237. public string homePhone
  238. {
  239. get
  240. {
  241. return CurrentRow.Fields["homePhone"].fieldValue;
  242. }
  243. set
  244. {
  245. CurrentRow.Fields["homePhone"].fieldValue = value;
  246. }
  247. }
  248. public string gender
  249. {
  250. get
  251. {
  252. return CurrentRow.Fields["gender"].fieldValue;
  253. }
  254. set
  255. {
  256. CurrentRow.Fields["gender"].fieldValue = value;
  257. }
  258. }
  259. public string Hours
  260. {
  261. get
  262. {
  263. return CurrentRow.Fields["Hours"].fieldValue;
  264. }
  265. set
  266. {
  267. CurrentRow.Fields["Hours"].fieldValue = value;
  268. }
  269. }
  270. public string hourType
  271. {
  272. get
  273. {
  274. return CurrentRow.Fields["hourType"].fieldValue;
  275. }
  276. set
  277. {
  278. CurrentRow.Fields["hourType"].fieldValue = value;
  279. }
  280. }
  281. public string Amount
  282. {
  283. get
  284. {
  285. return CurrentRow.Fields["Amount"].fieldValue;
  286. }
  287. set
  288. {
  289. CurrentRow.Fields["Amount"].fieldValue = value;
  290. }
  291. }
  292. public string amountType
  293. {
  294. get
  295. {
  296. return CurrentRow.Fields["amountType"].fieldValue;
  297. }
  298. set
  299. {
  300. CurrentRow.Fields["amountType"].fieldValue = value;
  301. }
  302. }
  303. public Guid programGuid
  304. {
  305. get
  306. {
  307. return new Guid(CurrentRow.Fields["programGuid"].fieldValue);
  308. }
  309. set
  310. {
  311. CurrentRow.Fields["programGuid"].fieldValue = value.ToString();
  312. }
  313. }
  314. public DateTime joinDate
  315. {
  316. get
  317. {
  318. string fldval = CurrentRow.Fields["joinDate"].fieldValue;
  319. if (!string.IsNullOrEmpty(fldval))
  320. {
  321. return Convert.ToDateTime(fldval);
  322. }
  323. else
  324. {
  325. return DateTime.MinValue;
  326. }
  327. }
  328. set
  329. {
  330. CurrentRow.Fields["joinDate"].fieldValue = value.ToString("MM/dd/yyyy");
  331. }
  332. }
  333. public DateTime birthDate
  334. {
  335. get
  336. {
  337. string fldval = CurrentRow.Fields["birthDate"].fieldValue;
  338. if (!string.IsNullOrEmpty(fldval))
  339. {
  340. return Convert.ToDateTime(fldval);
  341. }
  342. else
  343. {
  344. return DateTime.MinValue;
  345. }
  346. }
  347. set
  348. {
  349. CurrentRow.Fields["birthDate"].fieldValue = value.ToString("MM/dd/yyyy");
  350. }
  351. }
  352. public string guardianName
  353. {
  354. get
  355. {
  356. return CurrentRow.Fields["guardianName"].fieldValue;
  357. }
  358. set
  359. {
  360. CurrentRow.Fields["guardianName"].fieldValue = value;
  361. }
  362. }
  363. public string School
  364. {
  365. get
  366. {
  367. return CurrentRow.Fields["School"].fieldValue;
  368. }
  369. set
  370. {
  371. CurrentRow.Fields["School"].fieldValue = value;
  372. }
  373. }
  374. public string Grade
  375. {
  376. get
  377. {
  378. return CurrentRow.Fields["Grade"].fieldValue;
  379. }
  380. set
  381. {
  382. CurrentRow.Fields["Grade"].fieldValue = value;
  383. }
  384. }
  385. }
  386. }