public int?AddGroup(Group group) { try { var values = new Dictionary <string, object> { { GlobalAppSettings.DbColumns.DB_Group.Name, group.GroupName }, { GlobalAppSettings.DbColumns.DB_Group.Description, group.GroupDescription }, { GlobalAppSettings.DbColumns.DB_Group.Color, group.GroupColor }, { GlobalAppSettings.DbColumns.DB_Group.IsActive, true }, { GlobalAppSettings.DbColumns.DB_Group.ModifiedDate, DateTime.UtcNow.ToString(GlobalAppSettings.GetDateTimeFormat()) } }; var output = new List <string> { GlobalAppSettings.DbColumns.DB_Group.GroupId }; var result = _dataProvider.ExecuteScalarQuery(_queryBuilder.AddToTable( GlobalAppSettings.DbColumns.DB_Group.DB_TableName, values, output)); if (result.Status) { return(Convert.ToInt32(result.ReturnValue)); } return(null); } catch (Exception e) { LogExtension.LogError("Error while adding group", e, MethodBase.GetCurrentMethod(), " GroupName - " + group.GroupName + " GroupDescription - " + group.GroupDescription + " GroupColor - " + group.GroupColor); return(null); } }
public bool AddUserInGroup(int userId, int groupId) { try { var values = new Dictionary <string, object> { { GlobalAppSettings.DbColumns.DB_UserGroup.GroupId, groupId }, { GlobalAppSettings.DbColumns.DB_UserGroup.UserId, userId }, { GlobalAppSettings.DbColumns.DB_UserGroup.IsActive, true }, { GlobalAppSettings.DbColumns.DB_UserGroup.ModifiedDate, DateTime.UtcNow.ToString(GlobalAppSettings.GetDateTimeFormat()) } }; var result = _dataProvider.ExecuteNonQuery( _queryBuilder.AddToTable(GlobalAppSettings.DbColumns.DB_UserGroup.DB_TableName, values)); return(result.Status); } catch (Exception e) { LogExtension.LogError("Error while add user in group", e, MethodBase.GetCurrentMethod(), " UserId - " + userId + " GroupId - " + groupId); return(false); } }