/// <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);
}
