/// <summary> /// Update UserGroup data to Database /// </summary> /// <param name="updateDto"> /// object that contains data to update /// </param> /// <returns> /// 0: insert successful /// others: Sql Exception /// </returns> public int UpdateData(IDto updateDto) { SYS_UserGroupsDao userGroupDao = new SYS_UserGroupsDao(); SYS_UserGroupsDto dto = (SYS_UserGroupsDto)updateDto; return(userGroupDao.UpdateData(dto)); }
/// <summary> /// Insert Permission for UserGroup /// </summary> /// <param name="insertDto"> /// object that contains data to insert /// </param> /// <returns> /// 0: insert successful /// others: Sql Exception /// </returns> public int InsertPermisionData(IDto insertDto) { SYS_UserGroupsDao userGroupDao = new SYS_UserGroupsDao(); SYS_UserGroupsDto dto = (SYS_UserGroupsDto)insertDto; return(userGroupDao.InsertPermissionData(dto)); }
/// <summary> /// Delete ItemGroup data from Database /// </summary> /// <param name="ListDto"> /// list object that contains data to delete /// </param> /// <returns> /// 0: insert successful /// others: Sql Exception /// </returns> public int DeleteData(List <IDto> listDto) { SYS_UserGroupsDao userGroupDao = new SYS_UserGroupsDao(); List <int> listDeleteData = new List <int>(); foreach (SYS_UserGroupsDto dto in listDto) { listDeleteData.Add(dto.Id); } return(userGroupDao.DeleteData(listDeleteData)); }
/// <summary> /// Search Data in UserGroup table /// </summary> /// <param name="iDto"> /// Dto of UserGroup form /// </param> /// <param name="dtResult"> /// Out a Datatable that contains search result(all columns) in UserGroup table /// </param> /// <returns> /// 0: Update successful /// 1: Access denied, login to database fail(invalid username, invalid password) /// 2: Invalid host, cannot find server(host) that set in app config file /// 3: Invalid database, cannot find database that set in DbConfig file /// 4: Lost connection, cannot connect to database because lost connection /// 5: Duplicate key: insert Primary Key or Unique Key that already exist in database /// 6: Forgeign key not exist: insert a foreign key that not exist in primary key /// 7: Foreign Key Violation: Foreign Key Violation (delete primary key that is foreign key in other table) /// 8: Data not found: Delete or Update data that not exist in database /// 9: Exception occured: other exception /// </returns> public int SearchData(IDto searchDto, out DataTable dtResult) { int returnCode = CommonData.DbReturnCode.Succeed; SYS_UserGroupsDao mSUG00Dao = new SYS_UserGroupsDao(); SYS_UserGroupsDto dto = (SYS_UserGroupsDto)searchDto; //Select group returnCode = mSUG00Dao.SelectData(dto, out dtResult); //Select user DataTable dtDetail = new DataTable(); dtDetail.Columns.Add(CommonKey.UserCode, typeof(string)); dtDetail.Columns.Add(CommonKey.DisplayName, typeof(string)); dtDetail.Columns.Add(CommonKey.Status, typeof(string)); dtDetail.Columns.Add(CommonKey.GroupCode, typeof(string)); DataTable dtDetailTerm = new DataTable(); foreach (DataRow row in dtResult.Rows) { SYS_UserGroupsDto groupDto = new SYS_UserGroupsDto() { Code = CommonMethod.ParseString(row[CommonKey.Code]), }; returnCode = this.SelectUsersByGroup(groupDto, out dtDetailTerm); if (returnCode != 0) { return(returnCode); } foreach (DataRow detailRow in dtDetailTerm.Rows) { dtDetail.Rows.Add(detailRow[CommonKey.UserCode] , detailRow[CommonKey.DisplayName] , detailRow[CommonKey.Status] , detailRow[CommonKey.GroupCode] ); } } #region Create relationship DataSet dataSet = new DataSet(); dataSet.Tables.Add(dtResult); dataSet.Tables.Add(dtDetail); dataSet.Relations.Add(" ", dataSet.Tables[0].Columns[CommonKey.Code], dataSet.Tables[1].Columns[CommonKey.GroupCode]); #endregion return(returnCode); }