/IntVideoSurv.Business/UserGroupBusiness.cs

http://longchang.codeplex.com · C# · 198 lines · 177 code · 20 blank · 1 comment · 6 complexity · d2eef5cb33a8d8b4aef17c090dee7608 MD5 · raw file

  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using Microsoft.Practices.EnterpriseLibrary.Data;
  6. using System.Data;
  7. using IntVideoSurv.Entity;
  8. using IntVideoSurv.DataAccess;
  9. using log4net;
  10. using SMRemotingInterface;
  11. using videosource;
  12. using System.Drawing;
  13. namespace IntVideoSurv.Business
  14. {
  15. public class UserGroupBusiness
  16. {
  17. public static readonly ILog logger = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
  18. private static UserGroupBusiness instance;
  19. public static UserGroupBusiness Instance
  20. {
  21. get
  22. {
  23. if (instance == null)
  24. {
  25. instance = new UserGroupBusiness();
  26. }
  27. return instance;
  28. }
  29. }
  30. public int InsertUser(ref string errMessage, int userid, int groupid)
  31. {
  32. Database db = DatabaseFactory.CreateDatabase();
  33. errMessage = "";
  34. try
  35. {
  36. if (UserGroupDataAccess.GetTheUser(db, userid).Tables[0].Rows.Count != 0)
  37. {
  38. return -1;
  39. }
  40. else
  41. {
  42. return UserGroupDataAccess.InsertUser(db, userid, groupid);
  43. }
  44. //return DecoderDataAccess.InsertCamera(db, odecoder, ocamera);
  45. }
  46. catch (Exception ex)
  47. {
  48. errMessage = ex.Message + ex.StackTrace;
  49. logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
  50. return -1;
  51. }
  52. }
  53. public int Insert(ref string errMessage, UserGroupInfo oUserGroup)
  54. {
  55. Database db = DatabaseFactory.CreateDatabase();
  56. errMessage = "";
  57. try
  58. {
  59. return UserGroupDataAccess.Insert(db, oUserGroup);
  60. }
  61. catch (Exception ex)
  62. {
  63. errMessage = ex.Message + ex.StackTrace;
  64. logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
  65. return -1;
  66. }
  67. }
  68. public int Update(ref string errMessage, UserGroupInfo oUserGroup)
  69. {
  70. Database db = DatabaseFactory.CreateDatabase();
  71. errMessage = "";
  72. try
  73. {
  74. return UserGroupDataAccess.Update(db, oUserGroup);
  75. }
  76. catch (Exception ex)
  77. {
  78. errMessage = ex.Message + ex.StackTrace;
  79. logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
  80. return -1;
  81. }
  82. }
  83. public int DeleteUser(ref string errMessage, int userid)
  84. {
  85. Database db = DatabaseFactory.CreateDatabase();
  86. errMessage = "";
  87. try
  88. {
  89. int iRtn = UserGroupDataAccess.DeleteUser(db, userid);
  90. return iRtn;
  91. }
  92. catch (Exception ex)
  93. {
  94. errMessage = ex.Message + ex.StackTrace;
  95. logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
  96. return -1;
  97. }
  98. }
  99. public int Delete(ref string errMessage, int ID)
  100. {
  101. Database db = DatabaseFactory.CreateDatabase();
  102. errMessage = "";
  103. try
  104. {
  105. int iRtn = UserGroupDataAccess.Delete(db, ID);
  106. return iRtn;
  107. }
  108. catch (Exception ex)
  109. {
  110. errMessage = ex.Message + ex.StackTrace;
  111. logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
  112. return -1;
  113. }
  114. }
  115. public int DeleteByVirtualGroupID(ref string errMessage, int ID)
  116. {
  117. Database db = DatabaseFactory.CreateDatabase();
  118. errMessage = "";
  119. try
  120. {
  121. int iRtn = UserGroupDataAccess.DeleteByVirtualGroupID(db, ID);
  122. return iRtn;
  123. }
  124. catch (Exception ex)
  125. {
  126. errMessage = ex.Message + ex.StackTrace;
  127. logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
  128. return -1;
  129. }
  130. }
  131. public Dictionary<int, UserInfo> GetAllCameraInfo(ref string errMessage, int VirtualGroupId)
  132. {
  133. Database db = DatabaseFactory.CreateDatabase();
  134. errMessage = "";
  135. Dictionary<int, UserInfo> list = new Dictionary<int, UserInfo>();
  136. try
  137. {
  138. UserInfo oUserInfo;
  139. DataSet ds = UserGroupDataAccess.GetAllCameraInfo(db, VirtualGroupId);
  140. for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  141. {
  142. oUserInfo = new UserInfo(ds.Tables[0].Rows[i]);
  143. list.Add(oUserInfo.UserId, oUserInfo);
  144. }
  145. return list;
  146. }
  147. catch (Exception ex)
  148. {
  149. errMessage = ex.Message + ex.StackTrace;
  150. logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
  151. return new Dictionary<int, UserInfo>();
  152. }
  153. }
  154. public Dictionary<int, CameraInfo> GetCameraInfoByUserId(ref string errMessage, int userid)
  155. {
  156. Database db = DatabaseFactory.CreateDatabase();
  157. errMessage = "";
  158. Dictionary<int, CameraInfo> list = new Dictionary<int, CameraInfo>();
  159. try
  160. {
  161. CameraInfo oCameraInfo;
  162. DataSet ds = UserGroupDataAccess.GetCameraInfoByUserId(db, userid);
  163. for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  164. {
  165. oCameraInfo = new CameraInfo(ds.Tables[0].Rows[i]);
  166. list.Add(oCameraInfo.CameraId, oCameraInfo);
  167. }
  168. return list;
  169. }
  170. catch (Exception ex)
  171. {
  172. errMessage = ex.Message + ex.StackTrace;
  173. logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
  174. return null;
  175. }
  176. }
  177. }
  178. }