PageRenderTime 47ms CodeModel.GetById 21ms RepoModel.GetById 1ms app.codeStats 0ms

/IntelWeb/IntelWebData/lkup_site.cs

https://github.com/sirivedula/IntelWebPro
C# | 393 lines | 359 code | 34 blank | 0 comment | 2 complexity | 6c6e6ea1dd16d4267e4f3a3f2dd4569c MD5 | raw file
  1. using System;
  2. using System.Data;
  3. using System.Data.OleDb;
  4. using System.Collections.Generic;
  5. using System.Text;
  6. using System.Runtime.Serialization;
  7. using System.Linq;
  8. namespace IntelWeb
  9. {
  10. [Serializable]
  11. [DataContract]
  12. public class lkup_site : IntelWebObject
  13. {
  14. private Int32 _site_id;
  15. private string _department_code;
  16. private string _site_code;
  17. private string _site_code_description;
  18. private string _building_name;
  19. private string _facility_contact;
  20. private string _path;
  21. private string _address1;
  22. private string _address2;
  23. private string _city;
  24. private string _state_code;
  25. private string _zip_code;
  26. private string _country_code;
  27. private string _mobile_number;
  28. private string _land_number;
  29. private string _land_number_extension;
  30. private string _fax_number;
  31. private string _email_id;
  32. private Int32? _latitude_small;
  33. private Int32? _longitude_smal;
  34. private decimal? _latitude_whole;
  35. private decimal? _longitude_whole;
  36. private string _created_by;
  37. private DateTime _created_date;
  38. private string _last_modified_by;
  39. private DateTime _last_modified_date;
  40. #region NonTemplateCode
  41. #endregion
  42. protected lkup_site()
  43. {
  44. }
  45. public lkup_site(CurrentUser oUser, List<IntelWebField> oselectFieldsList, bool _internalFlag_LoadingFromDataSet)
  46. {
  47. base.loadObjectDefaults = _internalFlag_LoadingFromDataSet;
  48. Initialize(oUser);
  49. base.selectFieldsList = oselectFieldsList;
  50. }
  51. public lkup_site(CurrentUser oUser)
  52. {
  53. Initialize(oUser);
  54. }
  55. public lkup_site(CurrentUser oUser, string selectFields)
  56. {
  57. Initialize(oUser);
  58. base.selectFields = selectFields;
  59. }
  60. public override List<IntelWebField> myFields()
  61. {
  62. List<IntelWebField> _myFields = new List<IntelWebField>(); base.constructing = false;
  63. _myFields.Add(new IntelWebField("site_id", System.Data.OleDb.OleDbType.Integer, 0, 10, 0, DataRowVersion.Current, false, null));
  64. _myFields.Add(new IntelWebField("department_code", System.Data.OleDb.OleDbType.VarChar, 50, 50, 0, DataRowVersion.Current, false, null));
  65. _myFields.Add(new IntelWebField("site_code", System.Data.OleDb.OleDbType.VarChar, 50, 50, 0, DataRowVersion.Current, false, null));
  66. _myFields.Add(new IntelWebField("site_code_description", System.Data.OleDb.OleDbType.VarChar, 100, 100, 0, DataRowVersion.Current, false, null));
  67. _myFields.Add(new IntelWebField("building_name", System.Data.OleDb.OleDbType.VarChar, 250, 0, 0, DataRowVersion.Current, true, null));
  68. _myFields.Add(new IntelWebField("facility_contact", System.Data.OleDb.OleDbType.VarChar, 250, 0, 0, DataRowVersion.Current, true, null));
  69. _myFields.Add(new IntelWebField("path", System.Data.OleDb.OleDbType.VarChar, 250, 0, 0, DataRowVersion.Current, true, null));
  70. _myFields.Add(new IntelWebField("address1", System.Data.OleDb.OleDbType.VarChar, 50, 50, 0, DataRowVersion.Current, true, null));
  71. _myFields.Add(new IntelWebField("address2", System.Data.OleDb.OleDbType.VarChar, 50, 50, 0, DataRowVersion.Current, true, null));
  72. _myFields.Add(new IntelWebField("city", System.Data.OleDb.OleDbType.VarChar, 50, 50, 0, DataRowVersion.Current, true, null));
  73. _myFields.Add(new IntelWebField("state_code", System.Data.OleDb.OleDbType.Char, 50, 50, 0, DataRowVersion.Current, true, null));
  74. _myFields.Add(new IntelWebField("zip_code", System.Data.OleDb.OleDbType.VarChar, 15, 15, 0, DataRowVersion.Current, true, null));
  75. _myFields.Add(new IntelWebField("country_code", System.Data.OleDb.OleDbType.VarChar, 250, 0, 0, DataRowVersion.Current, true, null));
  76. _myFields.Add(new IntelWebField("mobile_number", System.Data.OleDb.OleDbType.VarChar, 50, 50, 0, DataRowVersion.Current, true, null));
  77. _myFields.Add(new IntelWebField("land_number", System.Data.OleDb.OleDbType.VarChar, 50, 50, 0, DataRowVersion.Current, true, null));
  78. _myFields.Add(new IntelWebField("land_number_extension", System.Data.OleDb.OleDbType.VarChar, 5, 5, 0, DataRowVersion.Current, true, null));
  79. _myFields.Add(new IntelWebField("fax_number", System.Data.OleDb.OleDbType.VarChar, 50, 50, 0, DataRowVersion.Current, true, null));
  80. _myFields.Add(new IntelWebField("email_id", System.Data.OleDb.OleDbType.VarChar, 50, 50, 0, DataRowVersion.Current, true, null));
  81. _myFields.Add(new IntelWebField("latitude_small", System.Data.OleDb.OleDbType.Integer, 0, 10, 0, DataRowVersion.Current, true, null));
  82. _myFields.Add(new IntelWebField("longitude_smal", System.Data.OleDb.OleDbType.Integer, 0, 10, 0, DataRowVersion.Current, true, null));
  83. _myFields.Add(new IntelWebField("latitude_whole", System.Data.OleDb.OleDbType.Decimal, 0, 9, 4, DataRowVersion.Default, true, decimal.Parse("0")));
  84. _myFields.Add(new IntelWebField("longitude_whole", System.Data.OleDb.OleDbType.Decimal, 0, 9, 4, DataRowVersion.Default, true, decimal.Parse("0")));
  85. _myFields.Add(new IntelWebField("created_by", System.Data.OleDb.OleDbType.VarChar, 50, 50, 0, DataRowVersion.Default, false, ((this.User == null ? "" : this.User.userName))));
  86. _myFields.Add(new IntelWebField("created_date", System.Data.OleDb.OleDbType.DBTimeStamp, 0, 23, 3, DataRowVersion.Default, false, (DateTime.Now)));
  87. _myFields.Add(new IntelWebField("last_modified_by", System.Data.OleDb.OleDbType.VarChar, 50, 50, 0, DataRowVersion.Default, false, ((this.User == null ? "" : this.User.userName))));
  88. _myFields.Add(new IntelWebField("last_modified_date", System.Data.OleDb.OleDbType.DBTimeStamp, 0, 23, 3, DataRowVersion.Default, false, (DateTime.Now)));
  89. return _myFields;
  90. }
  91. private void Initialize(CurrentUser oUser)
  92. {
  93. base.User = oUser;
  94. base.primaryKey = new IntelWebField("site_id", System.Data.OleDb.OleDbType.Integer, 0, 10, 0, DataRowVersion.Current, false, null);
  95. base.FieldList = this.myFields();
  96. base.tableName = "lkup_site";
  97. }
  98. [DataMember]
  99. public Int32 site_id
  100. {
  101. get { return _site_id; }
  102. set
  103. {
  104. _site_id = value;
  105. base.addChange("site_id", value);
  106. }
  107. }
  108. [DataMember]
  109. public string department_code
  110. {
  111. get { return _department_code; }
  112. set
  113. {
  114. _department_code = value;
  115. base.addChange("department_code", value);
  116. }
  117. }
  118. [DataMember]
  119. public string site_code
  120. {
  121. get { return _site_code; }
  122. set
  123. {
  124. _site_code = value;
  125. base.addChange("site_code", value);
  126. }
  127. }
  128. [DataMember]
  129. public string site_code_description
  130. {
  131. get { return _site_code_description; }
  132. set
  133. {
  134. _site_code_description = value;
  135. base.addChange("site_code_description", value);
  136. }
  137. }
  138. [DataMember]
  139. public string building_name
  140. {
  141. get { return _building_name; }
  142. set
  143. {
  144. _building_name = value;
  145. base.addChange("building_name", value);
  146. }
  147. }
  148. [DataMember]
  149. public string facility_contact
  150. {
  151. get { return _facility_contact; }
  152. set
  153. {
  154. _facility_contact = value;
  155. base.addChange("facility_contact", value);
  156. }
  157. }
  158. [DataMember]
  159. public string path
  160. {
  161. get { return _path; }
  162. set
  163. {
  164. _path = value;
  165. base.addChange("path", value);
  166. }
  167. }
  168. [DataMember]
  169. public string address1
  170. {
  171. get { return _address1; }
  172. set
  173. {
  174. _address1 = value;
  175. base.addChange("address1", value);
  176. }
  177. }
  178. [DataMember]
  179. public string address2
  180. {
  181. get { return _address2; }
  182. set
  183. {
  184. _address2 = value;
  185. base.addChange("address2", value);
  186. }
  187. }
  188. [DataMember]
  189. public string city
  190. {
  191. get { return _city; }
  192. set
  193. {
  194. _city = value;
  195. base.addChange("city", value);
  196. }
  197. }
  198. [DataMember]
  199. public string state_code
  200. {
  201. get { return _state_code; }
  202. set
  203. {
  204. _state_code = value;
  205. base.addChange("state_code", value);
  206. }
  207. }
  208. [DataMember]
  209. public string zip_code
  210. {
  211. get { return _zip_code; }
  212. set
  213. {
  214. _zip_code = value;
  215. base.addChange("zip_code", value);
  216. }
  217. }
  218. [DataMember]
  219. public string country_code
  220. {
  221. get { return _country_code; }
  222. set
  223. {
  224. _country_code = value;
  225. base.addChange("country_code", value);
  226. }
  227. }
  228. [DataMember]
  229. public string mobile_number
  230. {
  231. get { return _mobile_number; }
  232. set
  233. {
  234. _mobile_number = value;
  235. base.addChange("mobile_number", value);
  236. }
  237. }
  238. [DataMember]
  239. public string land_number
  240. {
  241. get { return _land_number; }
  242. set
  243. {
  244. _land_number = value;
  245. base.addChange("land_number", value);
  246. }
  247. }
  248. [DataMember]
  249. public string land_number_extension
  250. {
  251. get { return _land_number_extension; }
  252. set
  253. {
  254. _land_number_extension = value;
  255. base.addChange("land_number_extension", value);
  256. }
  257. }
  258. [DataMember]
  259. public string fax_number
  260. {
  261. get { return _fax_number; }
  262. set
  263. {
  264. _fax_number = value;
  265. base.addChange("fax_number", value);
  266. }
  267. }
  268. [DataMember]
  269. public string email_id
  270. {
  271. get { return _email_id; }
  272. set
  273. {
  274. _email_id = value;
  275. base.addChange("email_id", value);
  276. }
  277. }
  278. [DataMember]
  279. public Int32? latitude_small
  280. {
  281. get { return _latitude_small; }
  282. set
  283. {
  284. _latitude_small = value;
  285. base.addChange("latitude_small", value);
  286. }
  287. }
  288. [DataMember]
  289. public Int32? longitude_smal
  290. {
  291. get { return _longitude_smal; }
  292. set
  293. {
  294. _longitude_smal = value;
  295. base.addChange("longitude_smal", value);
  296. }
  297. }
  298. [DataMember]
  299. public decimal? latitude_whole
  300. {
  301. get { return _latitude_whole; }
  302. set
  303. {
  304. _latitude_whole = value;
  305. base.addChange("latitude_whole", value);
  306. }
  307. }
  308. [DataMember]
  309. public decimal? longitude_whole
  310. {
  311. get { return _longitude_whole; }
  312. set
  313. {
  314. _longitude_whole = value;
  315. base.addChange("longitude_whole", value);
  316. }
  317. }
  318. [DataMember]
  319. public string created_by
  320. {
  321. get { return _created_by; }
  322. set
  323. {
  324. _created_by = value;
  325. base.addChange("created_by", value);
  326. }
  327. }
  328. [DataMember]
  329. public DateTime created_date
  330. {
  331. get { return _created_date; }
  332. set
  333. {
  334. _created_date = value;
  335. base.addChange("created_date", value);
  336. }
  337. }
  338. [DataMember]
  339. public string last_modified_by
  340. {
  341. get { return _last_modified_by; }
  342. set
  343. {
  344. _last_modified_by = value;
  345. base.addChange("last_modified_by", value);
  346. }
  347. }
  348. [DataMember]
  349. public DateTime last_modified_date
  350. {
  351. get { return _last_modified_date; }
  352. set
  353. {
  354. _last_modified_date = value;
  355. base.addChange("last_modified_date", value);
  356. }
  357. }
  358. }
  359. }